#### LTPP TABLE NAVIGATOR: Field View

Fields for table: DLR_OH_STRAIN_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.
POINT_TYPE_1
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 1st point in microstrain for the raw trace.
TIME_SMOOTH_1

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 1st point in microstrain for the smoothed trace.
POINT_TYPE_2
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 2nd point in microstrain for the raw trace.
TIME_SMOOTH_2

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 2nd point in microstrain for the smoothed trace.
SHRP_ID

VARCHAR2(4)

Test section identification number assigned by LTPP program. Must be combined with STATE_CODE to be unique.
POINT_TYPE_3
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 3rd point in microstrain for the raw trace.
TIME_SMOOTH_3

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microstrain

Value of the 3rd point in microstrain for the smoothed trace.
POINT_TYPE_4
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 4th data point determined.
TIME_RAW_4

NUMBER(6)
milliseconds

Time along the trace at which the 4th raw point was determined.
STRAIN_VALUE_RAW_4

NUMBER(6,1)
microstrain

Value of the 4th point in microstrain for the raw trace.
TIME_SMOOTH_4

NUMBER(6)
milliseconds

Time along the trace at which the 4th smoothed point was determined.
STRAIN_VALUE_SMOOTH_4

NUMBER(6,1)
microstrain

Value of the 4th point in microstrain for the smoothed trace.
TEST_NAME

VARCHAR2(7)

Character string that uniquely identifies each series of test traces.
POINT_TYPE_5
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 5th data point determined.
TIME_RAW_5

NUMBER(6)
milliseconds

Time along the trace at which the 5th raw point was determined.
STRAIN_VALUE_RAW_5

NUMBER(6,1)
microstrain

Value of the 5th point in microstrain for the raw trace.
TIME_SMOOTH_5

NUMBER(6)
milliseconds

Time along the trace at which the 5th smoothed point was determined.
STRAIN_VALUE_SMOOTH_5

NUMBER(6,1)
microstrain

Value of the 5th point in microstrain for the smoothed trace.
POINT_TYPE_6
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 6th data point determined.
TIME_RAW_6

NUMBER(6)
milliseconds

Time along the trace at which the 6th raw point was determined.
STRAIN_VALUE_RAW_6

NUMBER(6,1)
microstrain

Value of the 6th point in microstrain for the raw trace.
TIME_SMOOTH_6

NUMBER(6)
milliseconds

Time along the trace at which the 6th smoothed point was determined.
STRAIN_VALUE_SMOOTH_6

NUMBER(6,1)
microstrain

Value of the 6th point in microstrain for the smoothed trace.
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.
POINT_TYPE_7
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 7th data point determined.
TIME_RAW_7

NUMBER(6)
milliseconds

Time along the trace at which the 7th raw point was determined.
STRAIN_VALUE_RAW_7

NUMBER(6,1)
microstrain

Value of the 7th point in microstrain for the raw trace.
TIME_SMOOTH_7

NUMBER(6)
milliseconds

Time along the trace at which the 7th smoothed point was determined.
STRAIN_VALUE_SMOOTH_7

NUMBER(6,1)
microstrain

Value of the 7th point in microstrain for the smoothed trace.
POINT_TYPE_8
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 8th data point determined.
TIME_RAW_8

NUMBER(6)
milliseconds

Time along the trace at which the 8th raw point was determined.
STRAIN_VALUE_RAW_8

NUMBER(6,1)
microstrain

Value of the 8th point in microstrain for the raw trace.
TIME_SMOOTH_8

NUMBER(6)
milliseconds

Time along the trace at which the 8th smoothed point was determined.
STRAIN_VALUE_SMOOTH_8

NUMBER(6,1)
microstrain

Value of the 8th point in microstrain for the smoothed trace.
TAG_ID

VARCHAR2(8)

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

NUMBER(7,3)
Hz

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

VARCHAR2(1)

A code indicating the general quality of the data.
GAIN_ADJUST_FACTOR

NUMBER(7,2)
microstrain

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

DATE

Date the field test was performed.
CHANNEL

VARCHAR2(10)

The channel number on which the sensor is wired.
COMMENTS

VARCHAR2(1)

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

VARCHAR2(10)

Number of peak points interpreted from the data trace.