LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_AC07_V2_SPECIMEN_INFO

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)

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

VARCHAR2(7)

P07
Unique code number assigned to sample used for specimen 1.
SAMPLE_NO_2

VARCHAR2(7)

P07
Unique code number assigned to sample used for specimen 2.
SAMPLE_NO_3

VARCHAR2(7)

P07
Unique code number assigned to sample used for specimen 3.
THICKNESS_SPECIMEN_1

NUMBER(3,1)
mm
P07
Average thickness of specimen 1.
DIAMETER_SPECIMEN_1

NUMBER(4,1)
mm
P07
Average diameter of specimen 1.
BSG_AC_SPECIMEN_1

NUMBER(4,3)

P07
Bulk specific gravity of specimen 1.
THICKNESS_SPECIMEN_2

NUMBER(3,1)
mm
P07
Average thickness of specimen 2.
DIAMETER_SPECIMEN_2

NUMBER(4,1)
mm
P07
Average diameter of specimen 2.
BSG_AC_SPECIMEN_2

NUMBER(4,3)

P07
Bulk specific gravity of specimen 2.
THICKNESS_SPECIMEN_3

NUMBER(3,1)
mm
P07
Average thickness of specimen 3.
SHRP_ID

VARCHAR2(4)

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

NUMBER(4,1)
mm
P07
Average diameter of specimen 3.
BSG_AC_SPECIMEN_3

NUMBER(4,3)

P07
Bulk specific gravity of specimen 3.
CREEP_DATA_ANAL_FILE

VARCHAR2(12)

P07
Name of file that contains all creep compliance test analysis results. Can be cross-referenced with AIMS off-line data storage system.
MR_DATA_ANAL_FILE

VARCHAR2(12)

P07
Name of file that contains all resilient modulus test analysis results.
IDT_DATA_ANAL_FILE_1

VARCHAR2(12)

P07
Name of file that contains indirect tensile strength test analysis results.
IDT_DATA_ANAL_FILE_2

VARCHAR2(12)

P07
Name of file that contains failure strain and fracture energy analysis results obtained from the indirect tensile strength test.
IDT_DATA_ANAL_FILE_3

VARCHAR2(12)

P07
Name of file that contains stress and strain analysis results obtained from the indirect tensile strength test.
COMMENT_1
COMMENTNUMBER(2)

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

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

P07
Code for miscellaneous comments or notes.
LAYER_NO

NUMBER(2)

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

VARCHAR2(40)

P07
A note used to record additional observations regarding the test, or test results.
TEST_NO
TEST_NONUMBER(2)

P07
Code number indicating sample location.
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.
FIELD_SET

NUMBER(2)

P07
Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
LAB_CODE
LAB_CODEVARCHAR2(4)

P07
Code indicating the lab that performed the testing.
SAMPLE_AREA_NO

VARCHAR2(5)

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