LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS6_NOTES_AND_COMMENTS

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

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_9

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_10

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_11

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
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.
COMMENT_1

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_2

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_3

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_4

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_5

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_6

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction
COMMENT_7

VARCHAR2(76)


Miscellaneous comments or notes. SPS Construction