LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SS04_UG08

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

P47/P52
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
SAMPLE_AREA_NO

VARCHAR2(5)

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

VARCHAR2(40)

P47/P52
Description of the range of particle sizes present in the sample.
MAX_PART_SIZE

VARCHAR2(40)

P47/P52
Maximum particle size of the soil.
SOIL_COLOR

VARCHAR2(40)

P47/P52
Description of the soil color.
DESC_CODE_1
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_2
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_3
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_4
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_5
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_6
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
STATE_CODE
STATE_PROVINCENUMBER(2)

P47/P52
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
DESC_CODE_7
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_8
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_9
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
DESC_CODE_10
SOIL_CRITERIANUMBER(4)

P47/P52
Code indicating visual characteristics of sample.
VISUAL_CLASS
MATERIALNUMBER(3)

P47/P52
Code indicating the visual classification of the base/subbase/subgrade material.
AASHTO_SOIL_CLASS
S_CLASSNUMBER(3)

P52
Code for AASHTO soil classification for subgrade material.
MR_MATL_TYPE

NUMBER(1)

P47/P52
Material type for use in resilient modulus testing.
COMMENTS_1
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
LAYER_NO

NUMBER(2)

P47/P52
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
COMMENTS_4
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P47/P52
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P47/P52
A note used to record additional observations regarding the test, or test results.
TEST_DATE

DATE

P47/P52
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
FIELD_SET

NUMBER(2)

P47/P52
Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
TEST_NO
TEST_NONUMBER(2)

P47/P52
Code number indicating sample location.
LOC_NO

VARCHAR2(6)

P47/P52
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)

P47/P52
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.
LAB_CODE
LAB_CODEVARCHAR2(4)

P47/P52
Code indicating the lab that performed the testing.