LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_AIR_VOIDS_CALC

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

NUMBER(4,3)


Bulk specific gravity of the asphalt bound layer.
MSG

NUMBER(4,3)


Maximum specific gravity assigned to the asphalt concrete sample.
AIR_VOIDS

NUMBER(3,2)
%

Air Voids calculated from the bulk and maximum specific gravities.
MSG_SOURCE

VARCHAR2(25)


Source of the maximum specific gravity value.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
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).
FIELD_SET

NUMBER(2)


Sequential number indicating the field sampling event. Assigned 1 for first sample event and incremented by 1 for subsequent events.
TEST_NO

NUMBER(2)


Code number indicating sample location.
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

VARCHAR2(6)


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

VARCHAR2(6)


The end of the section where the BSG sample was taken.
LANE_LOCATION

VARCHAR2(20)


Indication of whether the BSG sample came from the wheelpath (as defined by the Distress Identification Manual) or not.