LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SS01_UG01_UG02

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

P41/51/51a
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
SAMPLE_AREA_NO

VARCHAR2(5)

P41/51/51a
Number used to reference all samples taken from one area of the project - used only for SPS-5, 6, and 7 project.
SAMPLE_NO

VARCHAR2(7)

P41/51/51a
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

P41/51/51a
Date the test was performed.
THREE_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 3" sieve.
TWO_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 2" sieve.
ONE_AND_HALF_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 1 1/2" sieve.
ONE_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 1" sieve.
THREE_FOURTHS_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 3/4" sieve.
ONE_HALF_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 1/2" sieve.
THREE_EIGHTHS_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the 3/8" sieve.
STATE_CODE
STATE_PROVINCENUMBER(2)

P41/51/51a
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
NO_4_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the #4 sieve.
NO_10_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the #10 sieve.
NO_40_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the #40 sieve.
NO_80_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the #80 sieve.
NO_200_PASSING

NUMBER(4,1)
%
P41/51/51a
Percent unbound/base material passing the #200 sieve.
WASHING_PASSING

NUMBER(4,1)
%
P41/51
Percent unbound/base material passing the #200 sieve by washing.
COMMENTS_1
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
LAYER_NO

NUMBER(2)

P41/51/51a
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
COMMENTS_5
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P41/51/51a
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P41/51/51a
A note used to record additional observations regarding the test, or test results.
SAMPLE_WT

NUMBER(4,1)
lb
P41/51/51a
Weight of the test sample as described in AASHTO T27.
MOISTURE_CONTENT

NUMBER(2)
%
P41/51/51a
Moisture content as determined in protocol 49, form T49.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
FIELD_SET

NUMBER(2)

P41/51/51a
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)

P41/51/51a
Code number indicating sample location.
SHRP_TEST
SHRP_TESTVARCHAR2(5)


Code indicating the SHRP test designation.
LOC_NO

VARCHAR2(6)

P41/51/51a
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)

P41/51/51a
Code indicating the lab that performed the testing.