Name: OWWSB_GDB.DBO.GreaseControlInspections

Display Field: FACILITYNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• INSPECTIONDT ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• FACILITYNAME ( type: esriFieldTypeString, alias: Facility Name, length: 100 )
• FACILITYREP ( type: esriFieldTypeString, alias: Facility Representative, length: 100 )
• REPTITLE ( type: esriFieldTypeString, alias: Representative Title, length: 50 )
• PHONE ( type: esriFieldTypeString, alias: Phone Number, length: 10 )
• OWNERNAME ( type: esriFieldTypeString, alias: Owner/Regional Manager Name, length: 50 )
• FACILITYADDR ( type: esriFieldTypeString, alias: Facility Address, length: 100 )
• GPSID ( type: esriFieldTypeString, alias: GPS ID, length: 50 )
• LASTGREASEPUMP ( type: esriFieldTypeDate, alias: Last time Grease Pumped, length: 8 )
• PUMPER ( type: esriFieldTypeString, alias: Name of Pumper, length: 50 , Coded Values: [Advance Septic: Advance Septic] , [Anniston Septic Tank Service: Anniston Septic Tank Service] , [Economy Septic Tank Service: Economy Septic Tank Service] , ...7 more... )
• PUMPERPREFFERED ( type: esriFieldTypeString, alias: Is Pumper a _Preferred Pumper_ with Oxford WWSB, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• GREASEINTERCEPTOR ( type: esriFieldTypeString, alias: Grease Interceptor, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• INTERCEPTORSIZE ( type: esriFieldTypeSmallInteger, alias: Interceptor Size , Coded Values: [500: 500 gallons] , [750: 750 gallons] , [1000: 1000 gallons] , ...4 more... )
• OTHERSIZE ( type: esriFieldTypeSmallInteger, alias: Other Size , Range: [0, 0] )
• TWOINTERCEPTORS ( type: esriFieldTypeString, alias: Two Interceptors in Series, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• MANHOLEACCESS ( type: esriFieldTypeSmallInteger, alias: Manhole Access to Interceptor , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• ESTGREASEDEPTH ( type: esriFieldTypeSmallInteger, alias: Estimated Grease Layer Depth )
• EFFLUENTTVISIBLE ( type: esriFieldTypeString, alias: Effluent T visible, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• EFFLUENTTGOOD ( type: esriFieldTypeString, alias: Effluent T attached and in good condition, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• INTERCEPTORHAULER ( type: esriFieldTypeString, alias: Grease Interceptor Hauler Used, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• BACTERIAENZYMESUSED ( type: esriFieldTypeString, alias: Bacteria/Enzymes used, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• BACENZPRODNAME ( type: esriFieldTypeString, alias: Product Name, length: 100 )
• FREQINTERCEPTORUSED ( type: esriFieldTypeString, alias: Frequency Interceptor Cleaned, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• COMPCONTENTSPUMPED ( type: esriFieldTypeString, alias: Complete Contents Pumped, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• RECMAINTCLEANAVAIL ( type: esriFieldTypeString, alias: Records of Maintenance/Cleaning Available, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• LASTDATECLEANED ( type: esriFieldTypeDate, alias: Last Date Cleaned, length: 8 )
• ISGREASETRAP ( type: esriFieldTypeString, alias: Is Grease Trap, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• GTLOCATION ( type: esriFieldTypeString, alias: Grease Trap Location, length: 20 , Coded Values: [Under sink trap: Under sink trap] , [Floor trap: Floor trap] , [Outside floor trap: Outisde floor trap] )
• GTFLOWRAT ( type: esriFieldTypeString, alias: Grease Trap flow-thru rating/grease capacity estimate, length: 50 , Coded Values: [5 gpm/10 lb: 5 gpm/10 lb] , [10 gpm/20 lb: 10 gpm/20 lb] , [15 gpm/30 lb: 15 gpm/30 lb] , ...4 more... )
• GTFLOWRATOTHER ( type: esriFieldTypeString, alias: Flow-thru/Capacity Other Estimate, length: 15 )
• FREQTRAPCLEANED ( type: esriFieldTypeString, alias: Frequency Trap is cleaned, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• GTRECMAINTCLEANAVAIL ( type: esriFieldTypeString, alias: Grease Trap Records of Maintenance/Cleaning Available, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• GTCOMMENTS ( type: esriFieldTypeString, alias: Grease Trap comments/, length: 255 )
• BESTMANPRACIMPLEMENTED ( type: esriFieldTypeString, alias: Best Management Practices Implemented, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• GREASERECYCLEBIN ( type: esriFieldTypeString, alias: Grease Recycle Bin, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• CLEANOUTCOVMISSING ( type: esriFieldTypeString, alias: Cleanout Covers missing or Damaged, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• NUMMISSING ( type: esriFieldTypeSmallInteger, alias: Number Missing , Range: [0, 10] )
• NUMDAMAGED ( type: esriFieldTypeSmallInteger, alias: Number Damaged , Range: [0, 10] )
• FOGIMPACT ( type: esriFieldTypeString, alias: FOG impact at dumpster or around recycle bin, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• FOGCOMMENT ( type: esriFieldTypeString, alias: If Yes, please explain, length: 255 )
• DSMANHOLENAME ( type: esriFieldTypeString, alias: Downstream Manhole (GIS Name), length: 50 )
• DSMANHOLELOC ( type: esriFieldTypeString, alias: Downstream Manhole Location, length: 100 )
• EVGREASEMANHOLE ( type: esriFieldTypeString, alias: Evidence of Grease in Manhole, length: 10 , Coded Values: [None: None] , [Slight: Slight] , [Moderate: Moderate] , ...1 more... )
• EVGREASEMANCOMMENT ( type: esriFieldTypeString, alias: Grease Evidence Comment, length: 255 )
• SAMPLEPOINTACCESS ( type: esriFieldTypeString, alias: Sample Point Access, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• EFFLUENTTEMP ( type: esriFieldTypeDouble, alias: Effluent Temperature (F) )
• EFFLUENTPH ( type: esriFieldTypeDouble, alias: Effluent pH )
• SAMPLEPOINTLOC ( type: esriFieldTypeString, alias: Sample Point Location, length: 50 , Coded Values: [Interceptor Effluent T: Interceptor Effluent T] , [Downstream MH: Downstream MH] , [Cleanout: Cleanout] , ...1 more... )
• INTERCEPTORPHOTOS ( type: esriFieldTypeString, alias: Interceptor Photos, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• DSMANHOLEPHOTOS ( type: esriFieldTypeString, alias: Downstream MH Photos, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• OTHERPHOTOS ( type: esriFieldTypeString, alias: Other Photos, length: 3 , Coded Values: [Yes: Yes] , [No: No] , [Unk: Unknown] )
• PHOTOOTHERCOMMENT ( type: esriFieldTypeString, alias: Other Photos COmment, length: 255 )
• VISUALINSPCOMMENT ( type: esriFieldTypeString, alias: Visual Inspection Results and Comments, length: 255 )
• INSPECTORNAME ( type: esriFieldTypeString, alias: Inspector Name, length: 100 )
• REL_ID ( type: esriFieldTypeString, alias: REL_ID, length: 50 )

Relationships:

• ssGreaseSeparator (1) -- Related To: Grease Separator (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata