LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SAMPLE_LOG

Field NameCodesData TypeUnitsTest ProtocolDescription
SHRP_ID

VARCHAR2(4)


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

NUMBER(5,2)
in

Depth to top of a stratum, measured from the surface.
DEPTH_BOT_STRATA

NUMBER(5,2)
in

Depth to the bottom of a stratum, measured from the surface.
NO_BLOWS_1

NUMBER(2)


Number of blows per 6 inches of penetration of the splitspoon sampler.
NO_BLOWS_2

NUMBER(2)


Number of blows per 6 inches of penetration of the splitspoon sampler.
NO_BLOWS_3

NUMBER(2)


Number of blows per 6 inches of penetration of the splitspoon sampler.
REFUSAL
Y_NVARCHAR2(1)


Code indicating whether the splitspoon sample was refused.
DLR

NUMBER(3,1)
in

Depth to refusal of a splitspoon sample.
IOP

NUMBER(3,1)
in

Inches of penetration of the splitspoon sampler.
DIAMETER

NUMBER(2)
in

Diameter of the sample.
MOIST_NO

VARCHAR2(7)


Sample number assigned to a sample to be used for moisture content testing.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

VARCHAR2(7)


The identification number assigned to the bulk sample.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
FIELD_SET

NUMBER(2)


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

VARCHAR2(6)


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.
STRATA_LEVEL

NUMBER(2)


The sequential number of a stratum layer.
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_NO

VARCHAR2(7)


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.
MATERIAL_DESC

VARCHAR2(40)


Description of the material comprising the sample.
MATERIAL_CODE
MATERIALNUMBER(3)


Code used to identify the material comprising the sample.