SWIPTFCT

Sewer IPT Facility Categorical Codes

Field Name

Caption

Mask

Description

Field Type

FB_CAT_CD

Category

20x

Category

Text

FB_CAT_TY

Category Description

254x

Category Description

Text

FB_CRT_BY

Created By

25x

Created By

Text

FB_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

FB_ID

Cat Facility Rec #

nnnnnnnn

Autonumber ID

Long Integer

FB_IF_ID

Facility Rec #

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

FB_MOD_BY

Last Modified By

25x

Last Modified By

Text

FB_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

FB_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

FB_ROWVER

 

 

Rowversion for optimistic locking

Date/Time