Sewer FOG Facility Maintenance Log Info
Field Name |
Caption |
Mask |
Description |
Field Type |
FL_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
FL_CRT_BY |
Created By |
25x |
Created By |
Text |
FL_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FL_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
FL_FA_ID |
Facility Record No |
nnnnnnnn |
Long Integer |
|
FL_ID |
Maintenance Log Rec # |
nnnnnnnn |
Maintenance Log Record Number |
Long Integer |
FL_LFREQ |
Log Freq |
nnn |
Log Freq |
Integer |
FL_LFRQ_CD |
Log Freq Units |
nnn |
Log Freq Units |
Integer |
FL_LFRQ_TY |
Log Freq Units Text |
10x |
Log Freq Units Text |
Text |
FL_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
FL_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FL_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
Date/Time |
FL_NLOG_DT |
Next Log Due Date |
mm/dd/yyyy |
Next Log Due Date |
Date/Time |
FL_NLOGCOM |
Next Log Complete |
|
Next Log Complete: The next Log Due Date has been submitted |
Boolean |
FL_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FL_SLOG_DT |
Submitted Log Date |
mm/dd/yyyy |
Submitted Log Date |
Date/Time |
FL_TYPE_CD |
Log Type |
nnn |
Log Type |
Integer |
FL_TYPE_TY |
Log Type Text |
50x |
Log Type Text |
Text |