LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_BENKELMAN_MEASURE

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

NUMBER(4,2)
mils

Measured deflection at the approach side of the joint/crack.
DEFLECTION_LEAVE

NUMBER(4,2)
mils

Measured deflection at the leave side of the joint/crack.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
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.
DATE_COMPLETE

DATE


Date activity was completed.
BEFORE_AFTER_REGROUT
BEFORE_AFTERNUMBER(1)


Code indicating if undersealing was performed before or after regrouting.
STATION

NUMBER(5,1)
ft

Section station number.
LOCATION_OF_AXLE
SIDE_LOCATIONNUMBER(1)


Code indicating which side of joint the axle was located.
JOINT_NO

NUMBER(3)


Sequential number assigned to pavement joint.
TESTING_AT
LOCATION_ATNUMBER(1)


Code indicating if test was located at a pavement joint or crack.