{ "currentVersion": 10.61, "id": 2, "name": "Inspection Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Food_Industry_Facilities", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PERMIT", "composite": true } ], "isDataVersioned": true, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "FacilityName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type of GCD?", "domain": { "type": "codedValue", "name": "fogGCDType", "description": "The type of Grease Control Device at a Food Service Establishment", "codedValues": [ { "name": "Grease Trap", "code": "Grease Trap" }, { "name": "Grease Interceptor", "code": "Grease Interceptor" }, { "name": "No GCD", "code": "No GCD" }, { "name": "Grease Trap/Grease Interceptor", "code": "Grease Trap/Grease Interceptor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 19 }, { "name": "Variance", "type": "esriFieldTypeString", "alias": "GCD Covered under Variance?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "Cleaned", "type": "esriFieldTypeString", "alias": "Cleaned and Maintained?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "Frequency", "type": "esriFieldTypeString", "alias": "Frequency", "domain": { "type": "codedValue", "name": "Frequency", "description": "The frequency in which an asset is inspected or maintained.", "codedValues": [ { "name": "Daily", "code": "Daily" }, { "name": "Weekly", "code": "Weekly" }, { "name": "Monthly", "code": "Monthly" }, { "name": "Quarterly", "code": "Quarterly" }, { "name": "Annually", "code": "Annually" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12 }, { "name": "Records", "type": "esriFieldTypeString", "alias": "Cleaning/Maintenance Records on Site?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "BMPSign", "type": "esriFieldTypeString", "alias": "BMP Signs Posted?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "FollowBMP", "type": "esriFieldTypeString", "alias": "Are BMPs Followed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "GroundFOG", "type": "esriFieldTypeString", "alias": "FOG on Ground?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "SewerInsp", "type": "esriFieldTypeString", "alias": "Sewer Lines Inspected?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3 }, { "name": "FOGinMH", "type": "esriFieldTypeString", "alias": "FOG in downstream Man Hole?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "Compliance", "type": "esriFieldTypeString", "alias": "Compliance Action", "domain": { "type": "codedValue", "name": "ComplianceAction", "description": "The Compliance action placed on an establishment following an inspection.", "codedValues": [ { "name": "No Action", "code": "No Action" }, { "name": "Informal Notice", "code": "Informal Notice" }, { "name": "Notice of Violation", "code": "Notice of Violation" }, { "name": "Civil Penalties", "code": "Civil Peanalties" }, { "name": "Non-Compliance Notice", "code": "Non Compliance" }, { "name": "Other", "code": "Other" }, { "name": "30 Day Follow Up", "code": "FollowUp30" }, { "name": "60 Day Follow Up", "code": "FollowUp60" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20 }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 750 }, { "name": "PERMIT", "type": "esriFieldTypeString", "alias": "Permit", "domain": null, "editable": true, "nullable": true, "length": 6 }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38 }, { "name": "Facility_ID", "type": "esriFieldTypeSmallInteger", "alias": "Facility_ID", "domain": null, "editable": true, "nullable": true }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "domain": null, "editable": true, "nullable": true, "length": 250 }, { "name": "FollowUp30", "type": "esriFieldTypeDate", "alias": "30 Day Follow Up", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "FollowUp60", "type": "esriFieldTypeDate", "alias": "60 Day Follow Up", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "Compliant", "type": "esriFieldTypeString", "alias": "Compliant", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "YearlyInspectionDue", "type": "esriFieldTypeDate", "alias": "YearlyInspectionDue", "domain": null, "editable": true, "nullable": true, "length": 8 }, { "name": "F30DayFollowUpReq", "type": "esriFieldTypeString", "alias": "30 Day Follow Up Required?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "F60DayFUReq", "type": "esriFieldTypeString", "alias": "60 Day Follow Up Required?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "Complete2018", "type": "esriFieldTypeString", "alias": "2018 Inspection Completed?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 }, { "name": "Inspection2019", "type": "esriFieldTypeString", "alias": "2019 Inspection Complete?", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50 } ], "indexes": [ { "name": "R16_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_16", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G23FacilityName", "fields": "FacilityName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_16", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_23_PERMIT", "fields": "PERMIT", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Inspection Report", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, AMF, geoJSON", "capabilities": "Create,Query,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 1000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }