{
 "currentVersion": 10.71,
 "cimVersion": "2.4.0",
 "id": 28,
 "name": "TilmData",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 37,
   "name": "TilmHistory",
   "relatedTableId": 40,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleOrigin",
   "keyField": "TilmID",
   "composite": false
  },
  {
   "id": 38,
   "name": "WSketchLink",
   "relatedTableId": 32,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleOrigin",
   "keyField": "AssetID",
   "composite": false
  },
  {
   "id": 9,
   "name": "Transformer",
   "relatedTableId": 3,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "AssetID",
   "composite": false
  },
  {
   "id": 36,
   "name": "SubTransformer",
   "relatedTableId": 23,
   "cardinality": "esriRelCardinalityOneToOne",
   "role": "esriRelRoleDestination",
   "keyField": "AssetID",
   "composite": false
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "TilmID",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "TilmID",
   "type": "esriFieldTypeString",
   "alias": "TilmID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 16,
   "defaultValue": null,
   "modelName": "TilmID"
  },
  {
   "name": "PurchaseDate",
   "type": "esriFieldTypeDate",
   "alias": "PurchaseDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "purchase_date"
  },
  {
   "name": "POrder",
   "type": "esriFieldTypeString",
   "alias": "POrder",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "POrder"
  },
  {
   "name": "PurchaseCost",
   "type": "esriFieldTypeDouble",
   "alias": "PurchaseCost",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "purchase_cost"
  },
  {
   "name": "TotalCost",
   "type": "esriFieldTypeDouble",
   "alias": "TotalCost",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "total_cost"
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrMfg",
    "description": "Xfmr manufacturer",
    "codedValues": [
     {
      "name": "ABB",
      "code": "ABB"
     },
     {
      "name": "Allis Chalmers",
      "code": "AC"
     },
     {
      "name": "Arkansas Electric",
      "code": "AE"
     },
     {
      "name": "B&B",
      "code": "BB"
     },
     {
      "name": "BS",
      "code": "BS"
     },
     {
      "name": "CG Power",
      "code": "CG Power"
     },
     {
      "name": "A.B. Chance",
      "code": "CH"
     },
     {
      "name": "Central Moloney",
      "code": "CM"
     },
     {
      "name": "Cortran",
      "code": "CO"
     },
     {
      "name": "Cooper",
      "code": "COOP"
     },
     {
      "name": "Central Transformer Co.",
      "code": "CT"
     },
     {
      "name": "Delta Star",
      "code": "DS"
     },
     {
      "name": "ELST",
      "code": "ELST"
     },
     {
      "name": "ERMCO",
      "code": "ER"
     },
     {
      "name": "ESCO",
      "code": "ESCO"
     },
     {
      "name": "Federal Electric",
      "code": "FD"
     },
     {
      "name": "Federal Pacific",
      "code": "FP"
     },
     {
      "name": "Gardner",
      "code": "GA"
     },
     {
      "name": "General Electric",
      "code": "GE"
     },
     {
      "name": "Harrison Transformer",
      "code": "HA"
     },
     {
      "name": "Howard Industries",
      "code": "HI"
     },
     {
      "name": "Hill",
      "code": "HILL"
     },
     {
      "name": "Jerry's Electric",
      "code": "JE"
     },
     {
      "name": "Kuhlman",
      "code": "KU"
     },
     {
      "name": "Line Material",
      "code": "LM"
     },
     {
      "name": "McGraw Edison",
      "code": "ME"
     },
     {
      "name": "Moloney",
      "code": "MO"
     },
     {
      "name": "MagneTek",
      "code": "MT"
     },
     {
      "name": "Neco",
      "code": "NE"
     },
     {
      "name": "NW Transformer",
      "code": "NW"
     },
     {
      "name": "Pennsylvania",
      "code": "PA"
     },
     {
      "name": "H.K. Porter",
      "code": "PO"
     },
     {
      "name": "Power Partners Inc",
      "code": "PPI"
     },
     {
      "name": "Pittsburgh",
      "code": "PT"
     },
     {
      "name": "Pullman",
      "code": "PULL"
     },
     {
      "name": "Pauwels",
      "code": "PWLS"
     },
     {
      "name": "RTE Corp.",
      "code": "RTE"
     },
     {
      "name": "Rural",
      "code": "RU"
     },
     {
      "name": "Siemens Allis",
      "code": "SA"
     },
     {
      "name": "SBD",
      "code": "SBD"
     },
     {
      "name": "Sunlight",
      "code": "SLT"
     },
     {
      "name": "Spokane Transformer",
      "code": "SPOK"
     },
     {
      "name": "Square D",
      "code": "SQ"
     },
     {
      "name": "Standard",
      "code": "ST"
     },
     {
      "name": "T&R",
      "code": "T&R"
     },
     {
      "name": "UG",
      "code": "UG"
     },
     {
      "name": "Virginia Transformer",
      "code": "VTC"
     },
     {
      "name": "Wagner",
      "code": "WA"
     },
     {
      "name": "Waukesha",
      "code": "Wak"
     },
     {
      "name": "WCO",
      "code": "WCO"
     },
     {
      "name": "Westinghouse",
      "code": "WH"
     },
     {
      "name": "WEG",
      "code": "WEG"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 16,
   "defaultValue": null,
   "modelName": "manufact_code"
  },
  {
   "name": "Model",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "Model"
  },
  {
   "name": "SerialNo",
   "type": "esriFieldTypeString",
   "alias": "SerialNo",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "serial_number"
  },
  {
   "name": "StockNo",
   "type": "esriFieldTypeString",
   "alias": "StockNo",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 16,
   "defaultValue": null,
   "modelName": "stock_number"
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrStatus",
    "description": "Xfmr status",
    "codedValues": [
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Disposed",
      "code": "Disposed"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Reuilding",
      "code": "Rebuilding"
     },
     {
      "name": "Sold",
      "code": "Sold"
     },
     {
      "name": "Flagged",
      "code": "Flagged"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 32,
   "defaultValue": null,
   "modelName": "Status"
  },
  {
   "name": "StatusLocate",
   "type": "esriFieldTypeString",
   "alias": "StatusLocate",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrStatusLoc",
    "description": "Xfmr status location",
    "codedValues": [
     {
      "name": "Field",
      "code": "Field"
     },
     {
      "name": "Offsite",
      "code": "Offsite"
     },
     {
      "name": "Truck",
      "code": "Truck"
     },
     {
      "name": "Warehouse",
      "code": "Warehouse"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 16,
   "defaultValue": null,
   "modelName": "StatusLocate"
  },
  {
   "name": "InstallDate",
   "type": "esriFieldTypeDate",
   "alias": "InstallDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "InstallDate"
  },
  {
   "name": "RetireDate",
   "type": "esriFieldTypeDate",
   "alias": "RetireDate",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "RetireDate"
  },
  {
   "name": "Type",
   "type": "esriFieldTypeString",
   "alias": "Type",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrType",
    "description": "Xfmr type",
    "codedValues": [
     {
      "name": "Transformer",
      "code": "Transformer"
     },
     {
      "name": "TransformerBank",
      "code": "TransformerBank"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 32,
   "defaultValue": "Transformer",
   "modelName": "Type_code"
  },
  {
   "name": "SubType",
   "type": "esriFieldTypeString",
   "alias": "SubType",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrSubType",
    "description": "Xfmr subtype",
    "codedValues": [
     {
      "name": "AutoXfmr",
      "code": "AutoXfmr"
     },
     {
      "name": "Transformer",
      "code": "Transformer"
     },
     {
      "name": "TransformerCSP",
      "code": "TransformerCSP"
     },
     {
      "name": "TransformerSP",
      "code": "TransformerSP"
     },
     {
      "name": "Xfmr2Bushing",
      "code": "Xfmr2Bushing"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 32,
   "defaultValue": "Transformer",
   "modelName": "SubType"
  },
  {
   "name": "Class",
   "type": "esriFieldTypeString",
   "alias": "Class",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrClass",
    "description": "Xfmr class",
    "codedValues": [
     {
      "name": "Direct Buried Xfmr",
      "code": "Direct Buried Xfmr"
     },
     {
      "name": "Network Xfmr",
      "code": "Network Xfmr"
     },
     {
      "name": "OH Line Xfmr",
      "code": "OH Line Xfmr"
     },
     {
      "name": "Pad Mount Xfmr",
      "code": "Pad Mount Xfmr"
     },
     {
      "name": "Step Up Xfmr",
      "code": "Street Light Xfmr"
     },
     {
      "name": "Step Up Xfmr",
      "code": "Step Up Xfmr"
     },
     {
      "name": "Substation Xfmr",
      "code": "Substation Xfmr"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     },
     {
      "name": "Voltage Regulator",
      "code": "Voltage Regulator"
     },
     {
      "name": "Submersible Xfmr",
      "code": "Submersible Xfmr"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 32,
   "defaultValue": null,
   "modelName": "class_code"
  },
  {
   "name": "KVA",
   "type": "esriFieldTypeDouble",
   "alias": "Kva",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "kva_size"
  },
  {
   "name": "HighSide",
   "type": "esriFieldTypeDouble",
   "alias": "HighSideKv",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "high_side_1"
  },
  {
   "name": "LowSide",
   "type": "esriFieldTypeString",
   "alias": "LowSideV",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrLsVolt",
    "description": "Xfmr Low side voltage",
    "codedValues": [
     {
      "name": "120",
      "code": "120"
     },
     {
      "name": "120/140",
      "code": "120/140"
     },
     {
      "name": "120/208",
      "code": "120/208"
     },
     {
      "name": "120/208Y",
      "code": "120/208Y"
     },
     {
      "name": "120/240",
      "code": "120/240"
     },
     {
      "name": "120PM/208Y",
      "code": "120PM/208Y"
     },
     {
      "name": "12470",
      "code": "12470"
     },
     {
      "name": "12470Y/7200",
      "code": "12470Y/7200"
     },
     {
      "name": "13800",
      "code": "13800"
     },
     {
      "name": "220/440",
      "code": "220/440"
     },
     {
      "name": "240",
      "code": "240"
     },
     {
      "name": "240/480",
      "code": "240/480"
     },
     {
      "name": "277",
      "code": "277"
     },
     {
      "name": "277/480",
      "code": "277/480"
     },
     {
      "name": "277/480Y",
      "code": "277/480Y"
     },
     {
      "name": "4160",
      "code": "4160"
     },
     {
      "name": "480",
      "code": "480"
     },
     {
      "name": "480Y/277PM",
      "code": "480Y/277PM"
     },
     {
      "name": "7.62Kv",
      "code": "7.62Kv"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "low_side_1"
  },
  {
   "name": "Impedance",
   "type": "esriFieldTypeDouble",
   "alias": "Impedance",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "impedance"
  },
  {
   "name": "ConnectCode",
   "type": "esriFieldTypeString",
   "alias": "Connect",
   "domain": {
    "type": "codedValue",
    "name": "ElecXfmrConnect",
    "description": "Xfmr connection",
    "codedValues": [
     {
      "name": "Unknown",
      "code": "0"
     },
     {
      "name": "1 Phase",
      "code": "1"
     },
     {
      "name": "3 Phase Wye-Delta 3 wire",
      "code": "2"
     },
     {
      "name": "1 & 3 Phase Grd Wye-Delta 4 wire",
      "code": "3"
     },
     {
      "name": "3 Phase Wye-Delta 4 wire",
      "code": "4"
     },
     {
      "name": "3 Phase Open Wye-Delta 3 wire",
      "code": "5"
     },
     {
      "name": "1 & 3 Phase Open Wye-Delta 3 wire",
      "code": "6"
     },
     {
      "name": "3 Phase Delta-Delta 3 wire",
      "code": "7"
     },
     {
      "name": "1 & 3 Phase Delta-Delta 4 wire",
      "code": "8"
     },
     {
      "name": "3 Phase Delta-Wye 4 wire",
      "code": "9"
     },
     {
      "name": "3 Phase Open Delta-Delta 3 wire",
      "code": "10"
     },
     {
      "name": "1 & 3 Phase Open Delta-Delta 4 wire",
      "code": "11"
     },
     {
      "name": "Scott T ( 3 phase to 2 phase )",
      "code": "12"
     },
     {
      "name": "Primary Meter",
      "code": "13"
     },
     {
      "name": "1 & 3 Phase Floated Wye-Delta 4 wire",
      "code": "14"
     },
     {
      "name": "3 Phase Grd Wye Wye 4 wire",
      "code": "15"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "ConnectCode"
  },
  {
   "name": "Customers",
   "type": "esriFieldTypeDouble",
   "alias": "Customers",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "total_customers"
  },
  {
   "name": "LifeSupport",
   "type": "esriFieldTypeString",
   "alias": "LifeSupport",
   "domain": {
    "type": "codedValue",
    "name": "ElecYesNo_2",
    "description": "Yes No",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "LifeSupport"
  },
  {
   "name": "WorkSketch",
   "type": "esriFieldTypeString",
   "alias": "WOrder",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "work_order"
  },
  {
   "name": "LocateID",
   "type": "esriFieldTypeString",
   "alias": "LocateID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "structure_id"
  },
  {
   "name": "Situs",
   "type": "esriFieldTypeString",
   "alias": "Situs",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 120,
   "defaultValue": null,
   "modelName": "Situs"
  },
  {
   "name": "remarks",
   "type": "esriFieldTypeString",
   "alias": "Remarks",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "remarks"
  },
  {
   "name": "Hyperlink",
   "type": "esriFieldTypeString",
   "alias": "Hyperlink",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 252,
   "defaultValue": null,
   "modelName": "Hyperlink"
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "AssetID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 20,
   "defaultValue": null,
   "modelName": "AssetID"
  },
  {
   "name": "BankID",
   "type": "esriFieldTypeString",
   "alias": "BankID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "BankID"
  }
 ],
 "indexes": [
  {
   "name": "R828_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G2314TilmID",
   "fields": "TilmID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "GDB_2314_AssetID",
   "fields": "AssetID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "TilmData",
   "description": "",
   "prototype": {
    "attributes": {
     "AssetID": null,
     "BankID": null,
     "TilmID": null,
     "PurchaseDate": null,
     "POrder": null,
     "PurchaseCost": null,
     "TotalCost": null,
     "Manufacturer": null,
     "Model": null,
     "SerialNo": null,
     "StockNo": null,
     "Status": null,
     "StatusLocate": null,
     "InstallDate": null,
     "RetireDate": null,
     "Type": "Transformer",
     "SubType": "Transformer",
     "Class": null,
     "KVA": null,
     "HighSide": null,
     "LowSide": null,
     "Impedance": null,
     "ConnectCode": null,
     "Customers": null,
     "LifeSupport": null,
     "WorkSketch": null,
     "LocateID": null,
     "Situs": null,
     "remarks": null,
     "Hyperlink": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 2000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "capabilities": "Query,Create,Update,Uploads,Editing",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 2000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1
}