STSWPRBFIX

Side Walk Repair Requirements

Field Name

Caption

Mask

Description

Field Type

WF_CRT_BY

Created By

25x

Created By

Text

WF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

WF_ID

Auto Number

nnnnnnnn

AutoID

Long Integer

WF_MAT_CD

Material

12x

Material

Text

WF_MAT_TY

Material Text

50x

Material Text

Text

WF_MOD_BY

Last Modified By

25x

Last Modified By

Text

WF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

WF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

WF_NOTE

Note

200x

Comment

Text

WF_RECNO

Recommend #

nnn

Recommendation No

Integer

WF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

WF_UNITS

Units

nnnn.

Rating

Double

WF_UOM_CD

UOM

12x

Problem

Text

WF_UOM_TY

UOM Text

50x

Problem Text

Text

WF_WP_ID

Sidewalk Insp Prob Rec #

nnnnnnnn

Link to STSWPROB.WP_ID

Long Integer