LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: MNT_PCC_JOINT_RESEAL

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

NUMBER(2,1)
in

New sealant reservoir width.
SEAL_RES_DEPTH

NUMBER(3,1)
in

New sealant reservoir depth.
SEAL_RES_SOURCE
MNT_SOURCENUMBER(1)


Code indicating the data source for new sealant reservoir depth.
BOND_BREAK
BOND_BREAKNUMBER(1)


Code identifying the material used to prevent an adhesive bond between the sealant and the bottom of the reservoir.
BOND_BREAK_OTHER

VARCHAR2(40)


Material used to prevent adhesive bond if other than those specified.
REFACED
REFACEDNUMBER(1)


Code indicating method used to reface joint sidewalls.
REFACED_OTHER

VARCHAR2(40)


Method used to reface joint sidewalls if other than those specified.
SIDEWALL_CLEAN
SIDEWALL_CLEANNUMBER(1)


Code indicating the method of cleaning sidewalls prior to resealing.
SIDEWALL_CLEAN_OTHER

VARCHAR2(40)


Method of cleaning sidewalls prior to resealing if other than those specified.
SIDEWALL_CLEAN_SOURCE
MNT_SOURCENUMBER(1)


Code indicating the data source for method of cleaning sidewalls.
STATE_CODE
STATE_PROVINCENUMBER(2)


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


Code indicating method used for contraction joint sealant.
JOINT_SEAL_TYPE_OTHER

VARCHAR2(40)


Method used for contraction joint sealant if other than those specified
MANUFACTURER_NAME

VARCHAR2(40)


Manufacturer of the joint sealant.
MANUFACTURER_SEALANT_NAME

VARCHAR2(40)


Product specific name of sealant.
JOINT_SEAL_TYPE_SOURCE
MNT_SOURCENUMBER(1)


Code indicating data source for type of contraction joint sealant.
SEAL_DEPTH

NUMBER(2,1)
in

Depth from the top of the slab to the top of the joint sealant material.
SEAL_DEPTH_SOURCE
MNT_SOURCENUMBER(1)


Code indicating the data source for depth of top of sealant placement.
SEALS_DIFFERENT
YES_NONUMBER(1)


Code indicating if the sealing materials used for contraction and expansion joints are different.
EXPANSION_MATL

VARCHAR2(40)


Description of expansion material used.
TRANS_SEAL_LENGTH

NUMBER(5,1)
lf

Total linear feet of transverse joints sealed.
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.
LONG_SEAL_LENGTH

NUMBER(5,1)
ft

Total linear feet of longitudinal joints sealed.
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.
REMOVAL_METHOD
REMOVAL_METHODNUMBER(1)


Code indicating the method used for removing old sealant.
REMOVAL_METHOD_OTHER

VARCHAR2(40)


Method of removing old sealant if other than those specified.
REMOVAL_METHOD_SOURCE
MNT_SOURCENUMBER(1)


Code indicating the data source for method of removing old sealant.