LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: SPS4_CRACK_SEAL_RAND

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

VARCHAR2(10)


Lot number of joint sealant material.
SUPPLY_UNIT
SUPPLY_UNITNUMBER(1)


Unit of supply for sealant.
MIN_QNTY_AVAIL

NUMBER(5)


Smallest quantity of material supplied.
INDIRECT_OIL_HEATING
YES_NONUMBER(1)


Code indicating if there was indirect oil heating.
MIN_OIL_TEMP

NUMBER(3)
deg F

Minimum oil temperature according to manufacturer's sealant handling recommendations.
MAX_OIL_TEMP

NUMBER(3)
deg F

Maximum oil temperature recommended by manufacturer.
MIN_SEALANT_TEMP

NUMBER(3)
deg F

Minimum sealant temperature recommended by manufacturer.
MAX_SEALANT_TEMP

NUMBER(3)
deg F

Maximum sealant temperature recommended by manufacturer.
MIN_HEAT_TIME

NUMBER(3,1)
hr

Minimum time of heating recommended by manufacturer.
MAX_HEAT_TIME

NUMBER(3,1)
hr

Maximum time of heating recommended by manufacturer.
STATE_CODE
STATE_PROVINCENUMBER(2)


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

NUMBER(1)


Code indicating if agitation is recommended(1) or not recommended(2) for the liquid or silicone sealant.
SHELF_LIFE

NUMBER(2)
months

Manufacturer suggested shelf life of silicone sealant.
SUGG_MAX_STORE_TEMP

NUMBER(2)
deg F

Manufacturer suggested maximum storage temperature of silicone sealant.
SUGG_MIN_STORE_HUMIDITY

NUMBER(2)
%

Manufacturer suggested minimum storage temperature of silicone sealant.
APPL_METHOD
APPL_METHODNUMBER(1)


Code indicating application method of silicone sealant.
APPL_PRESSURE

NUMBER(3)
psi

Manufacturer's recommended application pressure for liquid sealant.
OTHER_CONDITIONS

VARCHAR2(40)


Space provided to describe other recommended conditions for the liquid or silicone sealants.
BACKER_TYPE
BOND_BREAKNUMBER(1)


Code indicating backer material under sealant.
DIAMETER

NUMBER(2)
1/16 in

Diameter (width) of backer material under sealant.
BACKER_BRAND

VARCHAR2(20)


Brand name of the backer material.
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.
BACKER_SOURCE

VARCHAR2(40)


The supplier name along with any current mailing address.
SEAL_REMOVAL_METHOD
SEAL_REMOVAL_METHODNUMBER(1)


Code indicating method used to remove old sealant.
OTHER_REMOVAL_METHOD

VARCHAR2(40)


Method of old sealant removal from joints if other than those specified.
SPALLING_CAUSED_BY_REMOVAL
SPALLING_AMOUNTNUMBER(1)


Code indicating amount of spalling caused by joint sealant removal.
WATER_SAWING_SEAL
YES_NONUMBER(1)


Code indicating if water was used with sawing during removal of old sealant.
JOINT_SAWED
REFACEDNUMBER(1)


Code describing the refacing of joints/cracks.
SAW_BLADE_DIAM

NUMBER(4,2)
in

Diameter of saw blade used when refacing joints; 0 if not used.
WATER_SAWING_REFACING
YES_NONUMBER(1)


Code indicating if water was used with sawing in refacing of joints.
SAW_IN_ONE_PASS
YES_NONUMBER(1)


Code indicating if sawing was completed in one pass.
SPALLING_CAUSED_BY_SAW
SPALLING_AMOUNTNUMBER(1)


Code indicating amount of spalling or secondary cracking in concrete caused by sawing.
DATE_COMPLETE

DATE


Date activity was completed.
WALL_SAWED_VERTICAL
FREQUENCYNUMBER(1)


Code indicating if in joint/crack preparation walls were sawed vertically.
WATER_BLAST_RESERVOIR
YES_NONUMBER(1)


Code indicating if water blasting was used to clean reservoir.
WATER_PRESSURE

NUMBER(4)
psi

Water pressure used when water blasting reservoir, 0 if not used.
WATER_VOLUME

NUMBER(3)
gal/min

Water volume used to clean reservoir, 0 if not used.
WATER_FLUSH_RESERVOIR
YES_NONUMBER(1)


Code indicating if water flushing was used to clean reservoir.
AIR_CLEAN_DRY_RESERVOIR
YES_NONUMBER(1)


Code indicating if air was used to clean and dry reservoir.
AIR_PRESSURE

NUMBER(4)
psi

Air pressure used to clean reservoir, 0 if not used.
AIR_LANCE
YES_NONUMBER(1)


Code indicating if a hot compressed air lance was used to clean, dry and heat reservoir.
AIR_LANCE_PRESSURE

NUMBER(4)
psi

Air pressure of air lance, 0 if not used.
SANDBLAST_RESERVOIR
YES_NONUMBER(1)


Code indicating if sandblasting was used to clean the reservoir.
SEALANT_TYPE
SEALANT_TYPENUMBER(1)


Code indicating the type of sealant material used to seal the shoulder, pavement joints or random cracks.
OTHER_RESERVOIR_PREP

VARCHAR2(40)


Method used for sealant reservoir preparation if other than those specified.
RESERVOIR_CONDITION
CONDITIONNUMBER(1)


Code best indicating the reservoir condition at time of sealant application.
RESERVOIR_MOISTURE
RESERVOIR_MOISTURENUMBER(1)


Code best indicating the reservoir moisture at time of sealant application.
DAYS_INSTALL_CLEAN

NUMBER(2)
days

Elapsed days between the cleaning and installation operations.
HOURS_INSTALL_CLEAN

NUMBER(3,1)
hr

Elapsed hours between the cleaning and installation operations.
SEALANT_TOOLED
YES_NONUMBER(1)


Code indicating if silicone sealant was tooled.
SILICONE_TIME

NUMBER(4)
hhmm

Time between end of silicone joint and crack sealing and end of traffic control.
HOSE_CONNECT_WAND
YES_NONUMBER(1)


Code indicating if hose between wand and sealant chamber was heated.
BEGIN_SEALANT_TEMP

NUMBER(3)
deg F

Sealant temperature at the beginning of application.
END_SEALANT_TEMP

NUMBER(3)
deg F

Sealant temperature at the end of application.
SEALANT_OTHER

VARCHAR2(40)


Type of sealant material if other than those specified.
HOSE_BACKFLUSHED
YES_NONUMBER(1)


Code indicating if the hose was back flushed before sealing begins.
LIQUID_TIME

NUMBER(4)
hhmm

Time between the end of sealing and the end of traffic control.
SEALANT_BONDED_TO_BOTH
SEALANT_BONDED_TO_BOTHNUMBER(1)


Code indicating the extent of sealant bonding to the sides of the joint by compressing the joint sealant adjacent to the edge of the joint with a flat tool.
FILM_ON_SILICONE
YES_NONUMBER(1)


Code indicating if a film developed on the surface of the silicone sealant.
BUBBLES_PRESENT
BUBBLES_PRESENTNUMBER(1)


Code indicating the amount of bubbles in the surface of the joint sealer.
SEALANT_TACKY
YES_NONUMBER(1)


Code indicating if sealer was still tacky to the touch after 1 days cure time.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
SEALANT_BRAND

VARCHAR2(40)


Brand name of joint sealant material.
SEALANT_SOURCE

VARCHAR2(40)


Name and address of joint sealant material source.
DATE_OF_PROD

VARCHAR2(7)


Date of production of joint sealant material.