SWIPTNF

Sewer IPT Facility Notifications

Field Name

Caption

Mask

Description

Field Type

NF_CRT_BY

Created By

25x

Created By

Text

NF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

NF_DOC_FLG

Document Available

 

Document Flag

Boolean

NF_ID

Notification Rec #

nnnnnnnn

Notification Record Number

Long Integer

NF_IF_ID

Facility Rec #

nnnnnnnn

Link to SWIPTF.IF_ID

Long Integer

NF_MOD_BY

Last Modified By

25x

Last Modified By

Text

NF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

NF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

NF_NOT_CD

Notification Code

nnn

Notification

Integer

NF_NOT_TY

Notification Type

30x

Notification Text

Text

NF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

NF_SENT_BY

Sent By

25x

Sent By

Text

NF_SENT_DT

Date Sent

mm/dd/yyyy

Sent Date

Date/Time