LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SMP_COMMENT

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.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(4)


Internal number indicating the sequence in which the comments were entered for a section, table, and comment type.
COMMENT_TYPE

VARCHAR2(10)


Text indicating if comment is a data specific comment applying to a specific data set, a general comment applying to a section, or if it is a comment directly related to a QC report.
SMP_COMMENT_DATE

DATE


Either SMP_DATE or INSTALL_DATE as appropriate to the related table and record.
TABLE_NAME

VARCHAR2(32)


Table name that contains the data for which the comment is relevant.
SMP_COMMENT

VARCHAR2(240)


General comment relating to table and section indicated in the record.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.