LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: AWS_COMMENT

Field NameCodesData TypeUnitsTest ProtocolDescription
AWS_ID

VARCHAR2(6)


AWS identification (STATE_CODE and SHRP_ID of closest SPS project).
ORDER_NO

NUMBER(3)


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 general comment applying to weather station, or if it is a comment directly related to a QC report.
AWS_COMMENT_DATE

DATE


Either AWS_DATE or AWS_INSTALL_DATE depending on related table and record.
TABLE_NAME

VARCHAR2(32)


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

VARCHAR2(240)


Comment related to AWS data.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.