{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 4,
 "name": "Work Order Activities",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 3,
   "name": "ACTIVITIES_TO_ORDERS",
   "relatedTableId": 3,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "ORACLE_ID",
   "composite": false,
   "catalogID": "{EFCDF906-15D9-4EAF-9AE8-6A7581EF803B}"
  }
 ],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "CONTACT_NAME",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "ORACLE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "ORACLE_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ORACLE_ID"
  },
  {
   "name": "INCIDENT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "INCIDENT_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "INCIDENT_ID"
  },
  {
   "name": "TYPE",
   "type": "esriFieldTypeString",
   "alias": "TYPE",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "TYPE"
  },
  {
   "name": "DATE",
   "type": "esriFieldTypeDate",
   "alias": "DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DATE"
  },
  {
   "name": "INITIALS",
   "type": "esriFieldTypeString",
   "alias": "INITIALS",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "INITIALS"
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 3500,
   "defaultValue": null,
   "modelName": "NOTES"
  },
  {
   "name": "REVIEW_INFO",
   "type": "esriFieldTypeString",
   "alias": "REVIEW_INFO",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "REVIEW_INFO"
  },
  {
   "name": "ENGINEER",
   "type": "esriFieldTypeString",
   "alias": "ENGINEER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ENGINEER"
  },
  {
   "name": "PE_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "PE_NUMBER",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "PE_NUMBER"
  },
  {
   "name": "TIMESPENT",
   "type": "esriFieldTypeDouble",
   "alias": "TIMESPENT",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "TIMESPENT"
  },
  {
   "name": "RESOLVED",
   "type": "esriFieldTypeString",
   "alias": "RESOLVED",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "RESOLVED"
  },
  {
   "name": "RESOLVED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "RESOLVED_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "RESOLVED_DATE"
  },
  {
   "name": "RESPONSE_DUE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "RESPONSE_DUE_DATE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "RESPONSE_DUE_DATE"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "DRAINS_MARKED"
  },
  {
   "name": "FIELD_NOTES",
   "type": "esriFieldTypeString",
   "alias": "FIELD_NOTES",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 3500,
   "defaultValue": null,
   "modelName": "FIELD_NOTES"
  },
  {
   "name": "SOURCE",
   "type": "esriFieldTypeString",
   "alias": "Complaint_Recd",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "SOURCE"
  },
  {
   "name": "QAQC",
   "type": "esriFieldTypeString",
   "alias": "QAQC",
   "domain": {
    "type": "codedValue",
    "name": "YesNoIndicator",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "QAQC"
  },
  {
   "name": "ACTIVITY_ID",
   "type": "esriFieldTypeDouble",
   "alias": "ACTIVITY_ID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ACTIVITY_ID"
  },
  {
   "name": "CONTACT_NAME",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_NAME",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "CONTACT_NAME"
  },
  {
   "name": "CONTACT_BUSINESS",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_BUSINESS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 200,
   "defaultValue": null,
   "modelName": "CONTACT_BUSINESS"
  },
  {
   "name": "CONTACT_PHONE",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_PHONE",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CONTACT_PHONE"
  },
  {
   "name": "CONTACT_ADDRESS",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_ADDRESS",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CONTACT_ADDRESS"
  },
  {
   "name": "Number_Trained",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number_Trained",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "Number_Trained"
  },
  {
   "name": "DateEntered",
   "type": "esriFieldTypeDate",
   "alias": "DateEntered",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DateEntered"
  },
  {
   "name": "DateReceived",
   "type": "esriFieldTypeDate",
   "alias": "DateReceived",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "DateReceived"
  },
  {
   "name": "Pics_To_S",
   "type": "esriFieldTypeDate",
   "alias": "Pics_To_S",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Pics_To_S"
  },
  {
   "name": "Date_Delivered",
   "type": "esriFieldTypeDate",
   "alias": "Date_Delivered",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Date_Delivered"
  },
  {
   "name": "Sign_in_Scanned",
   "type": "esriFieldTypeString",
   "alias": "Sign_in_Scanned",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Sign_in_Scanned"
  },
  {
   "name": "Maps_Created",
   "type": "esriFieldTypeString",
   "alias": "Maps_Created",
   "domain": {
    "type": "codedValue",
    "name": "YesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Maps_Created"
  },
  {
   "name": "CONTACT_CELL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_CELL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CONTACT_CELL"
  },
  {
   "name": "Date_Resolved",
   "type": "esriFieldTypeDate",
   "alias": "Date_Resolved",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "Date_Resolved"
  },
  {
   "name": "Truck",
   "type": "esriFieldTypeString",
   "alias": "Truck#",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "Truck"
  },
  {
   "name": "ENG_FIRM",
   "type": "esriFieldTypeString",
   "alias": "ENG_FIRM",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ENG_FIRM"
  },
  {
   "name": "CONTACT_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_EMAIL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "CONTACT_EMAIL"
  },
  {
   "name": "CONTACT_US_MAIL",
   "type": "esriFieldTypeString",
   "alias": "CONTACT_US_MAIL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 200,
   "defaultValue": null,
   "modelName": "CONTACT_US_MAIL"
  },
  {
   "name": "CERT1",
   "type": "esriFieldTypeString",
   "alias": "CERT#1",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CERT1"
  },
  {
   "name": "CERT2",
   "type": "esriFieldTypeString",
   "alias": "CERT#2",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "CERT2"
  },
  {
   "name": "CPA_AMOUNT",
   "type": "esriFieldTypeDouble",
   "alias": "CPA Amount",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CPA_AMOUNT"
  },
  {
   "name": "RP_EMAIL",
   "type": "esriFieldTypeString",
   "alias": "RP_EMAIL",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "RP_EMAIL"
  }
 ],
 "indexes": [
  {
   "name": "R172_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G3254ORACLE_ID",
   "fields": "ORACLE_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "Work Order Activities",
   "description": "",
   "prototype": {
    "attributes": {
     "CPA_AMOUNT": null,
     "RP_EMAIL": null,
     "ORACLE_ID": null,
     "INCIDENT_ID": null,
     "TYPE": null,
     "DATE": null,
     "INITIALS": null,
     "NOTES": null,
     "REVIEW_INFO": null,
     "ENGINEER": null,
     "PE_NUMBER": null,
     "TIMESPENT": null,
     "RESOLVED": null,
     "RESOLVED_DATE": null,
     "RESPONSE_DUE_DATE": null,
     "DRAINS_MARKED": null,
     "FIELD_NOTES": null,
     "SOURCE": null,
     "QAQC": null,
     "ACTIVITY_ID": null,
     "CONTACT_NAME": null,
     "CONTACT_BUSINESS": null,
     "CONTACT_PHONE": null,
     "CONTACT_ADDRESS": null,
     "Number_Trained": null,
     "DateEntered": null,
     "DateReceived": null,
     "Pics_To_S": null,
     "Date_Delivered": null,
     "Sign_in_Scanned": null,
     "Maps_Created": null,
     "CONTACT_CELL": null,
     "Date_Resolved": null,
     "Truck": null,
     "ENG_FIRM": null,
     "CONTACT_EMAIL": null,
     "CONTACT_US_MAIL": null,
     "CERT1": null,
     "CERT2": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson",
 "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract",
 "useStandardizedQueries": true,
 "bigIntegerRestrictedTo53Bits": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "a67272d575bc452bbc960d45d79e7dd0"
}