LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_PC08

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

VARCHAR2(7)

P68
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.
TRAVERSE_LENGTH_AIR

NUMBER(5,3)
im
P68
Length of linear traverse that intersected an air void.
TRAVERSE_LENGTH_PASTE

NUMBER(5,3)
im
P68
Length of linear traverse that intersected the cement paste portion of the concrete specimen.
TRAVERSE_LENGTH_TOTAL

NUMBER(3)
im
P68
Total length of linear traverse.
NO_AIR_VOIDS

NUMBER(5)

P68
Number of air voids intersected over the entire linear traverse.
AIR_CONTENT

NUMBER(3,1)
%
P68
Measured air content percentage by volume in Portland Cement Concrete mix.
AVG_CHORD_LENGTH

NUMBER(4,4)

P68
Average length of the chords formed by the transection of the air voids by the line of traverse.
SPECIFIC_SURFACE

NUMBER(4)
1/in
P68
Surface area of the air voids divided by their volume.
SPACING_FACTOR

NUMBER(3,3)
in
P68
Parameter related to the maximum distance in the cement paste from the periphery of an air void.
PASTE_AIR_RATIO

NUMBER(5,3)

P68
Ratio of the volume of hardened cement paste to the volume of air voids in the concrete.
STATE_CODE
STATE_PROVINCENUMBER(2)

P68
Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
COMMENT_1
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_2
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_3
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_4
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_5
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_6
COMMENTNUMBER(2)

P68
Code for miscellaneous comments or notes.
COMMENT_OTHER

VARCHAR2(40)

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

DATE

P68
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
LAYER_NO

NUMBER(2)

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

NUMBER(2)

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

P68
Code number indicating sample location.
LOC_NO

VARCHAR2(6)

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

P68
Code indicating the lab that performed the testing.
SAMPLE_AREA_NO

VARCHAR2(5)

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