LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_AE04

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

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

VARCHAR2(7)

P24
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

P24
Date the test was performed.
TEST_TEMPERATURE_F

NUMBER(4,2)
deg F
P24
Temperature at which test was performed.
LOAD_100_VISCOSITY

NUMBER(7,3)
Megapoise
P24
Viscosity of the asphalt with a 100 gram load.
LOAD_100_SHEAR_RATE

NUMBER(4,3)
1/s
P24
Shear rate with a 100 gram load.
LOAD_300_VISCOSITY

NUMBER(7,3)
Megapoise
P24
Viscosity of the asphalt with a 300 gram load.
LOAD_300_SHEAR_RATE

NUMBER(4,3)
1/s
P24
Shear rate with a 300 gram load.
LOAD_1000_VISCOSITY

NUMBER(7,3)
Megapoise
P24
Viscosity of the asphalt with a 1000 gram load.
LOAD_1000_SHEAR_RATE

NUMBER(4,3)
1/s
P24
Shear rate with a 1000 gram load.
LOAD_3000_VISCOSITY

NUMBER(7,3)
Megapoise
P24
Viscosity of the asphalt with a 3000 gram load.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(4,3)
1/s
P24
Shear rate with a 3000 gram load.
LOAD_10000_VISCOSITY

NUMBER(7,3)
Megapoise
P24
Viscosity of the asphalt with a 10000 gram load.
LOAD_10000_SHEAR_RATE

NUMBER(4,3)
1/s
P24
Shear rate with a 10000 gram load.
FRACTURE_LOAD

NUMBER(5)
g
P24
Load at fracture.
FRACTURE_SHEAR_STRESS

NUMBER(7,5)
dynes/sq cm
P24
Sheer stress at fracture.
COMMENTS_1
COMMENTNUMBER(2)

P24
Code for testing comments.
COMMENTS_2
COMMENTNUMBER(2)

P24
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P24
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P24
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P24
Code for testing comments.
LAYER_NO

NUMBER(2)

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

P24
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

P24
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.
FIELD_SET

NUMBER(2)

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

VARCHAR2(6)

P24
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.
TEST_NO
TEST_NONUMBER(2)

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

VARCHAR2(5)

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

P24
Code indicating the lab that performed the testing.