LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_UG07_SS07_WKSHT_SUM

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

P46
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
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)

P46
Code indicating the lab that performed the testing.
SAMPLE_AREA_NO

VARCHAR2(5)

P46
Number used to reference all samples taken from one area of the project - used only for SPS-5, 6, and 7 project.
LAYER_TYPE
LAYER_TYPE_RES_MODNUMBER(1)

P46
Code designating the type of layer.
MR_MATL_TYPE
MR_MATL_TYPENUMBER(1)

P46
Code designating whether the material was coarse or fine grained.
APPLIED_MAX_AXIAL_LOAD_AVG

NUMBER(5,1)
N
P46
Applied maximum axial load average.
APPLIED_MAX_AXIAL_LOAD_STD

NUMBER(5,1)
N
P46
Applied maximum axial load standard deviation.
APPLIED_CYCLIC_LOAD_AVG

NUMBER(5,1)
N
P46
Actual applied cyclic load average.
APPLIED_CYCLIC_LOAD_STD

NUMBER(5,1)
N
P46
Applied cyclic load standard deviation.
APPLIED_CONTACT_LOAD_AVG

NUMBER(4,1)
N
P46
Applied contact load average.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(4,1)
N
P46
Applied contact load standard deviation.
APPLIED_MAX_AXIAL_STRESS_AVG

NUMBER(4,1)
kPa
P46
Applied maximum axial stress average.
APPLIED_MAX_AXIAL_STRESS_STD

NUMBER(4,1)
kPa
P46
Applied maximum axial stress standard deviation.
APPLIED_CYCLIC_STRESS_AVG

NUMBER(4,1)
kPa
P46
Applied cyclic stress average.
APPLIED_CYCLIC_STRESS_STD

NUMBER(4,1)
kPa
P46
Applied cyclic stress standard deviation.
APPLIED_CONTACT_STRESS_AVG

NUMBER(3,1)
kPa
P46
Applied contact stress average.
APPLIED_CONTACT_STRESS_STD

NUMBER(3,1)
kPa
P46
Applied contact stress standard deviation.
DEF_LVDT_1_AVG

NUMBER(6,5)
mm
P46
Average across cycles of the recoverable axial deformation of the sample for each LVDT.
DEF_LVDT_1_STD

NUMBER(6,5)
kPa
P46
Standard deviation across cycles of the recoverable axial deformation.
DEF_LVDT_2_AVG

NUMBER(6,5)
mm
P46
Average across cycles of the recoverable axial deformation of the sample for each LVDT.
LAYER_NO

NUMBER(2)

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

NUMBER(6,5)
kPa
P46
Standard deviation across cycles of the recoverable axial deformation.
DEF_LVDT_1_2_AVG

NUMBER(6,5)
mm
P46
Average across cycles of the average recoverable axial deformations.
DEF_LVDT_1_2_STD

NUMBER(6,5)
kPa
P46
Standard deviation across cycles of the average recoverable axial deformation.
RES_STRAIN_AVG

NUMBER(6,6)

P46
Average resilient strain across cycles.
RES_STRAIN_STD

NUMBER(6,6)

P46
Standard deviation of resilient strain across cycles.
RES_MOD_AVG

NUMBER(3)
MPa
P46
Average resilient modulus across cycles.
RES_MOD_STD

NUMBER(3)
MPa
P46
Standard deviation of the resilient modulus across cycles.
TEST_DATE

DATE

P46
Date the test was performed.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
TEST_NO
TEST_NONUMBER(2)

P46
Code number indicating sample location.
FIELD_SET

NUMBER(2)

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

VARCHAR2(6)

P46
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.
SAMPLE_NO

VARCHAR2(7)

P46
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.
CON_PRESSURE

NUMBER(4,1)
kPa
P46
Chamber confining pressure.
NOM_MAX_AXIAL_STRESS

NUMBER(4,1)
kPa
P46
Nominal maximum axial stress.