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_A

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.
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.
PRE_GREATER_5_PERCENT_STRAIN
Y_NVARCHAR2(1)

P46
Code indicating if preconditioning consisted of greater than 5% permanent strain.
TEST_GREATER_5_PERCENT_STRAIN
Y_NVARCHAR2(1)

P46
Code indicating if during testing there was greater than 5% permanent strain.
TEST_LOAD_SEQ_COMP

NUMBER(2)

P46
Number of load sequences completed during testing.
TOP_DIAMETER

NUMBER(4,1)
mm
P46
Top diameter of the specimen.
MIDDLE_DIAMETER

NUMBER(4,1)
mm
P46
Diameter at the middle of the specimen.
BOTTOM_DIAMETER

NUMBER(4,1)
mm
P46
The diameter of the bottom of the specimen.
AVERAGE_DIAMETER

NUMBER(4,1)
mm
P46
Average diameter of the specimen.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(3,2)
mm
P46
Membrane thickness of the specimen.
MEMBRANE_THICK_2

NUMBER(3,2)
mm
P46
Membrane thickness of the specimen.
NET_DIAMETER

NUMBER(4,1)
mm
P46
Net diameter of the specimen.
TOTAL_HT

NUMBER(4,1)
mm
P46
Height of the specimen, cap and base.
CAP_BASE_HT

NUMBER(4,1)
mm
P46
Height of the cap and base.
INITIAL_LENGTH

NUMBER(4,1)
mm
P46
Initial length of the specimen.
INITIAL_AREA

NUMBER(5)
sq mm
P46
Initial area of the specimen.
INITIAL_VOLUME

NUMBER(7)
cu mm
P46
Initial volume of the specimen.
INITIAL_WT_CONT_SOIL

NUMBER(7,2)
g
P46
Initial weight of the container and wet soil.
FINAL_WT_CONT_SOIL

NUMBER(7,2)
g
P46
Final weight of container and wet soil.
LAYER_NO

NUMBER(2)

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

NUMBER(7,2)
g
P46
Weight of the wet soil used.
IN_SITU_MOIST

NUMBER(3,1)
%
P46
In situ moisture content of the soil.
IN_SITU_DENSITY

NUMBER(5,1)
kg/cu m
P46
In situ wet density of the soil.
OPT_MOIST_CONT

NUMBER(3,1)
%
P46
Optimum moisture content of the soil.
MAX_DRY_DENSITY

NUMBER(5,1)
kg/cu m
P46
Maximum dry density of the soil.
MAX_DRY_DENSITY_95

NUMBER(5,1)
kg/cu m
P46
Value of 95% maximum dry density of the soil.
COMP_MOIST_CONT

NUMBER(3,1)
%
P46
Compaction moisture content of the specimen.
AFTER_MOIST_CONT

NUMBER(3,1)
%
P46
Moisture content after resilient modulus testing.
COMP_DRY_DENSITY

NUMBER(5,1)
kg/cu m
P46
Compaction dry density of the specimen.
STRESS_STRAIN_ATTACH

VARCHAR2(1)

P46
A yes (Y) or no (N) indicating if the stress-strain plot was attached.
TEST_NO
TEST_NONUMBER(2)

P46
Code number indicating sample location.
MAX_STRENGTH

NUMBER(3)
kPa
P46
Triaxial shear maximum strength.
SPEC_FAIL
Y_NVARCHAR2(1)

P46
Code indicating if the specimen failed during triaxial shear.
COMMENT_1
COMMENTNUMBER(2)

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

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

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

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

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

P46
Code for miscellaneous comments or notes.
COMMENT_OTHER

VARCHAR2(40)

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

DATE

P46
Date the test was performed.
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.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
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.
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.