Sewer IPT Facility Maintenance Log Info
Field Name |
Caption |
Mask |
Description |
Field Type |
IM_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
IM_CRT_BY |
Created By |
25x |
Created By |
Text |
IM_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
IM_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
IM_ID |
Maintenance Log Rec # |
nnnnnnnn |
Maintenance Log Record Number |
Long Integer |
IM_IF_ID |
Facility Record No |
nnnnnnnn |
Long Integer |
|
IM_LFREQ |
Log Freq |
nnn |
Log Freq |
Integer |
IM_LFRQ_CD |
Log Freq Units |
nnn |
Log Freq Units |
Integer |
IM_LFRQ_TY |
Log Freq Units Text |
10x |
Log Freq Units Text |
Text |
IM_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
IM_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
IM_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
Date/Time |
IM_NLOG_DT |
Next Log Due Date |
mm/dd/yyyy |
Next Log Due Date |
Date/Time |
IM_NLOGCOM |
Next Log Complete |
|
Next Log Complete: The next Log Due Date has been submitted |
Boolean |
IM_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
IM_SLOG_DT |
Submitted Log Date |
mm/dd/yyyy |
Submitted Log Date |
Date/Time |
IM_TYPE_CD |
Log Type |
nnn |
Log Type |
Integer |
IM_TYPE_TY |
Log Type Text |
30x |
Log Type Text |
Text |