#### LTPP TABLE NAVIGATOR: Field View

Fields for table: DLR_OH_LVDT_TRACE_SUM_AC

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

VARCHAR2(10)

Number of peak points interpreted from data trace.
POINT_TYPE_1
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 1st data point determined.
TIME_SMOOTH_1

NUMBER(6)
milliseconds

Time along the trace at which the 1st smoothed point was determined.
LVDT_VALUE_SMOOTH_1

NUMBER(6,1)
microns

Value of the 1st point for the smoothed trace.
TIME_RAW_1

NUMBER(6)
milliseconds

Time along the trace at which the 1st raw point was determined.
LVDT_VALUE_RAW_1

NUMBER(6,1)
microns

Value of the 1st point for the raw trace.
POINT_TYPE_2
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 2nd data point determined.
TIME_SMOOTH_2

NUMBER(6)
milliseconds

Time along the trace at which the 2nd smoothed point was determined.
LVDT_VALUE_SMOOTH_2

NUMBER(6,1)
microns

Value of the 2nd point for the smoothed trace.
TIME_RAW_2

NUMBER(6)
milliseconds

Time along the trace at which the 2nd raw point was determined.
SHRP_ID

VARCHAR2(4)

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

NUMBER(6,1)
microns

Value of the 2nd point for the raw trace.
POINT_TYPE_3
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 3rd data point determined.
TIME_SMOOTH_3

NUMBER(6)
milliseconds

Time along the trace at which the 3rd smoothed point was determined.
LVDT_VALUE_SMOOTH_3

NUMBER(6,1)
microns

Value of the 3rd point for the smoothed trace.
TIME_RAW_3

NUMBER(6)
milliseconds

Time along the trace at which the 3rd raw point was determined.
LVDT_VALUE_RAW_3

NUMBER(6,1)
microns

Value of the 3rd point for the raw trace.
DATA_COLLECTION_FREQUENCY

NUMBER(7,3)
Hz

The data recording frequency for the sensor time-history trace.

NUMBER(7,2)
microns

Average value of the first 500 data points used as the zero point for trace interpretation.
TEST_NAME

VARCHAR2(7)

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

NUMBER(3)

Consecutive number of the test runs within a defined testing matrix. This number is also used as the file extension for the raw data files.
TAG_ID

VARCHAR2(8)

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

VARCHAR2(1)

A code indicating the general quality of the data.
TEST_DATE

DATE

Date the field test was performed.
CHANNEL

VARCHAR2(10)

The channel number on which the sensor is wired.