LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: DLR_NC_STRAIN_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_S

NUMBER(8,1)
microstrain

Maximum value that can be recorded by the strain gauge.
FULL_SCALE_MIN_S

NUMBER(8,1)
microstrain

Minimum value that can be recorded by the strain gauge.
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)
microstrain

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

NUMBER(1)


The number of active arms in the configuration of the strain gauge bridge circuit.
GAUGE_FACTOR

NUMBER(3,2)


Gauge factor of the strain gauge dictated by the design.
SHRP_ID

VARCHAR2(4)


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

NUMBER(3,1)
W

Power dissipated within the strain gauge.
GAUGE_RESISTANCE

NUMBER(3)
ohm

Resistance of the strain gauge.
GAUGE_VOLTAGE

NUMBER(3,1)
V

Voltage supplied to the strain gauge.
TRANSVERSE_SENSITIVITY

NUMBER(5,2)


Transverse sensitivity of the strain gauge.
EXCITATION_SOURCE

VARCHAR2(7)


Source of the excitation.
EXCITATION_TYPE

VARCHAR2(2)


Type of excitation for the strain gauge (field not currently used).
EXCITATION_VALUE

NUMBER(1)
V

Magnitude of the excitation.
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.
TEST_NAME

VARCHAR2(7)


Character string that uniquely identifies each series of test traces.
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.
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.