LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_PC05

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

VARCHAR2(7)

P65
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

P65
Date the test was performed.
WEIGHT_OF_OVEN_DRIED_IN_AIR

NUMBER(6,1)
g
P65
Weight of the oven-dried specimen in air.
WEIGHT_SDS_AIR_IMMERSION

NUMBER(6,1)
g
P65
Weight of the surface-dry specimen in air after immersion.
WEIGHT_SDS_AIR_IMMERSION_BOIL

NUMBER(6,1)
g
P65
Weight of the surface-dry specimen in air after immersion and boiling.
WEIGHT_WATER_IMMERSION_BOIL

NUMBER(6,1)
g
P65
Weight of the specimen in water after immersion and boiling.
PERCENT_ABSORPTION_AFTER_IMMER

NUMBER(2,1)
%
P65
Percent absorption after immersion.
BULK_SPECIFIC_GRAVITY_DRY

NUMBER(4,2)

P65
Dry bulk specific gravity of the specimen.
APPARENT_SPECIFIC_GRAVITY

NUMBER(4,2)

P65
Apparent specific gravity of the specimen.
DENSITY_OF_PCC

NUMBER(4,1)
pcf
P65
Density of the specimen.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(3,1)
%
P65
Percent air voids in PCC.
COMMENTS_1
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P65
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P65
A 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.
LAYER_NO

NUMBER(2)

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

NUMBER(2)

P65
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)

P65
Code number indicating sample location.
LOC_NO

VARCHAR2(6)

P65
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.
SAMPLE_AREA_NO

VARCHAR2(5)

P65
Number used to reference all samples taken from one area of the project - used only for SPS-5, 6, and 7 project.
LAB_CODE
LAB_CODEVARCHAR2(4)

P65
Code indicating the lab that performed the testing.