LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_UNBOUND_SPEC_GRAV

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

DATE


Date specimen was tested.
LAB_CODE
LAB_CODEVARCHAR2(4)


A code indicating the lab that performed the testing.
COMMENT_1
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENT_2
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENT_3
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENT_4
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENT_5
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENT_6
COMMENTNUMBER(2)


Code for miscellaneous comments or notes.
COMMENTS_OTHER

VARCHAR2(40)


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

VARCHAR2(4)


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

VARCHAR2(7)


Unique code number assigned to each material sample indicating the sample type and material type. The first character indicates the sample type. The second character indicates the material type. The numeric suffix is the unique sample number for the sample type and material type.
LAYER_NO

NUMBER(2)


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

NUMBER(2)


Code number indicating sample location.
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.
FIELD_SET

NUMBER(2)


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

NUMBER(4,3)


Specific gravity.