Sewer FOG PumpOuts
Field Name |
Caption |
Mask |
Description |
Field Type |
HO_ACT_CD |
Action |
nnn |
Action |
Integer |
HO_ACT_DT |
Action Date |
mm/dd/yyyy |
Action Date |
Date/Time |
HO_ACT_TM |
Action Time |
hh:mm am |
Action Time |
Date/Time |
HO_ACT_TY |
Action Text |
30x |
Action Text |
Text |
HO_APUMPED |
Amount Pumped |
nnnnn |
Amount Pumped |
Integer |
HO_AREP_CD |
Agency Rep |
nnn |
Agency Representative |
Integer |
HO_AREP_TY |
Agency Rep Text |
30x |
Agency Representative Text |
Text |
HO_CDUE_DT |
Due Date |
mm/dd/yyyy |
Cleaning or Pumpout Due Date |
Date/Time |
HO_CRT_BY |
Created By |
25x |
Created By |
Text |
HO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HO_DINAME |
Disposal Representative |
50x |
Disposal Representative |
Text |
HO_DISP_DT |
Disposal Date |
mm/dd/yyyy |
Disposal Date |
Date/Time |
HO_DISP_TM |
Disposal Time |
hh:mm am |
Disposal Time |
Date/Time |
HO_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
HO_DRNAME |
Driver Name |
50x |
Driver Name |
Text |
HO_ECOMENT |
Action Comment |
254x |
Action Comment |
Text |
HO_EX_ID |
Trap Record No |
nnnnnnnn |
Long Integer |
|
HO_FA_ID |
Facility Record No |
nnnnnnnn |
Long Integer |
|
HO_FD_ID |
Disposal Record No |
nnnnnnnn |
Long Integer |
|
HO_FREP |
Facility Representative |
50x |
Facility Representative |
Text |
HO_HA_ID |
Hauler Record No |
nnnnnnnn |
Long Integer |
|
HO_HNAME |
Hauler Name |
50x |
Hauler Name |
Text |
HO_HNUMBER |
Hauler Number |
30x |
Hauler Number |
Text |
HO_ICOMENT |
Internal Comment |
254x |
Internal Comment |
Text |
HO_ID |
PumpOut Rec # |
nnnnnnnn |
PumpOut Rec # |
Long Integer |
HO_LATEST |
Most Recent Inspection |
|
Most Recent Inspection |
Boolean |
HO_MAINTREQ |
Maint Requested |
|
Maint Requested |
Boolean |
HO_MANIF |
Manifest |
30x |
Mainifest |
Text |
HO_MOD_BY |
Last Mod By |
25x |
Last Modified By |
Text |
HO_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HO_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HO_NEEDREP |
Needs Repair |
|
Needs Repair |
Boolean |
HO_PMTH_CD |
Pump Method |
nnn |
Pump Method |
Integer |
HO_PMTH_TY |
Pump Method Text |
30x |
Pump Method Text |
Text |
HO_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
HO_RQ_ID |
Request Rec # |
nnnnnnnn |
Long Integer |
|
HO_RV_ID |
Rec Station Record No |
nnnnnnnn |
Long Integer |
|
HO_RVNAME |
Rec Station Name |
50x |
Receiving Station Name |
Text |
HO_RVNUMB |
Rec Station Number |
30x |
Receiving Station Number |
Text |
HO_UOM_CD |
UOM |
nnn |
UOM |
Integer |
HO_UOM_TY |
UOM Text |
30x |
UOM Text |
Text |
HO_VEHICL |
Vehicle Number |
20x |
Vehicle Number |
Text |
HO_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
HO_WTYP_CD |
Waste Type |
nnn |
Waste Type |
Integer |
HO_WTYP_TY |
Waste Type Text |
30x |
Waste Type Text |
Text |