LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: CONSTRUCTION_EVENTS

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.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
SHRP_ID

VARCHAR2(4)


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

DATE


Date improvements were performed.
IMP_TYPE
MAINT_WORKVARCHAR2(2)


Code for type of maintenance or rehabilitation work performed.
CONSTRUCTION_NO

NUMBER(2)


Event number used to relate changes in pavement structure with other time dependent data elements. This field is set to 1 when a test section is initially accepted into LTPP and is incremented with each change to the layer structure.
IMP_QUANTITY

NUMBER(5)
See Table A.17

Quantity of work performed.
IMP_THICKNESS

NUMBER(3,1)
in

Improvement thickness.
IMP_COST

NUMBER(3)
1000s $/lane mi

Cost (x 1000) per lane mile.
IMP_QUANTITY_UNITS
UNITSVARCHAR2(30)


Units defined by MAINT_WORK code in IMP_TYPE field.