SWIPTFIC

Sewer IPT Inspection Checklist

Field Name

Caption

Mask

Description

Field Type

CY_CRT_BY

Created By

25x

Created By

Text

CY_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

CY_ID

Insp Checklist Rec #

nnnnnnnn

Autonumber ID

Long Integer

CY_II_ID

Facility Insp Record No

nnnnnnnn

Link to SWIPTFI.II_ID

Long Integer

CY_MOD_BY

Last Mod By

25x

Last Modified By

Text

CY_MOD_DT

Last Mod Date

mm/dd/yyyy

Last Modified Date

Date/Time

CY_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

CY_NOTE

Note

250x

Note

Text

CY_NUMBER

Line Number

nnnn

Line Number

Integer

CY_PASS_CD

Pass

nnn

Pass

Integer

CY_PASS_TY

Pass Text

25x

Pass Text

Text

CY_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

CY_TEXT

Checklist Item

100x

Checklist Instructions

Text