LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: COMMENTS_GENERAL

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)


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

NUMBER(3)


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

DATE


Date of the comment.
TABLENAME

VARCHAR2(30)


Name of the table to which the comment applies. Can indicate a group of tables if only a prefix is supplied.
GENERAL_COMMENT

VARCHAR2(240)


General comment about the LTPP section that could relate to any or all of the data collected.