LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_DYNAFLECT_GENERAL

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

NUMBER(3)
%

Humidity at beginning of testing.
END_HUMIDITY

NUMBER(3)
%

Humidity at end of testing.
SURFACE_MOISTURE
SURFACE_MOISTURE_SPS34NUMBER(1)


Code indicating pavement surface moisture condition at time of testing.
TEST_PURPOSE
TEST_PURPOSENUMBER(1)


Code indicating purpose of test.
DEVICE_SOURCE
DEVICE_SOURCENUMBER(1)


Code indicating source of testing device.
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.
DATE_BEGAN

DATE


Date operations began.
TIME_COMPLETE

VARCHAR2(4)
hhmm

Time deflection measurements completed.
TIME_BEGAN

VARCHAR2(4)
hhmm

Time deflection measurements began.
BEGIN_AIR_TEMP

NUMBER(3)
deg F

Air temperature at beginning of testing.
END_AIR_TEMP

NUMBER(3)
deg F

Air temperature at end of testing.