Sewer FOG Extractor Inspections
Field Name |
Caption |
Mask |
Description |
Field Type |
FG_COC |
Chain of Custody |
|
Chain of Custody |
Boolean |
FG_COND_CD |
Condition |
nnn |
Condition |
Integer |
FG_COND_TY |
Condition Text |
30x |
Condition Text |
Text |
FG_CRT_BY |
Created By |
25x |
Created By |
Text |
FG_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
FG_DEPO1 |
Deposition Depth 1 |
nnnnnnnn. |
Deposition Depth on Stage 1 (influent) Side |
Double |
FG_DEPO2 |
Deposition Depth 2 |
nnnnnnnn. |
Deposition Depth on Stage 2 (effluent) Side |
Double |
FG_DESC |
Description |
60x |
Description |
Text |
FG_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
FG_EX_ID |
Extractor Record No |
nnnnnnnn |
Long Integer |
|
FG_FN_ID |
Inspection Record No |
nnnnnnnn |
Long Integer |
|
FG_FPERC1 |
Percent Full 1 |
nnnnnnnn. |
Percent Full on Stage 1 (influent) Side |
Double |
FG_FPERC2 |
Percent Full 2 |
nnnnnnnn. |
Percent Full on Stage 2 (effluent) Side |
Double |
FG_FVIO1 |
% Full Violation 1 |
nnnnnnnn. |
Percent Full Violation on Stage 1 (influent) Side |
Double |
FG_FVIO2 |
% Full Violation 2 |
nnnnnnnn. |
Percent Full Violation on Stage 2 (effluent) Side |
Double |
FG_GREASE1 |
Grease Depth 1 |
nnnnnnnn. |
Grease Depth |
Double |
FG_GREASE2 |
Grease Depth 2 |
nnnnnnnn. |
Grease Depth on Stage 2 (effluent) Side |
Double |
FG_HDEPTH1 |
Total Fluid Depth 1 |
nnnnnnnn. |
Total Fluid Depth on Stage 1 (influent) Side |
Double |
FG_HDEPTH2 |
Total Fluid Depth 2 |
nnnnnnnn. |
Total Fluid Depth on Stage 2 (effluent) Side |
Double |
FG_ID |
Insp Grease Record Number |
nnnnnnnn |
Extractor Inspection Record Number |
Long Integer |
FG_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
FG_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
FG_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
FG_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
FG_SAMPLE |
Sample Pulled |
|
Sample Pulled |
Boolean |
FG_SCOMENT |
Short Comment |
254x |
Short Comment |
Text |
FG_SNUMBER |
Sample Number |
20x |
Sample Number |
Text |
FG_TYPE_CD |
Extractor Type |
nnn |
Extractor Type |
Integer |
FG_TYPE_TY |
Extractor Type Text |
30x |
Extractor Type Text |
Text |
FG_UNITID |
Unit ID |
25x |
Unit ID |
Text |
FG_VIOL1 |
Violation 1 |
|
Violation on Stage 1 (influent) Side |
Boolean |
FG_VIOL2 |
Violation 2 |
|
Violation on Stage 2 (effluent) Side |
Boolean |