{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 19,
 "name": "CE NoV Report Table",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "DIVISION",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID"
  },
  {
   "name": "DIVISION",
   "type": "esriFieldTypeString",
   "alias": "Division",
   "length": 150
  },
  {
   "name": "DEPARTMENT",
   "type": "esriFieldTypeString",
   "alias": "Department",
   "length": 150
  },
  {
   "name": "CATEGORY",
   "type": "esriFieldTypeString",
   "alias": "Category",
   "length": 50
  },
  {
   "name": "INCIDENT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "Oracle ID"
  },
  {
   "name": "INCIDENT_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Service Request Number",
   "length": 15
  },
  {
   "name": "INCIDENT_TYPE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "Service Request Type ID"
  },
  {
   "name": "REQUEST_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Service Request Type",
   "length": 50
  },
  {
   "name": "REPORTED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Reported Date",
   "length": 8
  },
  {
   "name": "REQUEST_SUMMARY",
   "type": "esriFieldTypeString",
   "alias": "Service Request Summary",
   "length": 2000
  },
  {
   "name": "CREATED_BY_USER",
   "type": "esriFieldTypeString",
   "alias": "Created By",
   "length": 255
  },
  {
   "name": "LAST_UPDATE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Last Updated Date",
   "length": 8
  },
  {
   "name": "UPDATED_BY_USER",
   "type": "esriFieldTypeString",
   "alias": "Updated By",
   "length": 50
  },
  {
   "name": "FOLLOWUP_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Follow Up Date",
   "length": 8
  },
  {
   "name": "NOV_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Notice Given Date",
   "length": 8
  },
  {
   "name": "Court_Date",
   "type": "esriFieldTypeDate",
   "alias": "Court Date",
   "length": 8
  },
  {
   "name": "JOB_NOTES",
   "type": "esriFieldTypeString",
   "alias": "Job Notes",
   "length": 255
  },
  {
   "name": "CLOSE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "Closed Date",
   "length": 8
  },
  {
   "name": "SUPERVISOR",
   "type": "esriFieldTypeString",
   "alias": "Supervisor",
   "length": 50
  },
  {
   "name": "ADDRESS1",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 255
  },
  {
   "name": "ADDRESS2",
   "type": "esriFieldTypeString",
   "alias": "Apt/ Unit No",
   "length": 100
  },
  {
   "name": "ADDRESS3",
   "type": "esriFieldTypeString",
   "alias": "P.O. Box",
   "length": 100
  },
  {
   "name": "CITY",
   "type": "esriFieldTypeString",
   "alias": "City",
   "length": 100
  },
  {
   "name": "STATE",
   "type": "esriFieldTypeString",
   "alias": "State",
   "length": 50
  },
  {
   "name": "POSTAL_CODE",
   "type": "esriFieldTypeString",
   "alias": "Postal Code",
   "length": 20
  },
  {
   "name": "PARCEL_ID",
   "type": "esriFieldTypeString",
   "alias": "Parcel ID",
   "length": 20
  },
  {
   "name": "PERSON_ADDRESS1",
   "type": "esriFieldTypeString",
   "alias": "Owner Address1",
   "length": 255
  },
  {
   "name": "PERSON_ADDRESS2",
   "type": "esriFieldTypeString",
   "alias": "Owner Address2",
   "length": 255
  },
  {
   "name": "PERSON_ADDRESS3",
   "type": "esriFieldTypeString",
   "alias": "Owner Address3",
   "length": 255
  },
  {
   "name": "PERSON_STATE",
   "type": "esriFieldTypeString",
   "alias": "Owner State",
   "length": 50
  },
  {
   "name": "PERSON_CITY",
   "type": "esriFieldTypeString",
   "alias": "Owner City",
   "length": 100
  },
  {
   "name": "PERSON_ZIP_CODE",
   "type": "esriFieldTypeString",
   "alias": "Owner Zip Code",
   "length": 50
  },
  {
   "name": "MAP_PG",
   "type": "esriFieldTypeString",
   "alias": "Map Page",
   "length": 50
  },
  {
   "name": "MAP_BLK",
   "type": "esriFieldTypeString",
   "alias": "Map Block",
   "length": 50
  },
  {
   "name": "CODE_DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "Code District",
   "length": 50
  },
  {
   "name": "CODE_SUBDISTRICT",
   "type": "esriFieldTypeString",
   "alias": "Code Sub-District",
   "length": 50
  },
  {
   "name": "TARGET_BLOCK",
   "type": "esriFieldTypeString",
   "alias": "Target Block",
   "length": 50
  },
  {
   "name": "MLGW_CUSTOMER",
   "type": "esriFieldTypeString",
   "alias": "MLGW Customer",
   "length": 255
  },
  {
   "name": "MLGW_CONTACT1",
   "type": "esriFieldTypeString",
   "alias": "MLGW Contact 1",
   "length": 25
  },
  {
   "name": "MLGW_CONTACT2",
   "type": "esriFieldTypeString",
   "alias": "MLGW Contact 2",
   "length": 25
  },
  {
   "name": "MLGW_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "MLGW Contact Email",
   "length": 100
  },
  {
   "name": "X_COORD",
   "type": "esriFieldTypeDouble",
   "alias": "X_COORD"
  },
  {
   "name": "Y_COORD",
   "type": "esriFieldTypeDouble",
   "alias": "Y_COORD"
  },
  {
   "name": "Abate_Date",
   "type": "esriFieldTypeDate",
   "alias": "Abatement Date",
   "length": 8
  },
  {
   "name": "Sect_3081",
   "type": "esriFieldTypeString",
   "alias": "Sect. 308.1",
   "length": 10
  },
  {
   "name": "Sect_3082_3083",
   "type": "esriFieldTypeString",
   "alias": "Sect. 308.1",
   "length": 10
  },
  {
   "name": "Sect_3092_3093_3095",
   "type": "esriFieldTypeString",
   "alias": "Sect. 309.2;309.3;309.5",
   "length": 10
  },
  {
   "name": "Sect_6054",
   "type": "esriFieldTypeString",
   "alias": "Sect. 605.4",
   "length": 10
  },
  {
   "name": "Sect_6023_6031",
   "type": "esriFieldTypeString",
   "alias": "Sect. 602.3; 603.1",
   "length": 10
  },
  {
   "name": "Sect_3027_3041",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.7; 304.1",
   "length": 10
  },
  {
   "name": "Sect_3081_3082",
   "type": "esriFieldTypeString",
   "alias": "Sect. 308.1; 308.2",
   "length": 10
  },
  {
   "name": "Sect_3024",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.4",
   "length": 10
  },
  {
   "name": "Sect_3021_3081",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.1; 308.1",
   "length": 10
  },
  {
   "name": "Sect_3028_1",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.8",
   "length": 10
  },
  {
   "name": "Sect_3028_2",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.8",
   "length": 10
  },
  {
   "name": "Sect_3028_30281_30282",
   "type": "esriFieldTypeString",
   "alias": "Sect. 302.8; 302.8.1; 302.8.2",
   "length": 10
  },
  {
   "name": "Other_Offense",
   "type": "esriFieldTypeString",
   "alias": "Other Offenses",
   "length": 255
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8
  },
  {
   "name": "SR_GUID",
   "type": "esriFieldTypeGUID",
   "alias": "SR_GUID",
   "length": 38
  },
  {
   "name": "NOV_Recip",
   "type": "esriFieldTypeString",
   "alias": "NOV_Recip",
   "length": 255
  },
  {
   "name": "NOV_Violation",
   "type": "esriFieldTypeString",
   "alias": "NOV_Violation",
   "length": 255
  },
  {
   "name": "Violator",
   "type": "esriFieldTypeString",
   "alias": "Violator",
   "length": 255
  },
  {
   "name": "Insp_PhoneNum",
   "type": "esriFieldTypeString",
   "alias": "Insp_PhoneNum",
   "length": 50
  }
 ],
 "indexes": [
  {
   "name": "R83_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_83",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_2608_SR_GUID",
   "fields": "SR_GUID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 4,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 7,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 10,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 13,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 16,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 5,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 19,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 6,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 22,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 13,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 25,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 7,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 28,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 8,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 31,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 9,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 34,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 10,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  },
  {
   "id": 37,
   "name": "PW_Code_ServiceRequests",
   "relatedTableId": 12,
   "role": "esriRelRoleDestination",
   "keyField": "SR_GUID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{B8A608E6-B127-4763-9E50-8BD1821BEA02}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "b0dc60ad91304e60b3d0deb884c64074"
}