STPVFLDD

Pavement Field Inspection Distress Details

Field Name

Caption

Mask

Description

Field Type

DF_CRT_BY

Created By

25x

Created By

Text

DF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

DF_DEN

Density

n

Density

Integer

DF_DISTRES

Distress

40x

Distress

Text

DF_DT_CD

Distress Type

nnn

Distress Type

Integer

DF_DT_TY

Distress Type Text

25x

Distress Type Text

Text

DF_FD_ID

Field Insp Rec #

nnnnnnnn

Link to STPVFLD.FD_ID

Long Integer

DF_FINALD

Final Deduct

nnn.n

Final Deduct

Double

DF_ID

Distress Rec #

nnnnnnnn

AutoID

Long Integer

DF_INITDED

Initial Deduct

nn.n

Initial Deduct

Double

DF_MOD_BY

Last Modified By

25x

Last Modified By

Text

DF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

DF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

DF_ORDER

Order

nnn

Order

Integer

DF_RATING

Rating

nn.n

Rating

Double

DF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

DF_SD

Use S/D?

 

Use Severity/Density?

Boolean

DF_SEV

Severity

n

Severity

Integer

DF_WF

Weighting Factor

nn.n

Weighting Factor

Double