LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRAFFIC_RS_CHANGES

Field NameCodesData TypeUnitsTest ProtocolDescription
CHANGE_ID

NUMBER(6)


System generated sequential number to identify the record status change. Each region begins with a different value.
END_DATE

DATE


End of interval for which the data applies
FROM_RECORD_STATUS

VARCHAR2(1)


The record status to change.
TO_RECORD_STATUS

VARCHAR2(1)


The resulting record status
DATE_APPLIED

DATE


The date the user applied the change to the record status.
DATA_TABLE

VARCHAR2(31)


The table the record status modification was applied to.
USER_NAME

VARCHAR2(31)


The ORACLE user name for which this information is stored.
COMMENTS

VARCHAR2(2000)


Comments entered in the comments box of the Modify Record Status dialog box.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
LANE_TRF

NUMBER(1)


The number of the lane to which this data applies.
DIR_TRF
DIR_TRFNUMBER(1)


The direction to which the data applies.
VEHICLE_CLASS
VEHICLE_CLASSNUMBER(2)


The vehicle classification for the table being purged either Agency specified or the 13-bin FHWA scheme.
AXLE_GROUP
AXLE_GROUPNUMBER(1)


Type of axle to which this data applies.
TRF_DATA_TYPE
TRF_DATA_TYPENUMBER(1)


The source of the data, weight or class, for the count.
START_DATE

DATE


Beginning of the interval for which the data applies.