SMQFN

Storm Water Quality Management Plan Notifications

Field Name

Caption

Mask

Description

Field Type

FN_CRT_BY

Created By

25x

Created By

String

FN_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FN_DOC_FLG

Document Flag

 

Document Flag

Boolean

FN_ID

Management Plan Notification Record Number

nnnnnnnn

Auto ID

Long Integer

FN_MOD_BY

Last Modified By

25x

Last Modified By

String

FN_MOD_DT

Last Modified Date

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FN_MOD_TM

Modified Time

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FN_NOT_CD

Notification

nnn

Notification

Integer

FN_NOT_TY

Notification Text

50x

Notification Text

String

FN_QF_ID

Management Plan Record No

nnnnnnnn

Link to SMQF.QF_ID

Long Integer

FN_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

FN_SENT_BY

Sent By

25x

Sent By

String

FN_SENT_DT

Sent Date

mm/dd/yyyy hh:mm am

Sent Date

DateTime