Name: Inspection Report

Display Field: FacilityName

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• Type ( type: esriFieldTypeString , alias: Type of GCD? , length: 19 , Coded Values: [Grease Trap: Grease Trap] , [Grease Interceptor: Grease Interceptor] , [No GCD: No GCD] , ...1 more... )
• Variance ( type: esriFieldTypeString , alias: GCD Covered under Variance? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Cleaned ( type: esriFieldTypeString , alias: Cleaned and Maintained? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Frequency ( type: esriFieldTypeString , alias: Frequency , length: 12 , Coded Values: [Daily: Daily] , [Weekly: Weekly] , [Monthly: Monthly] , ...3 more... )
• Records ( type: esriFieldTypeString , alias: Cleaning/Maintenance Records on Site? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• BMPSign ( type: esriFieldTypeString , alias: BMP Signs Posted? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FollowBMP ( type: esriFieldTypeString , alias: Are BMPs Followed? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GroundFOG ( type: esriFieldTypeString , alias: FOG on Ground? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SewerInsp ( type: esriFieldTypeString , alias: Sewer Lines Inspected? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FOGinMH ( type: esriFieldTypeString , alias: FOG in downstream Man Hole? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Compliance ( type: esriFieldTypeString , alias: Compliance Action , length: 20 , Coded Values: [No Action: No Action] , [Informal Notice: Informal Notice] , [Notice of Violation: Notice of Violation] , ...5 more... )
• Comments ( type: esriFieldTypeString , alias: Comments , length: 750 )
• PERMIT ( type: esriFieldTypeString , alias: Permit , length: 6 )
• DATE ( type: esriFieldTypeDate , alias: Inspection Date , length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• Facility_ID ( type: esriFieldTypeSmallInteger , alias: Facility_ID )
• FacilityName ( type: esriFieldTypeString , alias: FacilityName , length: 250 )
• FollowUp30 ( type: esriFieldTypeDate , alias: 30 Day Follow Up , length: 8 )
• FollowUp60 ( type: esriFieldTypeDate , alias: 60 Day Follow Up , length: 8 )
• Compliant ( type: esriFieldTypeString , alias: Compliant , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• YearlyInspectionDue ( type: esriFieldTypeDate , alias: YearlyInspectionDue , length: 8 )
• F30DayFollowUpReq ( type: esriFieldTypeString , alias: 30 Day Follow Up Required? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• F60DayFUReq ( type: esriFieldTypeString , alias: 60 Day Follow Up Required? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Complete2018 ( type: esriFieldTypeString , alias: 2018 Inspection Completed? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Inspection2019 ( type: esriFieldTypeString , alias: 2019 Inspection Complete? , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Relationships:

• Food_Industry_Facilities (0) -- Related To: Food Industry Facilities (1)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata