LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: LTPPDD

Field NameCodesData TypeUnitsTest ProtocolDescription
TABLENAME

VARCHAR2(40)


Name of the table.
FIELD_KEY

VARCHAR2(2)


A value of PK in this fields indicates that the field is a primary key.
FIELD_ORDER

NUMBER(3)


A number assigned to each field in a table used to order the fields for presentation.
FIELDNAME

VARCHAR2(40)


Name of the field.
DATA_TYPE

VARCHAR2(15)


Data type of field.
DATASHEET

VARCHAR2(40)


Data collection form that is the data source. Field is null for electronically collected data or data for which no data collection sheet exists..
DESCRIPTION

VARCHAR2(500)


Complete description of the field.
CODETYPE

VARCHAR2(240)


A description of the codes valid for the field. This will either be the name of a codes table (shown in all caps), or a list of descriptions and corresponding codes.
UNITS

VARCHAR2(20)


Units in which data are stored.
ITEM

VARCHAR2(30)


Item number on the data collection form from which the field is obtained. If multiple items, the first item is shown. It is generally left blank when the item appears on different sheets.
PROTOCOL

VARCHAR2(10)


Name of the LTPP test protocol.