{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 4,
 "name": "Work Order Activities",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "CONTACT_NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "ORACLE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "ORACLE_ID",
   "domain": null
  },
  {
   "name": "INCIDENT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "INCIDENT_ID",
   "domain": null
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_ACTIVITY_TYPE_1",
    "description": "SW_ACTIVITY_TYPE",
    "codedValues": [
     {
      "name": "INSPECTION",
      "code": "I"
     },
     {
      "name": "SENT",
      "code": "S"
     },
     {
      "name": "RECEIVED",
      "code": "R"
     },
     {
      "name": "PHONE CALL",
      "code": "P"
     },
     {
      "name": "MEETING",
      "code": "M"
     },
     {
      "name": "NOTE",
      "code": "N"
     },
     {
      "name": "NOV",
      "code": "NOV"
     },
     {
      "name": "NOV-CP",
      "code": "NOV-CP"
     },
     {
      "name": "CPA",
      "code": "CPA"
     },
     {
      "name": "APPEAL",
      "code": "AP"
     },
     {
      "name": "DECISION",
      "code": "D"
     },
     {
      "name": "DEMAND",
      "code": "DD"
     },
     {
      "name": "PENALTY PAID",
      "code": "PP"
     },
     {
      "name": "CEASE DESIST",
      "code": "CD"
     },
     {
      "name": "TRO INJUNCTION",
      "code": "TRO"
     },
     {
      "name": "NEW",
      "code": "NEW"
     },
     {
      "name": "LETTER",
      "code": "L"
     },
     {
      "name": "REVIEW",
      "code": "RV"
     },
     {
      "name": "CONTACT",
      "code": "CON"
     },
     {
      "name": "SWPPP UPDATE",
      "code": "SWPPP"
     },
     {
      "name": "MEMO",
      "code": "MEMO"
     },
     {
      "name": "TRAINING",
      "code": "TRN"
     },
     {
      "name": "RECHECK",
      "code": "RC"
     },
     {
      "name": "Response_Enf",
      "code": "RESPONSE_ENF"
     },
     {
      "name": "Vehicle_Note",
      "code": "VEHICLE_NOTE"
     },
     {
      "name": "Rescind",
      "code": "RSC"
     },
     {
      "name": "Appeal Requested",
      "code": "APR"
     },
     {
      "name": "Appeal Hearing",
      "code": "APH"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "DATE",
   "type": "esriFieldTypeDate",
   "alias": "DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "INITIALS",
   "type": "esriFieldTypeString",
   "alias": "INITIALS",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_INITIALS",
    "description": "SW_INITIALS",
    "codedValues": [
     {
      "name": "Chan Higgenbottom",
      "code": "CH"
     },
     {
      "name": "Heather Holtz",
      "code": "HH"
     },
     {
      "name": "Jennifer Kisner-Johnson",
      "code": "JK"
     },
     {
      "name": "Maylynne Wilbert",
      "code": "MW"
     },
     {
      "name": "Pamela Riddick-Carroll",
      "code": "PRC"
     },
     {
      "name": "Stephanie Hardy",
      "code": "SH"
     },
     {
      "name": "Tasha King-Davis",
      "code": "TKD"
     },
     {
      "name": "Yvette Holmes",
      "code": "YH"
     },
     {
      "name": "Christopher Studaway",
      "code": "CS"
     },
     {
      "name": "Steven Boatwright",
      "code": "SB"
     },
     {
      "name": "Lori Baldridge",
      "code": "LB"
     },
     {
      "name": "Wayne Moore",
      "code": "WM"
     },
     {
      "name": "NEW",
      "code": "NEW"
     },
     {
      "name": "Raymonde Bell",
      "code": "RB"
     },
     {
      "name": "Essie Washington",
      "code": "EW"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "length": 3500,
   "domain": null
  },
  {
   "name": "REVIEW_INFO",
   "type": "esriFieldTypeString",
   "alias": "REVIEW_INFO",
   "length": 50,
   "domain": null
  },
  {
   "name": "ENGINEER",
   "type": "esriFieldTypeString",
   "alias": "ENGINEER",
   "length": 50,
   "domain": null
  },
  {
   "name": "PE_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "PE_NUMBER",
   "length": 50,
   "domain": null
  },
  {
   "name": "TIMESPENT",
   "type": "esriFieldTypeDouble",
   "alias": "TIMESPENT",
   "domain": null
  },
  {
   "name": "RESOLVED",
   "type": "esriFieldTypeString",
   "alias": "RESOLVED",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RESOLVED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "RESOLVED_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "RESPONSE_DUE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "RESPONSE_DUE_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "DRAINS_MARKED",
   "type": "esriFieldTypeInteger",
   "alias": "DRAINS_MARKED",
   "domain": {
    "type": "range",
    "name": "SW_COUNT_1",
    "description": "SW_COUNT",
    "range": [
     0,
     99
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "FIELD_NOTES",
   "type": "esriFieldTypeString",
   "alias": "FIELD_NOTES",
   "length": 3500,
   "domain": null
  },
  {
   "name": "SOURCE",
   "type": "esriFieldTypeString",
   "alias": "Complaint_Recd",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_SCOURCE_1",
    "description": "SW_SOURCE",
    "codedValues": [
     {
      "name": "OBSERVED",
      "code": "OBSERVED"
     },
     {
      "name": "CMEM",
      "code": "CMEM"
     },
     {
      "name": "TDEC",
      "code": "TDEC"
     },
     {
      "name": "WWW",
      "code": "WWW"
     },
     {
      "name": "311",
      "code": "311"
     },
     {
      "name": "FOUND",
      "code": "FOUND"
     },
     {
      "name": "ADMIN",
      "code": "ADMIN"
     },
     {
      "name": "OTHER",
      "code": "OTHER"
     },
     {
      "name": "PHONE",
      "code": "PHONE"
     },
     {
      "name": "EMA Spill",
      "code": "EMA Spill"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "QAQC",
   "type": "esriFieldTypeString",
   "alias": "QAQC",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ACTIVITY_ID",
   "type": "esriFieldTypeDouble",
   "alias": "ACTIVITY_ID",
   "domain": null
  },
  {
   "name": "CONTACT_NAME",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_NAME",
   "length": 100,
   "domain": null
  },
  {
   "name": "CONTACT_BUSINESS",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_BUSINESS",
   "length": 200,
   "domain": null
  },
  {
   "name": "CONTACT_PHONE",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_PHONE",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONTACT_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_ADDRESS",
   "length": 50,
   "domain": null
  },
  {
   "name": "Number_Trained",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number_Trained",
   "domain": null
  },
  {
   "name": "DateEntered",
   "type": "esriFieldTypeDate",
   "alias": "DateEntered",
   "length": 8,
   "domain": null
  },
  {
   "name": "DateReceived",
   "type": "esriFieldTypeDate",
   "alias": "DateReceived",
   "length": 8,
   "domain": null
  },
  {
   "name": "Pics_To_S",
   "type": "esriFieldTypeDate",
   "alias": "Pics_To_S",
   "length": 8,
   "domain": null
  },
  {
   "name": "Date_Delivered",
   "type": "esriFieldTypeDate",
   "alias": "Date_Delivered",
   "length": 8,
   "domain": null
  },
  {
   "name": "Sign_in_Scanned",
   "type": "esriFieldTypeString",
   "alias": "Sign_in_Scanned",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Maps_Created",
   "type": "esriFieldTypeString",
   "alias": "Maps_Created",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CONTACT_CELL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_CELL",
   "length": 50,
   "domain": null
  },
  {
   "name": "Date_Resolved",
   "type": "esriFieldTypeDate",
   "alias": "Date_Resolved",
   "length": 8,
   "domain": null
  },
  {
   "name": "Truck",
   "type": "esriFieldTypeString",
   "alias": "Truck#",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "SW_TRUCK",
    "description": "",
    "codedValues": [
     {
      "name": "E601",
      "code": "E601"
     },
     {
      "name": "E602",
      "code": "E602"
     },
     {
      "name": "E774",
      "code": "E774"
     },
     {
      "name": "E811",
      "code": "E811"
     },
     {
      "name": "E2815",
      "code": "E2815"
     },
     {
      "name": "E2817",
      "code": "E2817"
     },
     {
      "name": "E2818",
      "code": "E2818"
     },
     {
      "name": "E2819",
      "code": "E2819"
     },
     {
      "name": "E3194",
      "code": "E3194"
     },
     {
      "name": "NEW",
      "code": "NEW"
     },
     {
      "name": "E300",
      "code": "E300"
     },
     {
      "name": "E301",
      "code": "E301"
     },
     {
      "name": "E302",
      "code": "E302"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ENG_FIRM",
   "type": "esriFieldTypeString",
   "alias": "ENG_FIRM",
   "length": 50,
   "domain": null
  },
  {
   "name": "CONTACT_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_EMAIL",
   "length": 100,
   "domain": null
  },
  {
   "name": "CONTACT_US_MAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_US_MAIL",
   "length": 200,
   "domain": null
  },
  {
   "name": "CERT1",
   "type": "esriFieldTypeString",
   "alias": "CERT#1",
   "length": 50,
   "domain": null
  },
  {
   "name": "CERT2",
   "type": "esriFieldTypeString",
   "alias": "CERT#2",
   "length": 50,
   "domain": null
  },
  {
   "name": "CPA_AMOUNT",
   "type": "esriFieldTypeDouble",
   "alias": "CPA Amount",
   "domain": null
  },
  {
   "name": "RP_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "RP_EMAIL",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R172_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G3254ORACLE_ID",
   "fields": "ORACLE_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 3,
   "name": "ACTIVITIES_TO_ORDERS",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "ORACLE_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{EFCDF906-15D9-4EAF-9AE8-6A7581EF803B}"
  }
 ],
 "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": "d2e38ad636d044188f5e4762c6113073"
}