LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_TB01

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

VARCHAR2(4)

P31
Identification of the cores to be tested.
DESIG_CORE_2

VARCHAR2(4)

P31
Identification of the cores to be tested.
DESIG_CORE_3

VARCHAR2(4)

P31
Identification of the cores to be tested.
DESIG_PROTOCOL

VARCHAR2(10)

P31
Designated protocol used to test cores for preliminary identification.
SOIL_GEOL
GEOL_CLASSNUMBER(3)

P31
Code for geological classification of extracted aggregate.
SOIL_GEOL_OTHER

VARCHAR2(40)

P31
Text field that is used to enter additional information about the geology.
SOIL_COLOR

VARCHAR2(20)

P31
Description of the soil color.
THICKNESS

NUMBER(3,1)
in
P31
Thickness of the sample.
THICKNESS_CODE
THICKNESS_CODENUMBER(2)

P31
Code describing how the layer thickness was determined.
PRELIM_TREAT_MATL
TREAT_TYPENUMBER(3)

P31
Preliminary description of the treated material.
STATE_CODE
STATE_PROVINCENUMBER(2)

P31
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
PRELIM_TREAT_TYPE
TREAT_TYPENUMBER(3)

P31
Preliminary description of the treatment type.
DETAIL_TREAT_MATL
TREAT_TYPENUMBER(3)

P31
Code indicating the treated material type.
DETAIL_TREAT_TYPE
TREAT_TYPENUMBER(3)

P31
Code indicating the type of treatment of the material.
TREAT_MATL_NOTE

VARCHAR2(40)

P31
Note concerning the treatment material.
TREAT_TYPE_NOTE

VARCHAR2(40)

P31
Note concerning the treatment type.
VISUAL_EXAM_1
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
VISUAL_EXAM_2
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
VISUAL_EXAM_3
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
VISUAL_EXAM_4
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
VISUAL_EXAM_5
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
LAYER_NO

NUMBER(2)

P31
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
VISUAL_EXAM_6
VISUAL_ACPCNUMBER(2)

P31
Code for visual examination comments.
VISUAL_EXAM_OTHER

VARCHAR2(40)

P31
Visual examination comments if other than those specified.
AGGR_TYPE
AGGR_TYPENUMBER(3)

P31
Code indicating aggregate type of the sample material.
AGGR_TYPE_OTHER

VARCHAR2(40)

P31
Aggregate type of samples material if other than those specified.
COMMENTS_1
COMMENTNUMBER(2)

P31
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P31
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P31
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P31
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P31
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P31
Code for testing comments.
FIELD_SET

NUMBER(2)

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

VARCHAR2(40)

P31
A note used to record additional observations regarding the test, or test results.
DESC_CODE_1
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_2
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_3
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_4
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_5
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_6
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_7
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_8
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
DESC_CODE_9
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
TEST_NO
TEST_NONUMBER(2)

P31
Code number indicating sample location.
DESC_CODE_10
SOIL_CRITERIANUMBER(4)

P31
Code indicating visual characteristics of sample.
SAMPLE_NO

VARCHAR2(7)

P31
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.
TEST_DATE

DATE

P31
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
LOC_NO

VARCHAR2(6)

P31
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.
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.
LAB_CODE
LAB_CODEVARCHAR2(4)

P31
Code indicating the lab that performed the testing.
SAMPLE_AREA_NO

VARCHAR2(5)

P31
Number used to reference all samples taken from one area of the project - used only for SPS-5, 6, and 7 project.