LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: DLR_NC_LVDT_CONFIG_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.
POST_GAIN

NUMBER(3)


Post Analog to Digital (AD) conversion amplification.
MEGADAC_FILTER
MEGADAC_FILTERNUMBER(1)


Code for type of filter applied by the MEGADAC system.
FULL_SCALE_MAX_L

NUMBER(8,1)
microns

Maximum value that can be recorded by LVDT.
FULL_SCALE_MIN_L

NUMBER(8,1)
microns

Minimum value that can be recorded by the LVDT.
GAUGE_MANUFACTURER

VARCHAR2(20)


Name of the gauge manufacturer.
GAUGE_MODEL_NUMBER

VARCHAR2(20)


Model number of the gauge.
SENSOR_NAME2

VARCHAR2(20)


Additional sensor identifying information, if any.
GAUGE_RESOLUTION

NUMBER(3,2)
microns

Minimum recordable value for the sensor based upon excitation and amplification.
EXCITATION_SOURCE

VARCHAR2(7)


Source of the excitation.
EXCITATION_VALUE

NUMBER(2)
V

Magnitude of the excitation.
SHRP_ID

VARCHAR2(4)


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

NUMBER(1)
microns

Calibration factor used in the transformation.
SENSITIVITY_MV

NUMBER(4)
mV

Calibration sensitivity of the sensor for transforming the raw voltages to engineering units x 10^6
SENSITIVITY_VOLTS

NUMBER(3)
V

Supplied voltage to the sensitivity equation.
SENSOR_HOLE_NUMBER

NUMBER(2)


Hole number of the test site where the sensor was placed.
SENSOR_LAYER_NUMBER

NUMBER(2)


Layer number of the pavement structure in which the measurements were determined.
X

NUMBER(4)
mm

Distance along the direction of traffic as referenced from the entry slab corner.
Y

NUMBER(4)
mm

Distance from the shoulder joint as referenced from the entry slab corner.
Z

NUMBER(5,1)
mm

Distance from the pavement surface to measurement point of sensor.
COMMENTS

VARCHAR2(80)


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

NUMBER(4)
mm

Distance that indicates whether the measurement relates to the deflection of the surface layer.
TEST_NAME

VARCHAR2(7)


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

VARCHAR2(1)


A code indicating the general quality of the data.
TAG_ID

VARCHAR2(8)


Descriptive tag given to the channel within the data collection software.
SENSOR_NAME1

VARCHAR2(10)


Serial number or a unique identifier for the sensor.
CHANNEL

NUMBER(3)


The channel number on which the sensor is wired.
BALANCE
Y_NVARCHAR2(1)


Code indicating whether or not the individual channel was balanced prior to testing - Used with the auto balance function to electronically balance the sensors prior to testing.
INPUT_CARD

VARCHAR2(8)


Type of data acquisition card the MEGADAC uses for connecting the sensor.
CARD_GAIN

NUMBER(3)


Pre Analog to Digital (AD) conversion amplification.