LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MNT_ASPHALT_PATCH

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

VARCHAR2(40)


Secondary reason for patching or slab replacement if other than those specified.
SURFACE_PATCHES_NO

NUMBER(2)


Number of surface pavement patches.
SURFACE_PATCHES_SF

NUMBER(4)
sq ft

Area of surface patching.
SURFACE_OVERLAID_NO

NUMBER(2)


Number of surface and overlaid pavement patches.
SURFACE_OVERLAID_SF

NUMBER(4)
sq ft

Square feet of surface and overlaid pavement patches.
AC_PC_NO

NUMBER(2)


Number of AC & PC layers and partial base replacement.
AC_PC_SF

NUMBER(4)
sq ft

Square feet of AC & PC layers and partial base replacement.
FULL_DEPTH_NO

NUMBER(2)


Number of full depth patches placed in test section.
FULL_DEPTH_SF

NUMBER(4)
sq ft

Square feet of full depth patches.
PATCH_MATL
PATCH_MATL_ACNUMBER(1)


Code for patch type used if pavement is AC over PCC.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
SURFACE_MATL_1
PATCH_MATERIALNUMBER(1)


Code for surface materials used to patch pavement.
SURFACE_MATL_2
PATCH_MATERIALNUMBER(1)


Code for surface materials used to patch pavement.
SURFACE_MATL_OTHER

VARCHAR2(40)


Surface materials used to patch pavement if other than those specified.
SURFACE_MATL_SOURCE
MNT_SOURCENUMBER(1)


Code indicating the data source of surface materials used to patch pavement.
COMPACTION
MNT_6_7NUMBER(1)


Code for method of compaction.
COMPACTION_OTHER

VARCHAR2(40)


Method of compaction if other than those specified.
COMPACTION_SOURCE
MNT_SOURCENUMBER(1)


Code indicating data source for method of compaction.
LOC_SIZE_METHOD
LOC_SIZE_METHODNUMBER(1)


Code indicating primary method used to determine location of patches.
LOC_SIZE_METHOD_OTHER

VARCHAR2(40)


Primary method used to determine location of patches if other than those specified.
LOC_SIZE_METHOD_SOURCE
MNT_SOURCENUMBER(1)


Data source for method used to identify the means of locating areas requiring patches.
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.
CUT_METHOD
CUT_METHOD_PARTNUMBER(1)


Code identifying the instrument used to cut boundaries of area to be patched.
CUT_METHOD_OTHER

VARCHAR2(40)


Method of cutting boundaries if other than those listed.
CUT_METHOD_SOURCE
MNT_SOURCENUMBER(1)


Data source for method used to cut boundaries.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
DATE_COMPLETE

DATE


Date activity was completed.
SHRP_CASE_NO

NUMBER(4)


Key generated by the computer to insure uniqueness of records.
DATE_BEGAN

DATE


Date operations began.
REASON
DISTRESS_TYPENUMBER(2)


Code indicating primary reason for patch.
REASON_OTHER

VARCHAR2(40)


Primary reason for patching if other than those specified.
SECONDARY_REASON
DISTRESS_TYPENUMBER(2)


Code indicating secondary reason for patching or slab replacement.