{
 "currentVersion": 10.81,
 "id": 9,
 "name": "DATA_ADMIN.CDOT_Fixtures",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "COMED_FILENAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "FIXTURE_ID",
   "type": "esriFieldTypeInteger",
   "alias": "fixture_id",
   "domain": null
  },
  {
   "name": "EFFECTIVE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "effective_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "CIRCUIT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "circuit_id",
   "domain": null
  },
  {
   "name": "BALLAST_LOSS",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ballast_loss",
   "domain": null
  },
  {
   "name": "INSTALL_DATE",
   "type": "esriFieldTypeDate",
   "alias": "install_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "END_DATE",
   "type": "esriFieldTypeDate",
   "alias": "end_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "REMOVE_DATE",
   "type": "esriFieldTypeDate",
   "alias": "remove_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "COMED_STATUSCD",
   "type": "esriFieldTypeString",
   "alias": "comed_statuscd",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "ComedStatusCodes",
    "description": "ComedStatusCodes",
    "codedValues": [
     {
      "name": "Ready for Review",
      "code": "Ready for Review"
     },
     {
      "name": "Reviewed",
      "code": "Reviewed"
     },
     {
      "name": "Submitted",
      "code": "Submitted"
     },
     {
      "name": "Held",
      "code": "Held"
     },
     {
      "name": "Accepted",
      "code": "Accepted"
     },
     {
      "name": "Rejected",
      "code": "Rejected"
     },
     {
      "name": "AutoAccepted",
      "code": "AutoAccepted"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "COMED_STATUSDATE",
   "type": "esriFieldTypeDate",
   "alias": "comed_statusdate",
   "length": 8,
   "domain": null
  },
  {
   "name": "COMED_REJECTREASON",
   "type": "esriFieldTypeString",
   "alias": "comed_rejectreason",
   "length": 400,
   "domain": null
  },
  {
   "name": "COMED_FILENAME",
   "type": "esriFieldTypeString",
   "alias": "comed_filename",
   "length": 30,
   "domain": null
  },
  {
   "name": "COMED_UPDATETYPE",
   "type": "esriFieldTypeString",
   "alias": "comed_updatetype",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "ComedUpdateTypes",
    "description": "ComedUpdateTypes",
    "codedValues": [
     {
      "name": "INS",
      "code": "INS"
     },
     {
      "name": "MNT",
      "code": "MNT"
     },
     {
      "name": "REM",
      "code": "REM"
     },
     {
      "name": "REF",
      "code": "REF"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CDOT_PROJECT_ID",
   "type": "esriFieldTypeInteger",
   "alias": "cdot_project_id",
   "domain": null
  },
  {
   "name": "PHOTOCELL_FLAG",
   "type": "esriFieldTypeSmallInteger",
   "alias": "photocell_flag",
   "domain": null
  },
  {
   "name": "RELATED_URL",
   "type": "esriFieldTypeString",
   "alias": "related_url",
   "length": 250,
   "domain": null
  },
  {
   "name": "REVIEWER_USERID",
   "type": "esriFieldTypeString",
   "alias": "reviewer_userid",
   "length": 10,
   "domain": null
  },
  {
   "name": "REVIEWER_COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "reviewer_comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "COMMENTS",
   "type": "esriFieldTypeString",
   "alias": "comments",
   "length": 50,
   "domain": null
  },
  {
   "name": "FIXTURE_CODE",
   "type": "esriFieldTypeInteger",
   "alias": "fixture_code",
   "domain": {
    "type": "codedValue",
    "name": "FixtureCodes",
    "description": "fixture_codes",
    "codedValues": [
     {
      "name": "aviation_13",
      "code": 0
     },
     {
      "name": "coach_50",
      "code": 1
     },
     {
      "name": "coach_60",
      "code": 2
     },
     {
      "name": "coach_90",
      "code": 3
     },
     {
      "name": "coach_100",
      "code": 4
     },
     {
      "name": "cobra_20",
      "code": 5
     },
     {
      "name": "cobra_90",
      "code": 6
     },
     {
      "name": "cobra_140",
      "code": 7
     },
     {
      "name": "cobra_150",
      "code": 8
     },
     {
      "name": "cobra_210",
      "code": 9
     },
     {
      "name": "cobra_250",
      "code": 10
     },
     {
      "name": "cobra_310",
      "code": 11
     },
     {
      "name": "cobra_315",
      "code": 12
     },
     {
      "name": "cobra_400",
      "code": 13
     },
     {
      "name": "cobra_1000",
      "code": 14
     },
     {
      "name": "flood_150",
      "code": 15
     },
     {
      "name": "flood_250",
      "code": 16
     },
     {
      "name": "flood_310",
      "code": 17
     },
     {
      "name": "flood_315",
      "code": 18
     },
     {
      "name": "flood_400",
      "code": 19
     },
     {
      "name": "ornamental_23",
      "code": 20
     },
     {
      "name": "ornamental_50",
      "code": 21
     },
     {
      "name": "ornamental_100",
      "code": 22
     },
     {
      "name": "ornamental_150",
      "code": 23
     },
     {
      "name": "ornamental_250",
      "code": 24
     },
     {
      "name": "ornamental_310",
      "code": 25
     },
     {
      "name": "ornamental_400",
      "code": 26
     },
     {
      "name": "viaduct_45",
      "code": 27
     },
     {
      "name": "viaduct_100",
      "code": 28
     },
     {
      "name": "ts_ryg_inc",
      "code": 29
     },
     {
      "name": "ts_red_led",
      "code": 30
     },
     {
      "name": "ts_yellow_led",
      "code": 31
     },
     {
      "name": "ts_green_led",
      "code": 32
     },
     {
      "name": "ts_inc_programmable",
      "code": 33
     },
     {
      "name": "ts_led_red_programmable",
      "code": 34
     },
     {
      "name": "ts_led_yellow_programmable",
      "code": 35
     },
     {
      "name": "ts_led_green_programmable",
      "code": 36
     },
     {
      "name": "ts_bike_red",
      "code": 37
     },
     {
      "name": "ts_bike_yellow",
      "code": 38
     },
     {
      "name": "ts_bike_green",
      "code": 39
     },
     {
      "name": "ts_ryg_inc_turn",
      "code": 40
     },
     {
      "name": "ts_ryg_led_turn",
      "code": 41
     },
     {
      "name": "ts_ryg_inc_programmable_turn",
      "code": 42
     },
     {
      "name": "ts_led_red_programmable_turn",
      "code": 43
     },
     {
      "name": "ts_led_yellow_programmable_turn",
      "code": 44
     },
     {
      "name": "ts_led_green_programmable_turn",
      "code": 45
     },
     {
      "name": "ts_pedestrian_inc",
      "code": 46
     },
     {
      "name": "ts_pedestrian_led",
      "code": 47
     },
     {
      "name": "ts_flashers_inc",
      "code": 48
     },
     {
      "name": "ts_flashers_led",
      "code": 49
     },
     {
      "name": "ts_flashers_inc_programmable",
      "code": 50
     },
     {
      "name": "ts_flashers_led_programmable",
      "code": 51
     },
     {
      "name": "ts_inc_sign",
      "code": 52
     },
     {
      "name": "ts_led_sign",
      "code": 53
     },
     {
      "name": "ts_fiber_sign",
      "code": 54
     },
     {
      "name": "ts_flourescent_sign",
      "code": 55
     },
     {
      "name": "ts_induction_sign",
      "code": 56
     },
     {
      "name": "ts_vdc",
      "code": 57
     },
     {
      "name": "ts_controllers",
      "code": 58
     },
     {
      "name": "cobra_145",
      "code": 59
     },
     {
      "name": "viaduct_led_70",
      "code": 60
     },
     {
      "name": "cobra_led_90",
      "code": 61
     },
     {
      "name": "coach_led_90",
      "code": 62
     },
     {
      "name": "cobra_led_100",
      "code": 63
     },
     {
      "name": "cobra_led_157",
      "code": 64
     },
     {
      "name": "cobra_led_189",
      "code": 65
     },
     {
      "name": "cobra_led_200",
      "code": 66
     },
     {
      "name": "cobra_led_400",
      "code": 67
     },
     {
      "name": "coach_led_100",
      "code": 68
     },
     {
      "name": "cobra_led_70",
      "code": 69
     },
     {
      "name": "cobra_led_310",
      "code": 70
     },
     {
      "name": "viaduct_140",
      "code": 71
     },
     {
      "name": "viaduct_150",
      "code": 72
     },
     {
      "name": "viaduct_led_77",
      "code": 73
     },
     {
      "name": "array_of_things_50",
      "code": 74
     },
     {
      "name": "cobra_led_125",
      "code": 75
     },
     {
      "name": "coach_led_28",
      "code": 76
     },
     {
      "name": "cobra_led_91",
      "code": 77
     },
     {
      "name": "viaduct_led_210_(400W_eqv)",
      "code": 78
     },
     {
      "name": "viaduct_led_60_(250W_eqv)",
      "code": 79
     },
     {
      "name": "flood_100",
      "code": 80
     },
     {
      "name": "cobra_led_67_(250W_eqv)",
      "code": 81
     },
     {
      "name": "coach_led_30_(50W_eqv)",
      "code": 82
     },
     {
      "name": "coach_led_60_(100W_eqv)",
      "code": 83
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "CBI_ID",
   "type": "esriFieldTypeInteger",
   "alias": "cbi_id",
   "domain": null
  },
  {
   "name": "PROCESSED",
   "type": "esriFieldTypeSmallInteger",
   "alias": "processed",
   "domain": null
  },
  {
   "name": "CREATED_USER",
   "type": "esriFieldTypeString",
   "alias": "CREATED_USER",
   "length": 255,
   "domain": null
  },
  {
   "name": "CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATED_DATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "LAST_EDITED_USER",
   "type": "esriFieldTypeString",
   "alias": "LAST_EDITED_USER",
   "length": 255,
   "domain": null
  },
  {
   "name": "LAST_EDITED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDITED_DATE",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "G7705CBI_ID",
   "fields": "CBI_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G7705CDOT_PROJEC",
   "fields": "CDOT_PROJECT_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G7705CIRCUIT_ID",
   "fields": "CIRCUIT_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R202_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": false,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}