LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SC11

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

NUMBER(3,2)

H15L
Bulk specific gravity of the aggregate for the chip seal mix design.
AVG_LEAST_DIMENSION

NUMBER(3,2)
in
H15L
Average least dimension for the chip seal mix design.
AGG_WASTAGE_FACTOR

NUMBER(3,2)

H15L
Aggregate wastage factor for the chip seal mix design.
AGG_SPREAD_RATE

NUMBER(3,1)
lb/sq yd
H15L
Aggregate spread rate for the chip seal mix design.
TRAFFIC_FACTOR

NUMBER(3,2)

H15L
Traffic factor for the chip seal mix design.
SURFACE_CONDITION_VAR

NUMBER(3,2)
gal/sq yd
H15L
Surface condition variable for the chip seal mix design.
RESIDUAL_ASPH_SPREAD_RATE

NUMBER(3,2)
gal/sq yd
H15L
Residual asphalt spread rate for the chip seal mix design.
TEST_DATE

DATE

H15L
Date the test was performed.
GENERAL_REMARK

VARCHAR2(40)

H15L
Note used to record additional observations regarding the test, or test results.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)

H15L
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
LAYER_NO

NUMBER(2)

H15L
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
FIELD_SET

NUMBER(2)

H15L
Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
LOC_NO

VARCHAR2(6)

H15L
Unique code number assigned to each sampling location indicating the sample type. The single character prefix indicates the sample type. The numeric suffix is the unique project location for the sample type.
TEST_NO
TEST_NONUMBER(2)

H15L
Code number indicating sample location.
SAMPLE_NO

VARCHAR2(7)

H15L
Unique code number assigned to each material sample indicating the sample type and material type. The first character indicates the sample type. The second character indicates the material type. The numeric suffix is the unique sample number for the sample type and material type.
LAB_CODE
LAB_CODEVARCHAR2(4)

H15L
Code indicating the lab that performed the testing.
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.