LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_PC03

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)

P63
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
LAB_CODE
LAB_CODENUMBER(4)

P63
Code indicating the lab that performed the testing.
THICKNESS

NUMBER(4,1)
mm
P63
Average test specimen thickness.
DIAMETER

NUMBER(4,1)
mm
P63
Diameter of the sample.
COEF_THERMAL_EXPANSION

NUMBER(8,7)
mm/mm/deg C
P63
Coefficient of Thermal Expansion value.
EQUIP_MANUFACTURER
EQUIP_MANUFACTURERVARCHAR2(1)


Code indicating the name of the manufacturer of the CTE test equipment.
PRIMARY_AGG_CLASS
AGG_CLASSVARCHAR2(3)


Code indicating the primary type of coarse aggregate in PCC test specimen.
SECONDARY_AGG_CLASS
AGG_CLASSVARCHAR2(3)


Code indicating the secondary type of coarse aggregate in PCC test specimen.
TEST_DATE

DATE


Date the test was performed.
COMMENT_OTHER
COMMENTVARCHAR2(40)


A note used to record additional observations regarding the test, or test results.
SHRP_ID

VARCHAR2(4)

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

NUMBER(2)

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

NUMBER(2)


Number indicating repeat tests on the same specimen.
FIELD_SET

NUMBER(2)

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

VARCHAR2(6)

P63
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.
SAMPLE_NO

VARCHAR2(7)

P63
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.
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.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.