LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MNT_HIST

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


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

NUMBER(3,1)
in

Increase in pavement thickness, if any, from the improvement activity.
MAJOR_IMP_COST

NUMBER(3)
1000s $/lane mi

Total cost for the major improvement, excluding non-pavement costs.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
IMP_QUANTITY_UNITS
UNITSVARCHAR2(30)


Units defined by MAINT_WORK code in MAJOR_IMP_TYPE field.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(4)


Key generated by the computer to insure uniqueness of records.
MAJOR_IMP_YEAR

NUMBER(4)


Year in which the maintenance activity occurred.
CASE_NO

NUMBER(4)


Maintenance case number.
MAJOR_IMP_TYPE
MAINT_WORKNUMBER(2)


Code indicating type of work performed.
MAINT_LOC
LOCATIONNUMBER(2)


Code identifying where on the roadway the maintenance was conducted
MAINT_MATERIAL
MAINT_MATNUMBER(2)


Code to identify the materials used to perform the maintenance.
MAJOR_IMP_QUANTITY

NUMBER(5)
varies

Quantity of work performed.