LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRAFFIC_PURGES

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.
PURGE_CODE
TRF_ORA_ERRNUMBER(3)


Code that indicates reason for Purge.
PENDING_DATE

DATE


Date to purge but not applied to the data.
PURGED_DATE

DATE


Date purged from data.
COMMENTS

VARCHAR2(500)


Comments entered in the comments box of the Purge Detail dialog box.
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.
YEAR

NUMBER(4)


Year the data was collected.
START_DATE

DATE


Beginning of the interval for which the data applies.
TRF_DATA_TYPE
TRF_DATA_TYPENUMBER(1)


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

DATE


End of interval for which the data applies
USER_NAME

VARCHAR2(20)


The ORACLE user name for which this information is stored.