LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_FRESH_PCC

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

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
CYLINDER2

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
CYLINDER3

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
CYLINDER4

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
CYLINDER5

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
CYLINDER6

VARCHAR2(6)


Specimen number uniquely identifying each concrete beam or cylinder specimen.
BEAM1

VARCHAR2(6)


Specimen number of beam specimen. The first digit is F. The second digit represents 14(X), 28(Y), or 365(Z) day curing period. The last two digits are sequentially assigned.
BEAM2

VARCHAR2(6)


Specimen number of beam specimen. The first digit is F. The second digit represents 14(X), 28(Y), or 365(Z) day curing period. The last two digits are sequentially assigned.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

VARCHAR2(6)


Specimen number of beam specimen. The first digit is F. The second digit represents 14(X), 28(Y), or 365(Z) day curing period. The last two digits are sequentially assigned.
SLUMP_MEAN

NUMBER(2,1)
in

Average measured slump value for PCC material.
AIR_CONTENT_MEAN

NUMBER(3,1)
%

Mean measured air content in Portland Cement Concrete mix - percent by volume.
LAB_CODE
LAB_CODEVARCHAR2(4)


Code indicating the lab that performed the testing.
RECORD_STATUS

VARCHAR2(1)


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

NUMBER(3)
deg F

PCC mix temperature at the time the sample was obtained.
AMBIENT_TEMP

NUMBER(3)
deg F

Ambient temperature when sampled.
TIME_SAMPLED

NUMBER(4)


Time at which the specimen was formed.