LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: DLR_NC_MASTER_PCC

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

VARCHAR2(10)


Type of Analog to Digital converter used.
NUMBER_OF_CHANNELS

NUMBER(3)


Number of channels scanned during the testing.
SAMPLING_RATE

NUMBER(5)
Hz

Sampling rate per channel for the Data Acquisition System.
PRETRIGGER

NUMBER(4,2)
sec

Time preceding the start event when recording starts.
POSTTRIGGER

NUMBER(4,2)
sec

Time in seconds the recording continues after the end event has been initiated.
SLAB1_LENGTH

NUMBER(4)
mm

Original constructed length of the entry or first slab determined as an average of the inside and outside slab edge lengths.
SLAB1_WIDTH

NUMBER(4)
mm

Original constructed width of the entry or first slab determined as an average of the inside and outside slab edge lengths.
SLAB2_LENGTH

NUMBER(4)
mm

Original constructed length of the leave or second slab determined as an average of the inside and outside slab edge lengths.
SLAB2_WIDTH

NUMBER(4)
mm

Original constructed width of the leave or second slab determined as an average of the inside and outside slab edge lengths.
COMMENT_CODE

NUMBER(2)


Comment code. (Field not currently used.)
SHRP_ID

VARCHAR2(4)


Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
COMMENTS

VARCHAR2(80)


An unformatted field for the comments pertaining to the information stored in the table.
REVISION_DATE

DATE


Date of latest revision to the information stored in this table.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
TEST_NAME

VARCHAR2(7)


Character string that uniquely identifies each series of test traces.
DATE_CREATED

DATE


Date of the start of testing.
AUTOBALANCE

VARCHAR2(1)


Code indicating whether or not the electronic auto balance function is in use.
START_EVENT
DLR_TRIGGERNUMBER(1)


Code for event that starts the testing.
END_EVENT
DLR_TRIGGERNUMBER(1)


Code for event that ends the testing.
DATA_COLLECTION_SOFTWARE

VARCHAR2(10)


Name of the software used to collect the data.
SOFTWARE_VERSION

VARCHAR2(10)


Software version number of the recording software.