LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SS11

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)

P57
Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
LAB_CODE
LAB_CODEVARCHAR2(4)

P57
Code indicating the lab that performed the testing.
TEST_DATE

DATE

P57
Date the test was performed.
INITIAL_SPECIMEN_HEIGHT

NUMBER(4,2)
in
P57
Initial specimen height.
INITIAL_SPECIMEN_DIAMETER

NUMBER(4,2)
in
P57
Initial specimen diameter.
INITIAL_SPECIMEN_MASS

NUMBER(5,1)
g
P57
Initial mass of soil.
INITIAL_WATER_CONTENT

NUMBER(2)
%
P57
Initial water content of the specimen.
FINAL_WATER_CONTENT

NUMBER(2)
%
P57
Final water content of the specimen.
INITIAL_DRY_DENSITY

NUMBER(3)
pcf
P57
Initial dry density of the specimen.
FINAL_DRY_DENSITY

NUMBER(3)
pcf
P57
Final dry density of the specimen.
TOTAL_BACK_PRESSURE

NUMBER(3)
psi
P57
Magnitude of the total back pressure.
STATE_CODE
STATE_PROVINCENUMBER(2)

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

NUMBER(2)
psi
P57
Maximum effective consolidation stress. It exists at the effluent end of the test specimen.
MIN_EFFECTIVE_STRESS

NUMBER(2)
psi
P57
Minimum effective consolidation stress. It exists at the influent end of the test specimen.
MAX_HYDRAULIC_GRADIENT

NUMBER(2)

P57
Maximum hydraulic gradient (H/L) used in the test.
MIN_HYDRAULIC_GRADIENT

NUMBER(2)

P57
Minimum hydraulic gradient (H/L) used in the test.
FINAL_DEGREE_OF_SATURATION

NUMBER(3)
%
P57
Final degree of saturation.
AVG_HYDRAULIC_CONDUCTIVITY

NUMBER(11,10)
cm/sec
P57
Average measured hydraulic conductivity (k) of the specimen.
FINAL_SPECIMEN_HEIGHT

NUMBER(4,2)
in
P57
Final specimen height.
FINAL_SPECIMEN_DIAMETER

NUMBER(4,2)
in
P57
Final specimen diameter.
FINAL_SPECIMEN_MASS

NUMBER(5,1)
g
P57
Final mass of soil.
COMMENTS_1
COMMENTNUMBER(2)

P57
Code for testing comments.
LAYER_NO

NUMBER(2)

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

P57
Code for testing comments.
COMMENTS_3
COMMENTNUMBER(2)

P57
Code for testing comments.
COMMENTS_4
COMMENTNUMBER(2)

P57
Code for testing comments.
COMMENTS_5
COMMENTNUMBER(2)

P57
Code for testing comments.
COMMENTS_6
COMMENTNUMBER(2)

P57
Code for testing comments.
COMMENTS_OTHER

VARCHAR2(40)

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

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

P57
Code number indicating sample location.
LOC_NO

VARCHAR2(6)

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

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

VARCHAR2(5)

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