STPVPCID

Pavement PCI Setup/Distress Type Join Table

Field Name

Caption

Mask

Description

Field Type

DD_CL_ID

Pavement Rec #

nnnnnnnn

Link to STPVPCI.CL_ID

Long Integer

DD_CRT_BY

Created By

25x

Created By

Text

DD_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

DD_DR_ID

Distress Rec #

nnnnnnnn

Link to STPVDIST.DR_ID

Long Integer

DD_ID

Matchup Rec #

nnnnnnnn

AutoID

Long Integer

DD_MOD_BY

Last Modified By

25x

Last Modified By

Text

DD_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

DD_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time