LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SS12

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

P60
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
COMMENTS_3
COMMENTNUMBER(2)

P60
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P60
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P60
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P60
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P60
A note used to record additional observations regarding the test, or test results.
TEST_DATE

DATE

P60
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
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.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(2)

P60
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
FIELD_SET

NUMBER(2)

P60
Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
LOC_NO

VARCHAR2(6)

P60
Unique code number assigned to each sampling location indicating the sample type. The single character prefix indicates the sample type. The numeric suffix is the unique project location for the sample type.
LAB_CODE
LAB_CODEVARCHAR2(4)

P60
Code indicating the lab that performed the testing.
TOTAL_PVR

NUMBER(4,2)
in
P60
Value for total PVR.
COMMENTS_1
COMMENTNUMBER(2)

P60
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P60
Code for testing comments.