Name: InspectionHistory

Display Field: ESTABLISHMENTNAME

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ESTABLISHMENTNAME (type: esriFieldTypeString, alias: Establishment Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• PHONE (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• IDENTIFIER (type: esriFieldTypeString, alias: Identifier, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• PERMNUM (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CAPACITY (type: esriFieldTypeInteger, alias: Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPDESC (type: esriFieldTypeString, alias: Inspection Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Routine: Routine], [Follow-Up: Follow-Up], [Temporary: Temporary])
• SCORE (type: esriFieldTypeSmallInteger, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GRADE (type: esriFieldTypeString, alias: Restaurant Grade, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: A], [B: B], [C: C], ... 2 more ...)
• RISKTYPE (type: esriFieldTypeSmallInteger, alias: Risk Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Inspected one time per year], [2: Inspected two times per year], [3: Inspected 3 times per year])
• SUPERVISION (type: esriFieldTypeString, alias: Supervision, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• EMPLOYEEHEALTH (type: esriFieldTypeString, alias: Employee Health, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• APPROVEDSOURCE (type: esriFieldTypeString, alias: Approved Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• PROTECTIONFROMCONTAMINATION (type: esriFieldTypeString, alias: Protection from Contamination, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• CONSUMERADVISORY (type: esriFieldTypeString, alias: Consumer Advisory, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• HAZARDOUSFOODHOLDING (type: esriFieldTypeString, alias: Hazardous Food Holding, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• HSP (type: esriFieldTypeString, alias: HSP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• CHEMICALS (type: esriFieldTypeString, alias: Chemicals, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [In: In Compliance], [Out: Out of Compliance])
• INSPECTIONID (type: esriFieldTypeGUID, alias: Inspection ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• Tobacco_Stamps (type: esriFieldTypeString, alias: Tobacco_Stamps, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)
• Register_Usage (type: esriFieldTypeString, alias: Register_Usage, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown], ... 1 more ...)

Templates:

Name: InspectionHistory
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• RestaurantInspections (0) -- Related To: RestaurantInspections (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/17/2025 3:55:15 PM

Schema Last Edit Date: 6/17/2025 3:55:15 PM

Data Last Edit Date: 6/17/2025 3:48:44 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat