LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SAMPLE_BULK_AC_AGG

Field NameCodesData TypeUnitsTest ProtocolDescription
STATE_CODE
STATE_PROVINCENUMBER(2)


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

VARCHAR2(40)


Type of mix plant if other than specified.
PLANT_DESC

VARCHAR2(40)


Description of mix plant.
MANUFACTURER

VARCHAR2(30)


Manufacturer of mix plant.
MODEL_NO

VARCHAR2(30)


Model number of mix plant.
BATCH_SIZE

VARCHAR2(30)


Typical batch size of AC mix.
SAMPLE_SIZE

NUMBER(3)
lb

Approximate sample quantity.
SAMPLE_LOC
SAMPLE_LOC_UNCOMPVARCHAR2(1)


Code identifying the location from which the sample was taken.
SAMPLE_LOC_OTHER

VARCHAR2(40)


Location from which the sample was taken if other than those specified.
REPR_GRADATION
REPR_GRADATIONVARCHAR2(1)


Code indicating whether sample gradation is representative of aggregate used in plant-mixed AC.
LOC_SHIPPED

VARCHAR2(40)


Destination to which the sample was shipped.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(80)


Any pertinent additional comments concerning the sample.
DATE_SAMPLED

DATE


Date the sample was retrieved from the field.
DATE_SHIPPED

DATE


Date the sample or material was shipped from the field to the lab or storage area.
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.
FIELD_SET

NUMBER(2)


Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
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.
RECORD_STATUS

VARCHAR2(1)


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

VARCHAR2(40)


Name of plant where sample was obtained.
PLANT_LOC

VARCHAR2(40)


Location of plant where sample was obtained.
PLANT_TYPE
PLANT_TYPEVARCHAR2(1)


Code indicating type of mix plant.