LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_SAMPLE_LAB_AC_MIX

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

NUMBER(4,1)
deg C

Temperature at which material was mixed.
AGG_SAMPLE_SIZE

NUMBER(6,1)
g

Quantity of aggregate used in preparation of lab-mixed AC sample.
BINDER_SAMPLE_SIZE

NUMBER(6,1)
g

Quantity of asphalt binder used in preparation of lab-mixed AC sample.
SAMPLE_SIZE

NUMBER(6,1)
g

Quantity of Lab mixed AC prepared.
MIX_DATE

DATE


Date material was mixed.
AGG_REGRADE
AGG_REGRADEVARCHAR2(1)


Code indicating whether aggregate was re-graded prior to mix.
COMMENTS

VARCHAR2(80)


Any pertinent additional comments concerning the sample.
SHRP_ID

VARCHAR2(4)


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

VARCHAR2(7)


SAMPLE_NO of aggregate used in mixture.
SAMPLE_NO_BINDER

VARCHAR2(7)


SAMPLE_NO of binder used in mixture.
LAB_CODE
LAB_CODEVARCHAR2(4)


Code indicating the lab that performed the testing.