LTPP Logo Long Term Pavement Performance Logo

LTPP TSSC Home

Data User's Corner





LTPP TABLE NAVIGATOR: Field View


Fields for table: TST_ESTAR_MASTER

Field NameCodesData TypeUnitsTest ProtocolDescription
ESTAR_LINK

NUMBER(4)


Unique key used in TST_ESTAR tables to link to TST_ESTAR_MASTER to identify STATE_CODE, SHRP/PROJECT_ID and other test information.
SAMPLE_DATE

DATE


Sampling date if field aged.
SAMPLE_AGE

NUMBER(5)
days

Sample age if field aged.
RECORD_STATUS

VARCHAR2(1)


A code indicating the general quality of the data.
STATE_CODE
STATE_PROVINCENUMBER(2)


Numerical code for state or province. U.S. codes are consistent with Federal Information Processing Standards.
SHRP_ID

VARCHAR2(4)


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

NUMBER(2)


Unique sequential number assigned to pavement layers, starting with layer 1 as the deepest layer (subgrade).
PROJECT_ID

VARCHAR2(4)


The 4 character identifier for the SPS project used to identify elements of information which are common to all sections in that project.
PROJECT_LAYER_CODE

VARCHAR2(1)


Sequential alphabetic code assigned to identify group project wide layers.
PREDICTIVE_MODEL
PREDICTIVE_MODELVARCHAR2(1)


Code indicating the predictive model used to generate ESTAR estimates.
CONSTRUCTION_DATE

DATE


Construction date of the layer.
SAMPLE_TYPE_ESTAR
SAMPLE_TYPE_ESTARVARCHAR2(1)


Code indicating the aging condition of the samples used for inputs into the ESTAR predictive models.