{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "swSCM_Inspections", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OWNERNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 20, "domain": null }, { "name": "CERTDATE", "type": "esriFieldTypeDate", "alias": "Certificate Date", "length": 8, "domain": null }, { "name": "INSPMONTH", "type": "esriFieldTypeString", "alias": "Inspection Month", "length": 24, "domain": { "type": "codedValue", "name": "swMonth", "description": "Months of the year", "codedValues": [ { "name": "January", "code": "jan" }, { "name": "February", "code": "feb" }, { "name": "March", "code": "mar" }, { "name": "April", "code": "apr" }, { "name": "May", "code": "may" }, { "name": "June", "code": "jun" }, { "name": "July", "code": "jul" }, { "name": "August", "code": "aug" }, { "name": "September", "code": "sep" }, { "name": "October", "code": "oct" }, { "name": "November", "code": "nov" }, { "name": "December", "code": "dec" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSPECTIONTYPE", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 15, "domain": { "type": "codedValue", "name": "swInspType", "description": "Type of inspection", "codedValues": [ { "name": "Town of Cary", "code": "toc" }, { "name": "Private", "code": "pri" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "INSPECTIONRESULT", "type": "esriFieldTypeString", "alias": "Inspection Results", "length": 30, "domain": { "type": "codedValue", "name": "swInspResult", "description": "Inspection results", "codedValues": [ { "name": "Compliant", "code": "comp" }, { "name": "Compliant w/ Maintenance", "code": "compwmaint" }, { "name": "Non-Compliant", "code": "noncomp" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NEXTTOCINSPDATE", "type": "esriFieldTypeDate", "alias": "Next TOC Inspection Date", "length": 8, "domain": null }, { "name": "TOCINSPNOTES", "type": "esriFieldTypeString", "alias": "TOC Inspection Notes", "length": 255, "domain": null }, { "name": "INSPNOTES", "type": "esriFieldTypeString", "alias": "Inspection Notes", "length": 255, "domain": null }, { "name": "NONCOMPCONTMETH", "type": "esriFieldTypeString", "alias": "Non Compliance Contact Method", "length": 100, "domain": { "type": "codedValue", "name": "swNCcontactvia", "description": "Method of contacting non compliant SCMs", "codedValues": [ { "name": "Phone", "code": "phone" }, { "name": "Email", "code": "email" }, { "name": "Mail", "code": "mail" }, { "name": "Certified Mail", "code": "certmail" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NONCOMPACTION", "type": "esriFieldTypeString", "alias": "Non Compliance Action", "length": 100, "domain": { "type": "codedValue", "name": "swNonCompAct", "description": "Compliance actions", "codedValues": [ { "name": "Request Maintenance and Photos", "code": "reqmaintphotos" }, { "name": "Request Repair and Reinspection", "code": "reqreinsp" }, { "name": "Request Report", "code": "reqreport" }, { "name": "Extension Granted", "code": "extensiongrant" }, { "name": "Notice to Correct", "code": "noticetocor" }, { "name": "Notice of Violation", "code": "noticeofvio" }, { "name": "Citation", "code": "citation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NONCOMPACTIONDATE", "type": "esriFieldTypeDate", "alias": "Non Compliance Action Date", "length": 8, "domain": null }, { "name": "COMPACHIEVEDVIA", "type": "esriFieldTypeString", "alias": "Compliance Achieved Via", "length": 255, "domain": { "type": "codedValue", "name": "swNCres", "description": "How the non complaince is resolved", "codedValues": [ { "name": "Photos", "code": "photos" }, { "name": "Inspection", "code": "inspection" }, { "name": "Submit Report", "code": "submitreport" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMPDUEDATE", "type": "esriFieldTypeDate", "alias": "Compliance Due Date", "length": 8, "domain": null }, { "name": "NEXTCOMPACTION", "type": "esriFieldTypeString", "alias": "Next Compliance Action", "length": 100, "domain": { "type": "codedValue", "name": "swNonCompAct", "description": "Compliance actions", "codedValues": [ { "name": "Request Maintenance and Photos", "code": "reqmaintphotos" }, { "name": "Request Repair and Reinspection", "code": "reqreinsp" }, { "name": "Request Report", "code": "reqreport" }, { "name": "Extension Granted", "code": "extensiongrant" }, { "name": "Notice to Correct", "code": "noticetocor" }, { "name": "Notice of Violation", "code": "noticeofvio" }, { "name": "Citation", "code": "citation" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NONCOMPNOTES", "type": "esriFieldTypeString", "alias": "Non Compliance Notes", "length": 255, "domain": null } ], "indexes": [ { "name": "G161FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "swSCM", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FACILITYID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7331DED3-6457-4975-B9BE-A12862759F10}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1764070193000 }, "serviceItemId": "a6b5f6227b1648dab2e0d29934050ee1" }