LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: RHB_CAUSE_INFO

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
RHB_DIS_WP_CRACK
Y_NVARCHAR2(1)


Code indicating if wheel path cracking contributed to rehabilitation decision.
RHB_DIS_NWP_CRACK
Y_NVARCHAR2(1)


Code indicating if non-wheel path cracking contributed to rehabilitation decision.
RHB_DIS_RAVELING
Y_NVARCHAR2(1)


Code indicating if raveling contributed to rehabilitation decision.
RHB_DIS_JNT_SPALL
Y_NVARCHAR2(1)


Code indicating if joint spalling contributed to rehabilitation decision.
RHB_DIS_RUTTING
Y_NVARCHAR2(1)


Code indicating if rutting contributed to rehabilitation decision.
RHB_DIS_SHOVING
Y_NVARCHAR2(1)


Code indicating if shoving contributed to rehabilitation decision.
RHB_DIS_BLEEDING
Y_NVARCHAR2(1)


Code indicating if bleeding contributed to rehabilitation decision.
RHB_DIS_PUNCHOUT
Y_NVARCHAR2(1)


Code indicating if punch outs contributed to rehabilitation decision.
RHB_DIS_ROUGHNESS
Y_NVARCHAR2(1)


Code indicating if roughness contributed to rehabilitation decision.
RHB_DIS_FAULTING
Y_NVARCHAR2(1)


Code indicating if faulting contributed to rehabilitation decision.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
RHB_DIS_SCALING
Y_NVARCHAR2(1)


Code indicating if scaling contributed to rehabilitation decision.
RHB_DIS_CONDITION_IDX
Y_NVARCHAR2(1)


Code indicating if condition index contributed to rehabilitation decision.
RHB_DIS_SURF_FRICTION
Y_NVARCHAR2(1)


Code indicating if surface friction contributed to rehabilitation decision.
RHB_DIS_POL_AGG
Y_NVARCHAR2(1)


Code indicating if polished aggregate contributed to rehabilitation decision.
RHB_DIS_POTHOLE
Y_NVARCHAR2(1)


Code indicating if potholes contributed to rehabilitation decision.
RHB_DIS_OTHER
Y_NVARCHAR2(1)


Code indicating if there are other pavement condition distresses that contributed to rehabilitation decision.
RHB_DIS_OTHER_TYPE

VARCHAR2(60)


Comment describing other pavement condition distresses triggering rehabilitation.
RHB_REASON_ADDED_LANE
Y_NVARCHAR2(1)


Code indicating if the addition of lanes to the road on which the test section is located caused rehabilitation.
RHB_REASON_ROUTE_REALIGN
Y_NVARCHAR2(1)


Code indicating if route realignment of the road on which the test section is located caused rehabilitation.
RHB_REASON_ADJ_LAND_USE
Y_NVARCHAR2(1)


Code indicating if land use changes adjacent to the test section caused rehabilitation.
DATE_RHB_SCHEDULED

VARCHAR2(7)


Scheduled date for start of rehabilitation activities.
RHB_REASON_POLITICAL
Y_NVARCHAR2(1)


Code indicating if political reasons caused rehabilitation.
RHB_REASON_NON_PAVE_OTHER
Y_NVARCHAR2(1)


Code indicating if there are other non-pavement condition related reasons for rehabilitation.
RHB_REASON_NON_PAVE_COMMENT

VARCHAR2(60)


Description of other non-pavement condition related reasons for rehabilitation (if any).
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
PRE_RHB_CN

NUMBER(2)


Construction number corresponding to the pavement structure being rehabilitated.
PRE_RHB_CN_DATE

DATE


Reference date used to compute PRE_RHB_CN.
PRIMARY_REASON_RHB
PRIMARY_REASON_RHBVARCHAR2(1)


Code indicating the primary reason for rehabilitation (pavement condition or other)
GEN_PAVEMENT_RHB_CAUSE
GEN_PAVEMENT_RHB_CAUSEVARCHAR2(1)


Code indicating the primary pavement condition causing rehabilitation.
GEN_PAVEMENT_RHB_CAUSE_OTHER

VARCHAR2(60)


Primary pavement condition causing rehabilitation if other than those specified.