Name: Inspection Report

Display Field: FacilityName

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• Type ( type: esriFieldTypeString , alias: Type of GCD? , editable: true , nullable: true , 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? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Cleaned ( type: esriFieldTypeString , alias: Cleaned and Maintained? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Frequency ( type: esriFieldTypeString , alias: Frequency , editable: true , nullable: true , length: 12 , Coded Values: [Daily: Daily] , [Weekly: Weekly] , [Monthly: Monthly] , ...3 more... )
• Records ( type: esriFieldTypeString , alias: Cleaning/Maintenance Records on Site? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• BMPSign ( type: esriFieldTypeString , alias: BMP Signs Posted? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FollowBMP ( type: esriFieldTypeString , alias: Are BMPs Followed? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GroundFOG ( type: esriFieldTypeString , alias: FOG on Ground? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SewerInsp ( type: esriFieldTypeString , alias: Sewer Lines Inspected? , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• FOGinMH ( type: esriFieldTypeString , alias: FOG in downstream Man Hole? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Compliance ( type: esriFieldTypeString , alias: Compliance Action , editable: true , nullable: true , 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 , editable: true , nullable: true , length: 750 )
• PERMIT ( type: esriFieldTypeString , alias: Permit , editable: true , nullable: true , length: 6 )
• DATE ( type: esriFieldTypeDate , alias: Inspection Date , editable: true , nullable: true , length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• Facility_ID ( type: esriFieldTypeSmallInteger , alias: Facility_ID , editable: true , nullable: true )
• FacilityName ( type: esriFieldTypeString , alias: FacilityName , editable: true , nullable: true , length: 250 )
• FollowUp30 ( type: esriFieldTypeDate , alias: 30 Day Follow Up , editable: true , nullable: true , length: 8 )
• FollowUp60 ( type: esriFieldTypeDate , alias: 60 Day Follow Up , editable: true , nullable: true , length: 8 )
• Compliant ( type: esriFieldTypeString , alias: Compliant , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• YearlyInspectionDue ( type: esriFieldTypeDate , alias: YearlyInspectionDue , editable: true , nullable: true , length: 8 )
• F30DayFollowUpReq ( type: esriFieldTypeString , alias: 30 Day Follow Up Required? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• F60DayFUReq ( type: esriFieldTypeString , alias: 60 Day Follow Up Required? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Complete2018 ( type: esriFieldTypeString , alias: 2018 Inspection Completed? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• Inspection2019 ( type: esriFieldTypeString , alias: 2019 Inspection Complete? , editable: true , nullable: true , length: 50 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Templates:

• Name: Inspection Report
  Description:
  Prototype:
  Complete2018: null
  Inspection2019: null
  Type: null
  Variance: null
  Cleaned: null
  Frequency: null
  Records: null
  BMPSign: null
  FollowBMP: null
  GroundFOG: null
  SewerInsp: null
  FOGinMH: null
  Compliance: null
  Comments: null
  PERMIT: null
  DATE: null
  F60DayFUReq: null
  Facility_ID: null
  FacilityName: null
  FollowUp30: null
  FollowUp60: null
  Compliant: null
  YearlyInspectionDue: null
  F30DayFollowUpReq: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Create,Query,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata