Sewer FOG Inspection Checklist
Field Name |
Caption |
Mask |
Description |
Field Type |
NB_CRT_BY |
Created By |
25x |
Created By |
Text |
NB_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
NB_FN_ID |
Facility Insp Record No |
nnnnnnnn |
Long Integer |
|
NB_ID |
Inspection BMP Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
NB_MOD_BY |
Last Mod By |
25x |
Last Modified By |
Text |
NB_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
NB_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
NB_NOTE |
Note |
250x |
Note |
Text |
NB_NUMBER |
Line Number |
nnnnn |
Line Number |
Integer |
NB_PASS_CD |
Pass |
nnn |
Pass |
Integer |
NB_PASS_TY |
Pass Text |
25x |
Pass Text |
Text |
NB_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
NB_TEXT |
Checklist Item |
250x |
Checklist Instructions |
Text |