LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS8_PCC_MIXTURE_DATA

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

NUMBER(3,1)
%

Alkali content of cement.
ADMIXTURE_TYPE_1
PCCANUMBER(2)


Code indicating type of admixture used in the concrete.
ADMIXTURE_TYPE_1_OTHER

VARCHAR2(40)


Type of admixture used in the concrete if other than those listed.
ADMIXTURE_AMT_1

NUMBER(3,1)
%

Admixture amount used in the concrete - percent by weight of cement.
ADMIXTURE_TYPE_2
PCCANUMBER(2)


Code indicating type of admixture used in the concrete.
ADMIXTURE_TYPE_2_OTHER

VARCHAR2(40)


Type of admixture used in the concrete if other than those listed.
ADMIXTURE_AMT_2

NUMBER(3,1)
%

Admixture amount used in the concrete - percent by weight of cement.
ADMIXTURE_TYPE_3
PCCANUMBER(2)


Code indicating type of admixture used in the concrete.
ADMIXTURE_TYPE_3_OTHER

VARCHAR2(40)


Type of admixture used in the concrete if other than those listed.
ADMIXTURE_AMT_3

NUMBER(3,1)
%

Admixture amount used in the concrete - percent by weight of cement.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
AGGR_DUR_TYPE_C1
AGGR_DURNUMBER(2)


Code for coarse aggregate durability test type.
AGGR_DUR_RESULT_C1

NUMBER(4,1)


Code indicating result of durability test performed on coarse aggregate.
AGGR_DUR_TYPE_C2
AGGR_DURNUMBER(2)


Code for coarse aggregate durability test type.
AGGR_DUR_RESULT_C2

NUMBER(4,1)


Code indicating result of durability test performed on coarse aggregate.
AGGR_DUR_TYPE_C3
AGGR_DURNUMBER(2)


Code for coarse aggregate durability test type.
AGGR_DUR_RESULT_C3

NUMBER(4,1)


Code indicating result of durability test performed on coarse aggregate.
AGGR_DUR_TYPE_M1
AGGR_DURNUMBER(2)


Code for combined aggregate durability test type.
AGGR_DUR_RESULT_M1

NUMBER(4,1)


Code indicating result of durability test performed on coarse and fine aggregate.
AGGR_COMP_TYPE_C1
COARSE_AGG_COMPNUMBER(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C1_OTHER

VARCHAR2(40)


Composition of coarse aggregate if other than those specified.
LAYER_NO

NUMBER(2)


Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
AGGR_COMP_PERCENT_C1

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
AGGR_COMP_TYPE_C2
COARSE_AGG_COMPNUMBER(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C2_OTHER

VARCHAR2(40)


Composition of coarse aggregate if other than those specified.
AGGR_COMP_PERCENT_C2

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
AGGR_COMP_TYPE_C3
COARSE_AGG_COMPNUMBER(1)


Code indicating composition of coarse aggregate.
AGGR_COMP_TYPE_C3_OTHER

VARCHAR2(40)


Composition of coarse aggregate if other than those specified.
AGGR_COMP_PERCENT_C3

NUMBER(3)
%

Coarse aggregate amount - percent by weight of coarse aggregate total.
GEOL_CLASS_COARSE_AGGR
GEOL_CLASSNUMBER(2)


Code for geologic classification of coarse aggregate.
AGGR_COMP_TYPE_F1
FINE_AGG_COMPNUMBER(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F1_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
MIX_DESIGN_COARSE

NUMBER(4)
lb

Oven dry weight of coarse aggregate provided by the mix design per unit volume of concrete.
AGGR_COMP_PERCENT_F1

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
AGGR_COMP_TYPE_F2
FINE_AGG_COMPNUMBER(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F2_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
AGGR_COMP_PERCENT_F2

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
AGGR_COMP_TYPE_F3
FINE_AGG_COMPNUMBER(1)


Code indicating composition of fine aggregate.
AGGR_COMP_TYPE_F3_OTHER

VARCHAR2(40)


Composition of fine aggregate if other than those specified.
AGGR_COMP_PERCENT_F3

NUMBER(3)
%

Fine aggregate amount - percent by weight of fine aggregate total.
INSOLUBLE_RESIDUE

NUMBER(3)
%

The percentage of insoluble residue (non-carbonate material).
TWO_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 2" sieve.
ONE_AND_HALF_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 1 1/2" sieve.
MIX_DESIGN_FINE

NUMBER(4)
lb

Oven dry weight of fine aggregate provided by the mix design per unit volume of concrete.
ONE_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 1" sieve.
SEVEN_EIGHTHS_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 7/8" sieve.
THREE_FOURTHS_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 3/4" sieve.
FIVE_EIGHTHS_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 5/8" sieve.
ONE_HALF_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 1/2" sieve.
THREE_EIGHTHS_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the 3/8" sieve.
NO_4_PASSING

NUMBER(4,1)
%

Percent coarse aggregate passing the #4 sieve.
NO_8_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #8 sieve.
NO_10_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #10 sieve.
NO_16_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #16 sieve.
MIX_DESIGN_CEMENT

NUMBER(4)
lb

Oven dry weight of cement provided by the mix design per unit volume of concrete.
NO_30_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #30 sieve.
NO_40_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #40 sieve.
NO_50_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #50 sieve.
NO_80_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #80 sieve.
NO_100_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #100 sieve.
NO_200_PASSING

NUMBER(4,1)
%

Percent fine aggregate passing the #200 sieve.
COARSE_AGGR_BULK_SPEC

NUMBER(4,3)


Bulk specific gravity of coarse aggregate.
FINE_AGGR_BULK_SPEC

NUMBER(4,3)


Bulk specific gravity of the fine aggregate.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
MIX_DESIGN_WATER

NUMBER(4)
lb

Weight of water provided by the mix design per unit volume of concrete.
CEMENT_TYPE
PC_TYPENUMBER(2)


Code indicating the type of Portland cement used.
CEMENT_TYPE_OTHER

VARCHAR2(40)


Type of Portland cement used if other than those listed.