LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: AC_AGGR_COMP

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

VARCHAR2(4)


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

NUMBER(2)


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


Code indicating the type of aggregate.
AGGR_COMP_TEXTURE
INV_TEXTUREVARCHAR2(1)


Code indicating aggregate texture.
AGGR_COMP_TYPE
AGGR_COMP_TYPEVARCHAR2(2)


Code indicating composition of aggregate.
AGGR_COMP_PERCENT

NUMBER(3)
%

Aggregate amount - percent by weight of aggregate total.
AGGR_COMP_TYPE_OTHER

VARCHAR2(40)


Composition of aggregate if other than those specified.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.