Sewer FOG Extractor Info
Field Name |
Caption |
Mask |
Description |
Field Type |
EX_ADD_CD |
Additives |
nnn |
Additives |
Integer |
EX_ADD_TY |
Additives Text |
30x |
Additives Text |
Text |
EX_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
EX_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
EX_BR_CD |
Default WO Cat |
10x |
Default Category Code |
Text |
EX_BR_TY |
Default WO Cat Text |
60x |
Default Category Code |
Text |
EX_CFREQ |
Cleaning Freq |
nnn |
Cleaning Freq |
Integer |
EX_CFRQ_CD |
Cleaning Freq Units |
nnn |
Cleaning Freq Units |
Integer |
EX_CFRQ_TY |
Cleaning Freq Units Text |
10x |
Cleaning Freq Units Text |
Text |
EX_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
EX_CRT_BY |
Created By |
25x |
Created By |
Text |
EX_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
EX_DESC |
Description |
60x |
Description |
Text |
EX_DLIMIT |
Discharge Limit |
nnnnnnnn. |
Discharge Limit |
Double |
EX_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
EX_DUOM_CD |
Depth UOM |
nnn |
Depth UOM |
Integer |
EX_DUOM_TY |
Depth UOM Text |
30x |
Depth UOM Text |
Text |
EX_FA_ID |
Facility Record No |
nnnnnnnn |
Long Integer |
|
EX_FVIO1 |
% Full Violation - 1 |
nnnnnnnn. |
Percent Full Violation - Stage 1 (inlet side) |
Double |
EX_FVIO2 |
% Full Violation - 2 |
nnnnnnnn. |
Percent Full Violation - Stage 2 (effluent side) |
Double |
EX_ID |
Extractor Record Number |
nnnnnnnn |
Extractor Record Number |
Long Integer |
EX_INMAP |
In Map? |
|
Flag indicating this feature is in the map |
Boolean |
EX_INST_DT |
Install Date |
mm/dd/yyyy |
Install Date |
Date/Time |
EX_LCLN_DT |
Last Cleaning Date |
mm/dd/yyyy |
Last Cleaning Date |
Date/Time |
EX_LOCATE |
General Location |
100x |
General Location |
Text |
EX_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
EX_MAN_CD |
Manuf |
10x |
Manufacturer |
Text |
EX_MAN_TY |
Manuf Name |
60x |
Manufacturer Text |
Text |
EX_MINSTAL |
Mandatory Install? |
|
Mandatory Install? |
Boolean |
EX_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
EX_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
EX_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
EX_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
EX_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
EX_NCLN_DT |
Next Cleaning Date |
mm/dd/yyyy |
Next Cleaning Date |
Date/Time |
EX_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
EX_PROPTAG |
|
52x |
Property ID Tag |
Text |
EX_RETI_DT |
Retire Date |
mm/dd/yyyy |
Retire Date |
Date/Time |
EX_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
EX_STYPE_CD |
Subtype |
nnn |
GIS Subtype Code |
Integer |
EX_STYPE_TY |
Subtype Text |
25x |
GIS Subtype Text |
Text |
EX_SUOM_CD |
Size UOM |
nnn |
Size UOM |
Integer |
EX_SUOM_TY |
Size UOM Text |
30x |
Size UOM Text |
Text |
EX_TDEPTH |
Trap Depth |
nnnnnnnn. |
Trap Depth |
Double |
EX_TSIZE |
Trap Size |
nnnnnnnn. |
Trap Size |
Double |
EX_TYPE_CD |
Extractor Type |
nnn |
Extractor Type |
Integer |
EX_TYPE_TY |
Extractor Type Text |
30x |
Extractor Type Text |
Text |
EX_UNITID |
Unit ID |
25x |
Unit ID |
Text |
EX_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
EX_USER1TY |
User 1 Text |
30x |
User 1 Text |
Text |
EX_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
EX_USER2TY |
User 2 Text |
30x |
User 2 Text |
Text |
EX_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
EX_USER3TY |
User 3 Text |
30x |
User 3 Text |
Text |
EX_USER4CD |
User 4 |
nnn |
User 4 |
Integer |
EX_USER4TY |
User 4 Text |
30x |
User 4 Text |
Text |
EX_USER5CD |
User 5 |
nnn |
User 5 |
Integer |
EX_USER5TY |
User 5 Text |
30x |
User 5 Text |
Text |
EX_USER6 |
User 6 |
30x |
User 6 |
Text |
EX_USER7 |
User 7 |
30x |
User 7 |
Text |
EX_USER8 |
User 8 |
30x |
User 8 |
Text |
EX_USER9 |
User 9 |
30x |
User 9 |
Text |
EX_USER10 |
User 10 |
30x |
User 10 |
Text |
EX_USER11 |
User 11 |
nnnnnnnn.nn |
User 11 |
Double |
EX_USER12 |
User 12 |
nnnnnnnn.nn |
User 12 |
Double |
EX_USER13 |
User 13 |
nnnnnnnn.nn |
User 13 |
Double |
EX_USER14 |
User 14 |
nnnnnnnn.nn |
User 14 |
Double |
EX_USER15 |
User 15 |
nnnnnnnn.nn |
User 15 |
Double |
EX_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
Date/Time |
EX_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
Date/Time |
EX_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
Date/Time |
EX_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
Date/Time |
EX_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
Date/Time |
EX_USER21 |
User 21 |
|
User 21 |
Boolean |
EX_USER22 |
User 22 |
|
User 22 |
Boolean |
EX_USER23 |
User 23 |
|
User 23 |
Boolean |
EX_USER24 |
User 24 |
|
User 24 |
Boolean |
EX_USER25 |
User 25 |
|
User 25 |
Boolean |
EX_USER26CD |
User 26 |
10x |
User 26 |
String |
EX_USER26TY |
User 26 Text |
60x |
User 26 Text |
String |
EX_USER27CD |
User 27 |
10x |
User 27 |
String |
EX_USER27TY |
User 27 Text |
60x |
User 27 Text |
String |
EX_USER28CD |
User 28 |
10x |
User 28 |
String |
EX_USER28TY |
User 28 Text |
60x |
User 28 Text |
String |
EX_USER29CD |
User 29 |
10x |
User 29 |
String |
EX_USER29TY |
User 29 Text |
60x |
User 29 Text |
String |
EX_USER30CD |
User 30 |
10x |
User 30 |
String |
EX_USER30TY |
User 30 Text |
60x |
User 30 Text |
String |
EX_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
EX_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |
EX_Z |
Elevation |
nnnnnnnnn.nn |
Elevation |
Double |