#### LTPP TABLE NAVIGATOR: Field View

Fields for table: DLR_NC_LVDT_TRACE_SUM_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.
LVDT_END_OFFSET

NUMBER(6,1)
microns

Average value of 200 data points at the end of the trace used to determine an ending reference.
LVDT_RANGE

NUMBER(6,1)
microns

Total difference in values along the trace determined by the difference between the maximum and minimum responses throughout the full recorded trace. Please note that points outside the area of interest may be included.
COMMENT_CODE

NUMBER(2)

Comment code. (Field not currently used.)

VARCHAR2(50)

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

NUMBER(2)

Number of points used to represent the data trace.
POINT_TYPE_1
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

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

VARCHAR2(4)

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

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

Time along the trace at which the 2nd smoothed point was determined.
POINT_TYPE_3
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

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

NUMBER(6)
milliseconds

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

VARCHAR2(7)

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

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

NUMBER(6,1)
microns

Value of the 4th point for the raw trace.
TIME_RAW_4

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

Value of the 4th point for the smoothed trace.
TIME_SMOOTH_4

NUMBER(6)
milliseconds

Time along the trace at which the 4th smoothed point was determined.
POINT_TYPE_5
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

Value of the 5th point for the raw trace.
TIME_RAW_5

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

Value of the 5th point for the smoothed trace.
TIME_SMOOTH_5

NUMBER(6)
milliseconds

Time along the trace at which the 5th smoothed point was determined.
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_6
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

Value of the 6th point for the raw trace.
TIME_RAW_6

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

Value of the 6th point for the smoothed trace.
TIME_SMOOTH_6

NUMBER(6)
milliseconds

Time along the trace at which the 6th smoothed point was determined.
POINT_TYPE_7
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

Value of the 7th point for the raw trace.
TIME_RAW_7

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

Value of the 7th point for the smoothed trace.
TIME_SMOOTH_7

NUMBER(6)
milliseconds

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

VARCHAR2(8)

Descriptive tag given to the channel within the data collection software.
POINT_TYPE_8
DLR_POINT_TYPEVARCHAR2(1)

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

NUMBER(6,1)
microns

Value of the 8th point for the raw trace.
TIME_RAW_8

NUMBER(6)
milliseconds

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

NUMBER(6,1)
microns

Value of the 8th point for the smoothed trace.
TIME_SMOOTH_8

NUMBER(6)
milliseconds

Time along the trace at which the 8th smoothed point was determined.
POINT_TYPE_9
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 9th data point determined.
LVDT_VALUE_RAW_9

NUMBER(6,1)
microns

Value of the 9th point for the raw trace.
TIME_RAW_9

NUMBER(6)
milliseconds

Time along the trace at which the 9th raw point was determined.
LVDT_VALUE_SMOOTH_9

NUMBER(6,1)
microns

Value of the 9th point for the smoothed trace.
TIME_SMOOTH_9

NUMBER(6)
milliseconds

Time along the trace at which the 9th smoothed point was determined.
TEST_DATE

DATE

Date of the peak determination.
POINT_TYPE_10
DLR_POINT_TYPEVARCHAR2(1)

Code for the type of the 10th data point determined.
LVDT_VALUE_RAW_10

NUMBER(6,1)
microns

Value of the 10th point for the raw trace.
TIME_RAW_10

NUMBER(6)
milliseconds

Time along the trace at which the 10th raw point was determined.
LVDT_VALUE_SMOOTH_10

NUMBER(6,1)
microns

Value of the 10th point for the smoothed trace.
TIME_SMOOTH_10

NUMBER(6)
milliseconds

Time along the trace at which the 10th smoothed point was determined.
RECORD_STATUS

VARCHAR2(1)

A code indicating the general quality of the data.
CHANNEL

NUMBER(3)

The channel number on which the sensor is wired.
NUMBER_OF_POINTS

NUMBER(3)

Number of points used in the central point averaging to determine the summary data points.
LVDT_BEGIN_OFFSET

NUMBER(6,1)
microns

Average value of 200 data points at the beginning of the trace used to determine a starting reference.