LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS9_SUBGRADE_PREP

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.
STABIL_AGENT1
STABIL_AGENT_SPSVARCHAR2(1)


Code indicating the stabilizing agent type used.
STABIL_AGENT1_OTHER

VARCHAR2(40)


Stabilizing agent type used if other than those specified.
STABIL_AGENT1_PERCENT

NUMBER(3,1)
%

Percent of stabilizing agent used.
STABIL_AGENT2
STABIL_AGENT_SPSVARCHAR2(1)


Code indicating the stabilizing agent type used.
STABIL_AGENT2_OTHER

VARCHAR2(40)


Stabilizing agent type used if other than those specified.
STABIL_AGENT2_PERCENT

NUMBER(3,1)
%

Percent of stabilizing agent used.
LIFT_THICKNESS

NUMBER(2)
in

Nominal placement thickness of subgrade fill material.
SIGNIFICANT_EVENTS

VARCHAR2(80)


Any significant event occurring during construction that may influence performance.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(1)


A code indicating the general quality of the data.
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.
DATE_BEGAN

DATE


Date operations began.
DATE_COMPLETE

DATE


Date activity was completed.
COMPACTION_EQUIP_TYPE
COMPACTION_EQUIP_TYPEVARCHAR2(1)


Code indicating type of compaction equipment used.
COMPACTION_EQUIP_TYPE_OTHER

VARCHAR2(40)


Type of compaction equipment used if other than those specified.
GROSS_WEIGHT

NUMBER(3,1)
tons

Gross weight of primary compaction equipment.