LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: EXPERIMENT_SECTION

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

DATE


Date when a test section was assigned to the LTPP experiment. The experiment designation for a test section is the combination of EXPERIMENT_NO and GPS_SPS fields in the record.
DEASSIGN_DATE

DATE


Date when a test section changed to another experiment or was placed in out of study status in the LTPP program (status = o).
SEAS_ID

VARCHAR2(1)


State specific seasonal identification code.
SUPPLEMENTAL

VARCHAR2(1)


A marker to identify state supplemental sections.
EXP_SECT_RS

VARCHAR2(1)


RECORD_STATUS for EXPERIMENT_SECTION table.
BASIC_INFO_RS

VARCHAR2(1)


RECORD_STATUS from minimum RECORD_STATUS for selected BASIC_INFO tables.
PAV_STRUCT_RS

VARCHAR2(1)


RECORD_STATUS from minimum RECORD_STATUS of all layers for tst_l05b for this SHRP_ID, STATE_CODE, and CONSTRUCTION_NO.
TRAFFIC_RS

VARCHAR2(1)


RECORD_STATUS from maximum RECORD_STATUS for selected monitoring traffic tables.
CLIMATIC_RS

VARCHAR2(1)


RECORD_STATUS from maximum RECORD_STATUS for selected climatic tables.
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.
CN_ASSIGN_DATE

DATE


The assignment date for the beginning of a construction event. It is equal to acceptance date when a test section is first included in LTPP, i.e. CONSTRUCTION_NO = 1.
CN_CHANGE_REASON
MAINT_WORKVARCHAR2(30)


IMP_TYPE codes) from MNT_IMP and/or RHB_IMP that are the reasons) for this Construction Number (CONSTRUCTION_NO).
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
GPS_SPS
GPS_SPSVARCHAR2(1)


Code indicating if the section is a GPS or SPS section.
EXPERIMENT_NO
EXPERIMENTVARCHAR2(3)


Code indicating to which LTPP experiment the pavement section is assigned.
STATUS
STATUSVARCHAR2(2)


Code indicating the status of a section for a given construction event.