LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MON_HSS_VISIT_NO

Field NameCodesData TypeUnitsTest ProtocolDescription
VISIT_NO

VARCHAR2(10)


Unique identification for each site visit made by profiling equipment.
SURFACE_FINISH_COMMENT

VARCHAR2(100)


Comment identifying any additional information related to the surface finish for texture measurements.
NO_FAULT_LOCATIONS

NUMBER(3)


Number of locations with measured faulting in the most recent distress survey.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
UNIT_ID

VARCHAR2(8)


Unique identification for each configuration of each unit used to collect profile data.
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.
CONSTRUCTION_NO

NUMBER(2)


Event number used to relate changes in pavement structure with other time dependent data elements. This field is set to 1 when a test section is initially accepted into LTPP and is incremented with each change to the layer structure.
VISIT_DATE

DATE


Date the profile visit was started.
OPERATOR_AND_DRIVER

VARCHAR2(20)


Name of the vehicle operator/driver.
SURFACE_CONDITION

VARCHAR2(20)


Description of the surface condition.
SURFACE_FINISH_TYPE

VARCHAR2(100)


The type of surface finish for texture measurements.