LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SS14_UG14_COMMENT

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

VARCHAR2(4)

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

VARCHAR2(6)

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

DATE

P72
Date the test was performed.
COMMENT_NO

NUMBER(2)

P72
Unique number used to identify each comment.
RECORD_STATUS

VARCHAR2(1)

P72
A code indicating the general quality of the data.
COMMENT_CODE
COMMENTVARCHAR2(2)

P72
Code for testing comment.