LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TRAFFIC_ANALYSIS_TRACKER

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

DATE


The last date the monthly volume table was updated.
YY_CL_DATE

DATE


The last date the yearly count table was updated for classification counts.
YY_WT_DATE

DATE


The last date the yearly weight related tables were updated.
YY_VOL_DATE

DATE


The last date the yearly volume table was updated.
IMS_DATE

DATE


The last time the IMS tables were created for this year.
SPS_COMP_CL_DATE

DATE


The last date the SPS Class comparison tables were updated.
UPLOAD_IMS_CL
Y_NVARCHAR2(1)


A field set by QC or the user to prevent inclusion of class data for a year in the IMS.
UPLOAD_IMS_WT
Y_NVARCHAR2(1)


A field set by QC or the user to prevent inclusion of weight data for a year in the IMS.
SPS_COMP_WT_DATE

DATE


The last date the SPS Class comparison tables were updated.
LOAD_METHOD_CL
LOAD_METHODVARCHAR2(1)


Indicates if the site was loaded using the LTQC and Daily process (Q) or the raw files were loaded into LTAS (A).
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
LOAD_METHOD_WT
LOAD_METHODVARCHAR2(1)


Indicates if the site was loaded using the LTQC and Daily process (Q) or the raw files were loaded into LTAS (A).
COMMENTS

VARCHAR2(2000)


Comments on review of completeness of processing.
REPROCESS_CODE

NUMBER(6)


Code value indicating completeness of processing, values under 1000 indicate complete with codes varying by types of actions done or undone.
YEAR

NUMBER(4)


The year affected by the reprocessing.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
DD_CL_DATE

DATE


The last date a daily classification file was processed.
DD_WT_DATE

DATE


The last date a weight file in either 7W or HW format was processed.
DD_VOL_DATE

DATE


The last date a volume file was processed.
MM_CL_DATE

DATE


The last date the monthly count table was updated for classification counts.
MM_WT_DATE

DATE


The last date the monthly weight related tables were updated.