LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: RHB_HMRAP_GEN_INFO

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

NUMBER(4,1)
%

Percent reclaimed aggregate passing the 2" sieve.
ONE_AND_HALF_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the 1 1/2" sieve.
ONE_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the 1" sieve.
SEVEN_EIGHTHS_PASSING

NUMBER(4,1)
%

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

NUMBER(4,1)
%

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

NUMBER(4,1)
%

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

NUMBER(4,1)
%

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

NUMBER(4,1)
%

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

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #4 sieve.
NO_8_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #8 sieve.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #10 sieve.
NO_16_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #16 sieve.
NO_30_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #30 sieve.
NO_40_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #40 sieve.
NO_50_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #50 sieve.
NO_80_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #80 sieve.
NO_100_PASSING

NUMBER(4,1)
%

Percent reclaimed aggregate passing the #100 sieve.
NO_200_PASSING

NUMBER(4,1)
%

Percent reclaimed 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.
DATE_COMPLETE

DATE


Date activity was completed.
MINERAL_FILLER_BULK_SPEC

NUMBER(4,3)


Mean bulk specific gravity for mineral filler.
AGGR_COMB_BULK_SPEC

NUMBER(4,3)


Mean bulk specific gravity of aggregate combination.
EFFECTIVE_SPEC_GRAVITY

NUMBER(4,3)


Effective specific gravity of aggregate combination.
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.
LAYER_NO

NUMBER(2)


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


Code for method used to breakup and/or remove asphalt pavement.
BREAKUP_METHOD_OTHER

VARCHAR2(40)


Method used to breakup and/or remove asphalt pavement if other than those specified.
PAVEMENT_PROCESSING
PAVEMENT_PROCESSINGNUMBER(1)


Code for pavement processing method.
PAVEMENT_PROC_OTHER

VARCHAR2(40)


Pavement processing method used if other than those specified.