FOG Inspection Data Fields

Information relating to a FOG Inspection can be viewed and edited on the FOG Inspection Grid Window of the Survey Grid or the FOG Inspection Property Sheet.

To view and edit all FOG inspection data, use the Property Sheet.

The following describes all the data which can be used to define a FOG inspection object.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

FOG Inspection Data

Database Table Name: cams_fog_inspection

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

Precision

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

ID

Unique identifier for the survey. This is based on the associated property by default.

id

Text

40

 

0

 

 

 

 

 

Property ID

ID of the surveyed property.

property_id

Text

40

 

0

 

 

 

 

 

Purpose of visit

Reason for carrying out survey:

Database Value

Description
Scheduled Scheduled
Unannounced Unannounced
Violation Violation
Complaint Complaint

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

purpose_of_visit

Text

40

 

 

 

 

 

 

 

Permit number

Permit number.

permit_number

Text

40

 

 

 

 

 

 

 

Permit displayed

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

permit_displayed

Text

10

 

 

 

 

 

 

 

Survey date

Date survey carried out.

survey_date

Date / Time

 

 

0

 

 

 

 

 

Location

Description of location at which survey carried out.

location

Text

100

 

0

 

 

 

 

 

Overall condition

A measure of the overall condition of the surveyed establishment.

overall_condition

Long Integer

 

 

0

 

 

 

0

5

X coordinate

X coordinate of survey.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of survey.

y

Double

 

XY

2

 

 

 

 

 

Facility name

Name of establishment surveyed.

facility_name

Text

200

 

 

 

 

 

 

 

Facility owner

Owner of establishment surveyed.

facility_owner

Text

200

 

 

 

 

 

 

 

Facility type

Type of establishment surveyed:

Database Value

Description
Restaurant Restaurant
Fast food restaurant Fast food restaurant
Commercial Commercial
Caterer Caterer
Bakery Bakery
Meat cutter Meat cutter
Deli Deli
Other Other

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

facility_type

Text

40

 

 

 

 

 

 

 

Facility address

Address of establishment surveyed.

facility_address

Text

200

 

 

 

 

 

 

 

Facility town

Name of town in which surveyed establishment is located.

facility_town

Text

200

 

 

 

 

 

 

 

Facility district

Name of district in which surveyed establishment is located.

facility_district

Text

200

 

 

 

 

 

 

 

Facility postalcode

Postal code in which surveyed establishment is located.

facility_postalcode

Text

200

 

 

 

 

 

 

 

Facility contact name

Name of contact for surveyed establishment.

facility_contact_name

Text

200

 

 

 

 

 

 

 
Facility phone Phone number of surveyed establishment. faciilty_phone Text 200              
Facility fax Fax number of surveyed establishment. facility_fax Text 200              
Interceptor type

Type of interceptor used:

Database Value

Description
Grease trap Grease trap
Interceptor Interceptor
Common interceptor Common interceptor
Separator Separator
Screens Screens
Combination of devices Combination of devices
None None
Other Other

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_type Text 40              
Interceptor suitably marked

Interceptor is legibly marked with manufacturer and model details:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_suitably_marked Text 10              
Interceptor serves a single facility

Interceptor serves a single establishment:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_single_facility Text 10              
Interceptor suitably sized

Interceptor is sized according to appropriate guidelines:

Database Value

Description
Yes Yes
No No
N/A N/A
interceptor_suitably_sized Text 10              
Interceptor suitably installed

Interceptor is installed according to appropriate guidelines:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_suitably_installed Text 10              
Interceptor accessible

Interceptor is easily accessible for inspection and cleaning:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_accessible Text 10              
Number of units Number of interceptor units. number_of_units Long Integer                
Capacity Size of interceptor. capacity Double   VO 0          
Interceptor Location Location of interceptor. interceptor_location Text 200              
Pump out schedule

Frequency of pump out schedule:

Database Value

Description
Weekly Weekly
Monthly Monthly
Quarterly Quarterly

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 pump_out_schedule Text 40              
Pump out provider Pumper/service provider. pump_out_provider Text 40              
Management monitoring pump out

Management observes pumping to ensure it is carried out correctly:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 management_monitoring_pump_out Text 10              
Interceptor completely cleaned

Pump out schedule includes complete pumping/cleaning of interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_completely_cleaned Text 10              
Vault filled with clean water

Vault refilled with clean water after interceptor maintenance:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 vault_filled_with_clean_water Text 10              
Enzymes/bacteria used

Enzymes or bacteria used during interceptor maintenance:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 enzymes_bacteria_used Text 10              
Maintenance log available

FOG control system maintenance log is accessible:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 maintenance_log_available Text 10              
Maintenance log submitted

FOG control system maintenance log has been submitted on time:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 maintenance_log_submitted Text 10              
Dishwashers discharge to interceptor

Dishwashers plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 dishwashers Text 10              
Sinks discharge to interceptor

Sinks plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 sinks Text 10              
Floor drains discharge to interceptor

Floor drains plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 floor_drains Text 10              
Food steamers discharge to interceptor

Food steamers plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 food_steamers Text 10              
Food grinders discharge to interceptor

Food grinders plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 food_grinders Text 10              
Steam kettles discharge to interceptor

Steam kettles plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A
steam_kettles Text 10              
Can washers discharge to interceptor

Can washers plumbed to discharge to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 can_washers Text 10              
Exhaust hoods filters maintained periodically

Exhaust hoods and filters cleaned or maintained periodically:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 exhaust_hoods_filters Text 10              
Floor mats, floor and grill tops maintained periodically

Floor mats, floors and grill tops cleaned or maintained periodically:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 floor_mats_floor_grill_tops Text 10              
Interceptor exterior maintained periodically

Exterior of interceptor cleaned or maintained periodically:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 interceptor_exterior Text 10              
External waste containers maintained periodically

Outside waste containers cleaned or maintained periodically:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 external_waste_containers Text 10              
Equipment dry-wiped before washing

Equipment e.g. pots, pans, dishware is dry-wiped prior to washing:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 equipment_dry_wiped Text 10              
Clean up water discharged to grease trap

Clean up water discharged to interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 cleanup_water_to_grease_trap Text 10              
Food waste FOGs not discharged to interceptor

Food waste FOGs are not discharged to the interceptor:

Database Value

Description
Yes Yes
No No
N/A N/A
fogs_not_to_interceptor Text 10              
Suitable equipment available for dry cleanup

Suitable equipment provided for dry cleanup:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 equipped_dry_cleanup Text 10              
Suitable equipment available for spill cleanup

Suitable equipment provided for cleaning up spills or leakages:

Database Value

Description
Yes Yes
No No
N/A N/A
equipped_spill_cleanup Text 10              
Training plan established for FOGs

A training program has been implemented:

Database Value

Description
Yes Yes
No No
N/A N/A
fog_training_plan Text 10              
Employees trained for FOGs

Employees have received training for handling FOGs:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 fog_employees_trained Text 10              
New employees trained for FOGs

New employees receive training for handling FOGs:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 fog_new_employees_trained Text 10              
Signs posted in key areas

Signs are posted in appropriate locations:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 signs_posted_in_key_areas Text 10              
Spill prevention plan is current

Spill prevention plan is up to date:

Database Value

Description
Yes Yes
No No
N/A N/A
spill_prevention_plan_is_current Text 10              
Outside storage bins suitably covered/sealed

Outdoor grease and oil storage containers are covered with tight/sealed lids or covers:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 bins_sealed_or_covered Text 10              
Outside storage bins cannot discharge to storm drains

Outdoor grease and oil storage containers are protected from discharge to storm drains:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 bins_cannot_discharge_to Text 10              
Outside storage bins checked for links or overflow

Outdoor grease and oil storage containers do not show signs of overflowing:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 bins_checked_for_leaks Text 10              
Storm drain clear of grease or oil

Storm drain shows no signs of grease or oil:

Database Value

Description
Yes Yes
No No
N/A N/A
storm_drain_clear_of_grease Text 10              
Disposal contractor has suitable licences and permits

Disposal contractor has correct licences and permits to handle FOGs waste:

Database Value

Description
Yes Yes
No No
N/A N/A

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

 disposal_contractor_licenced Text 10              
Scheduled Task fields See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.                    
Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

 attachments Array                
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    

FOG Inspections

Survey Grid

Network Data Fields

Common Data Fields