{ "currentVersion": 10.61, "id": 2, "name": "Inspection Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FacilityName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type of GCD?", "length": 19, "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" } }, { "name": "Variance", "type": "esriFieldTypeString", "alias": "GCD Covered under Variance?", "length": 3, "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" } }, { "name": "Cleaned", "type": "esriFieldTypeString", "alias": "Cleaned and Maintained?", "length": 3, "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" } }, { "name": "Frequency", "type": "esriFieldTypeString", "alias": "Frequency", "length": 12, "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" } }, { "name": "Records", "type": "esriFieldTypeString", "alias": "Cleaning/Maintenance Records on Site?", "length": 50, "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" } }, { "name": "BMPSign", "type": "esriFieldTypeString", "alias": "BMP Signs Posted?", "length": 3, "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" } }, { "name": "FollowBMP", "type": "esriFieldTypeString", "alias": "Are BMPs Followed?", "length": 3, "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" } }, { "name": "GroundFOG", "type": "esriFieldTypeString", "alias": "FOG on Ground?", "length": 3, "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" } }, { "name": "SewerInsp", "type": "esriFieldTypeString", "alias": "Sewer Lines Inspected?", "length": 3, "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" } }, { "name": "FOGinMH", "type": "esriFieldTypeString", "alias": "FOG in downstream Man Hole?", "length": 50, "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" } }, { "name": "Compliance", "type": "esriFieldTypeString", "alias": "Compliance Action", "length": 20, "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" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 750, "domain": null }, { "name": "PERMIT", "type": "esriFieldTypeString", "alias": "Permit", "length": 6, "domain": null }, { "name": "DATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Facility_ID", "type": "esriFieldTypeSmallInteger", "alias": "Facility_ID", "domain": null }, { "name": "FacilityName", "type": "esriFieldTypeString", "alias": "FacilityName", "length": 250, "domain": null }, { "name": "FollowUp30", "type": "esriFieldTypeDate", "alias": "30 Day Follow Up", "length": 8, "domain": null }, { "name": "FollowUp60", "type": "esriFieldTypeDate", "alias": "60 Day Follow Up", "length": 8, "domain": null }, { "name": "Compliant", "type": "esriFieldTypeString", "alias": "Compliant", "length": 50, "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" } }, { "name": "YearlyInspectionDue", "type": "esriFieldTypeDate", "alias": "YearlyInspectionDue", "length": 8, "domain": null }, { "name": "F30DayFollowUpReq", "type": "esriFieldTypeString", "alias": "30 Day Follow Up Required?", "length": 50, "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" } }, { "name": "F60DayFUReq", "type": "esriFieldTypeString", "alias": "60 Day Follow Up Required?", "length": 50, "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" } }, { "name": "Complete2018", "type": "esriFieldTypeString", "alias": "2018 Inspection Completed?", "length": 50, "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" } }, { "name": "Inspection2019", "type": "esriFieldTypeString", "alias": "2019 Inspection Complete?", "length": 50, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Food_Industry_Facilities", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "PERMIT", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }