LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_TB02

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

NUMBER(3,2)
in
P32
Diameter of core.
P32_METHOD
P32_METHODVARCHAR2(1)

P32
Code indicating whether test method T32A or B was used to test the treated sample.
GRAPH
Y_NVARCHAR2(1)

P32
Code indicating whether a graph of the stress-strain data was attached with the test data.
ORIGINAL_LENGTH

NUMBER(3,1)
in
P32
Length of core before capping.
CAPPED_LENGTH

NUMBER(3,1)
in
P32
Length of core after capping.
LD_RATIO

NUMBER(3,2)

P32
Ratio of length to diameter.
CROSS_SECTION_AREA

NUMBER(4,2)
sq in
P32
Cross sectional area of the cores.
MAX_LOAD

NUMBER(6)
lbf
P32
Maximum load applied to specimen.
COMP_STRENGTH_FRAC

VARCHAR2(2)

P32
Code describing the type of fracture of the compressive strength core.[COMP_STRENGTH_FRAC_BASE]
COMP_FRAC_OTHER

VARCHAR2(40)

P32
Note used to describe fractures which have no code in the protocol. [COMP_FRAC_OTHER_BASE]
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(5)
psi
P32
Compressive strength of core.
VISUAL_EXAM_1
VISUAL_ACPCNUMBER(2)

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

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

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

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

P32
Code for visual examination comments.
VISUAL_EXAM_6
VISUAL_ACPCNUMBER(2)

P32
Code for visual examination comments.
VISUAL_EXAM_OTHER

VARCHAR2(40)

P32
Visual examination comments if other than those specified.
COMMENTS_1
COMMENTNUMBER(2)

P32
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P32
Code for testing comments.
LAYER_NO

NUMBER(2)

P32
Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
COMMENTS_3
COMMENTNUMBER(2)

P32
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P32
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P32
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P32
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P32
A note used to record additional observations regarding the test, or test results.
SAMPLE_NO

VARCHAR2(7)

P32
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

P32
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
FIELD_SET

NUMBER(2)

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

P32
Code number indicating sample location.
LOC_NO

VARCHAR2(6)

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

P32
Code indicating the lab that performed the testing.
SAMPLE_AREA_NO

VARCHAR2(5)

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