LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: CODES

Field NameCodesData TypeUnitsTest ProtocolDescription
CODETYPE

VARCHAR2(40)


Name assigned to a set of codes for a field in another table.
CODE

VARCHAR2(5)


Unique text value whose meaning is defined in CODES.DETAIL.
DETAIL

VARCHAR2(200)


Textual description defining the meaning of the code.
ADDL_CODE

VARCHAR2(2)


Additional code needed to uniquely define the meaning of a code. For example, both state and county code are needed to uniquely identify a county.
ADDL_CODETYPE

VARCHAR2(20)


Codetype of the code entered in the ADDL_CODE field.