{ "currentVersion": 10.91, "id": 247, "name": "T_Switch", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAMEPLATEPHOTONUMBER", "typeIdField": "SUBTYPECD", "subtypeFieldName": "SUBTYPECD", "subtypeField": "SUBTYPECD", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "CreationUser", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "LastUser", "length": 20, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null }, { "name": "INSTALLATIONDATE", "type": "esriFieldTypeDate", "alias": "InstallationDate", "length": 8, "domain": null }, { "name": "ENERGIZATIONDATE", "type": "esriFieldTypeDate", "alias": "EnergizationDate", "length": 8, "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "SUBSTATIONID", "type": "esriFieldTypeString", "alias": "SubstationID", "length": 50, "domain": { "type": "codedValue", "name": "Substation Names", "description": "SubstationID Field", "codedValues": [ { "name": "MH69S-3", "code": "3S" }, { "name": "MH69S-5", "code": "5S" }, { "name": "Redcliff-MH13R-4R", "code": "4R" }, { "name": "Trans Canada Hwy-MH13R-3R", "code": "3R" }, { "name": "MHS-2", "code": "2S" }, { "name": "MHS-6", "code": "6S" }, { "name": "MHS-8", "code": "8S" }, { "name": "MHS-7", "code": "7S" }, { "name": "MHS-9", "code": "9S" }, { "name": "MH13N-1", "code": "1N" }, { "name": "MHS-10", "code": "10S" }, { "name": "MHS-11", "code": "11S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SUBTYPECD", "type": "esriFieldTypeInteger", "alias": "SubtypeCD", "domain": null }, { "name": "COMPATIBLEUNITID", "type": "esriFieldTypeString", "alias": "CompatibleUnitID", "length": 50, "domain": null }, { "name": "DEVICENUMBER", "type": "esriFieldTypeString", "alias": "DeviceNumber", "length": 25, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": { "type": "codedValue", "name": "Switch Manufacturer", "description": "SwitchUnit, T_InstrumentTransformer and T_Switch Tables", "codedValues": [ { "name": "ABB", "code": "ABB" }, { "name": "Cooper Power Systems", "code": "CPR" }, { "name": "General Electric", "code": "GE" }, { "name": "S and C", "code": "S&C" }, { "name": "Seimens", "code": "SEM" }, { "name": "Southern Engineering", "code": "SE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Souther States", "code": "SS" }, { "name": "Schneider Electric", "code": "Schneider E" }, { "name": "Eaton", "code": "Eaton" }, { "name": "Kearney", "code": "K" }, { "name": "Federal Pacific", "code": "FP" }, { "name": "Shallbetter", "code": "SB" }, { "name": "PASCOR", "code": "P" }, { "name": "I-T-E Industries Ltd.", "code": "ITE" }, { "name": "Westinghouse", "code": "WH" }, { "name": "SQUARE D", "code": "SD" }, { "name": "Federal Pioneer", "code": "FedPi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MANUFACTUREDATE", "type": "esriFieldTypeDate", "alias": "ManufacturerDate", "length": 8, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": { "type": "codedValue", "name": "T_Switch Model", "description": "Switch Model for Tranmsiison", "codedValues": [ { "name": "EV-2", "code": "1" }, { "name": "314086-01", "code": "10" }, { "name": "TTR-8", "code": "11" }, { "name": "GFE-18843", "code": "12" }, { "name": "314-084-01", "code": "13" }, { "name": "314-210-00", "code": "14" }, { "name": "ATC-300", "code": "15" }, { "name": "VBSA", "code": "16" }, { "name": "314697-00", "code": "17" }, { "name": "FD2050", "code": "18" }, { "name": "ED3225", "code": "19" }, { "name": "MTHXLDA40600BSC", "code": "2" }, { "name": "DTK", "code": "20" }, { "name": "CDP-7", "code": "21" }, { "name": "HPL-C", "code": "22" }, { "name": "CFB", "code": "23" }, { "name": "ED3150", "code": "24" }, { "name": "PRL1A", "code": "25" }, { "name": "NEB", "code": "26" }, { "name": "164653", "code": "27" }, { "name": "ATH3LDA40600BSC", "code": "3" }, { "name": "Pow-R-Line 1a", "code": "4" }, { "name": "Pow-R-Line 2a", "code": "5" }, { "name": "Pow-R-Line 3a", "code": "6" }, { "name": "Type 46007-488-57", "code": "7" }, { "name": "20280141", "code": "8" }, { "name": "314697-01", "code": "9" }, { "name": "DST2", "code": "28" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SERIALNUMBER", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 50, "domain": null }, { "name": "NOMINALVOLTAGE", "type": "esriFieldTypeInteger", "alias": "NominalVoltage", "domain": { "type": "codedValue", "name": "Master Voltage Code", "description": "CMH voltges", "codedValues": [ { "name": "120V", "code": 10 }, { "name": "120/208V", "code": 20 }, { "name": "120/240V", "code": 22 }, { "name": "208V", "code": 25 }, { "name": "240V/480V", "code": 40 }, { "name": "240V", "code": 45 }, { "name": "277/480V", "code": 50 }, { "name": "347V", "code": 55 }, { "name": "347/600V", "code": 60 }, { "name": "480V", "code": 65 }, { "name": "600V", "code": 70 }, { "name": "8kV", "code": 190 }, { "name": "13.8/7.9kV", "code": 240 }, { "name": "13.8kV", "code": 250 }, { "name": "13.8kV Delta", "code": 260 }, { "name": "13.8kV Grounded Y", "code": 270 }, { "name": "15kV", "code": 300 }, { "name": "69kV", "code": 440 }, { "name": "138kV", "code": 1237 }, { "name": "0kV", "code": 1267 }, { "name": "145kV", "code": 1450 }, { "name": "80.5kV", "code": 1451 }, { "name": "12kV", "code": 1452 }, { "name": "125V DC", "code": 1453 }, { "name": "225V", "code": 1454 }, { "name": "72.5kV", "code": 1455 }, { "name": "150kV", "code": 1456 }, { "name": "40.25kV", "code": 1457 }, { "name": "72kV", "code": 1458 }, { "name": "76kV", "code": 1459 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OPERATINGVOLTAGE", "type": "esriFieldTypeInteger", "alias": "OperatingVoltage", "domain": { "type": "codedValue", "name": "Master Voltage Code", "description": "CMH voltges", "codedValues": [ { "name": "120V", "code": 10 }, { "name": "120/208V", "code": 20 }, { "name": "120/240V", "code": 22 }, { "name": "208V", "code": 25 }, { "name": "240V/480V", "code": 40 }, { "name": "240V", "code": 45 }, { "name": "277/480V", "code": 50 }, { "name": "347V", "code": 55 }, { "name": "347/600V", "code": 60 }, { "name": "480V", "code": 65 }, { "name": "600V", "code": 70 }, { "name": "8kV", "code": 190 }, { "name": "13.8/7.9kV", "code": 240 }, { "name": "13.8kV", "code": 250 }, { "name": "13.8kV Delta", "code": 260 }, { "name": "13.8kV Grounded Y", "code": 270 }, { "name": "15kV", "code": 300 }, { "name": "69kV", "code": 440 }, { "name": "138kV", "code": 1237 }, { "name": "0kV", "code": 1267 }, { "name": "145kV", "code": 1450 }, { "name": "80.5kV", "code": 1451 }, { "name": "12kV", "code": 1452 }, { "name": "125V DC", "code": 1453 }, { "name": "225V", "code": 1454 }, { "name": "72.5kV", "code": 1455 }, { "name": "150kV", "code": 1456 }, { "name": "40.25kV", "code": 1457 }, { "name": "72kV", "code": 1458 }, { "name": "76kV", "code": 1459 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PHASEDESIGNATION", "type": "esriFieldTypeInteger", "alias": "PhaseDesignation", "domain": { "type": "codedValue", "name": "Phase Designation", "description": "PhaseDesignation Field", "codedValues": [ { "name": "R", "code": 4 }, { "name": "Y", "code": 2 }, { "name": "B", "code": 1 }, { "name": "RY", "code": 6 }, { "name": "RB", "code": 5 }, { "name": "YB", "code": 3 }, { "name": "RYB", "code": 7 }, { "name": "UNKNOWN", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BILRATING", "type": "esriFieldTypeInteger", "alias": "BILRating", "domain": { "type": "codedValue", "name": "BIL Rating", "description": "Multiple FC and Tables", "codedValues": [ { "name": "95 BIL", "code": 95 }, { "name": "110 BIL", "code": 110 }, { "name": "125 BIL", "code": 125 }, { "name": "150 BIL", "code": 150 }, { "name": "200 BIL", "code": 200 }, { "name": "250 BIL", "code": 250 }, { "name": "350 BIL", "code": 350 }, { "name": "650 BIL", "code": 650 }, { "name": "18 BIL", "code": 18 }, { "name": "65 BIL", "code": 65 }, { "name": "30 BIL", "code": 30 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONTACTTYPE", "type": "esriFieldTypeString", "alias": "ContactType", "length": 50, "domain": null }, { "name": "GANGOPERATEDINDICATOR", "type": "esriFieldTypeString", "alias": "GangOperatedIndicator", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator Numeric", "description": "Used Everywhere (text:0,1)", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MANUALLYOPERATEDINDICATOR", "type": "esriFieldTypeString", "alias": "ManuallyOperatedIndicator", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator Numeric", "description": "Used Everywhere (text:0,1)", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAXCONTINUOUSCURRENT_A", "type": "esriFieldTypeDouble", "alias": "MaxContinuousCurrent (Amp)", "domain": { "type": "codedValue", "name": "Switch Max Continuous Current", "description": "T_Switch Table", "codedValues": [ { "name": "50 Amps", "code": 50 }, { "name": "100 Amps", "code": 100 }, { "name": "200 Amps", "code": 200 }, { "name": "400 Amps", "code": 400 }, { "name": "600 Amps", "code": 600 }, { "name": "800 Amps", "code": 800 }, { "name": "900 Amps", "code": 900 }, { "name": "1200 Amps", "code": 1200 }, { "name": "2000 Amps", "code": 2000 }, { "name": "225 Amps", "code": 225 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAXINTERRUPTINGCURRENT_KA", "type": "esriFieldTypeInteger", "alias": "MaxContinuousCurrent (KA)", "domain": { "type": "codedValue", "name": "Switch Max Interrupting Current", "description": "T_Switch and SwitchUnit Tables", "codedValues": [ { "name": "50 Amps", "code": 50 }, { "name": "60 Amps", "code": 60 }, { "name": "200 Amps", "code": 200 }, { "name": "600 Amps", "code": 600 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "MAXOPERATINGVOLTAGE", "type": "esriFieldTypeString", "alias": "MaxOperatingVoltage", "length": 50, "domain": null }, { "name": "NORMALPOSITION", "type": "esriFieldTypeInteger", "alias": "NormalPosition", "domain": { "type": "codedValue", "name": "Normal Position", "description": "T_ Tables", "codedValues": [ { "name": "Closed", "code": 0 }, { "name": "Open", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESENTPOSITION", "type": "esriFieldTypeInteger", "alias": "PresentPosition", "domain": { "type": "codedValue", "name": "Present Position", "description": "T_Relay and T_Switch Table", "codedValues": [ { "name": "Closed", "code": 0 }, { "name": "Open", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SCADAINDICATION", "type": "esriFieldTypeString", "alias": "SCADAIndication", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator Numeric", "description": "Used Everywhere (text:0,1)", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STYLE", "type": "esriFieldTypeString", "alias": "Style", "length": 50, "domain": { "type": "codedValue", "name": "T_Switch Style", "description": "How it breaks", "codedValues": [ { "name": "Vertical Break", "code": "VB" }, { "name": "Horizontal Break", "code": "HB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TAGGEDOUT", "type": "esriFieldTypeString", "alias": "TaggedOut", "length": 50, "domain": { "type": "codedValue", "name": "Yes No Indicator Numeric", "description": "Used Everywhere (text:0,1)", "codedValues": [ { "name": "No", "code": "0" }, { "name": "Yes", "code": "1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FUSEMANUFACTURER", "type": "esriFieldTypeString", "alias": "FuseManufacturer", "length": 50, "domain": { "type": "codedValue", "name": "Fuse Manufacturer", "description": "FuseUnit and T_ Tables", "codedValues": [ { "name": "ABB/Westinghouse", "code": "ABB" }, { "name": "Cooper", "code": "CPR" }, { "name": "S & C", "code": "S&C" }, { "name": "Southern States", "code": "SS" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FUSEMODEL", "type": "esriFieldTypeString", "alias": "FuseModel", "length": 50, "domain": null }, { "name": "FUSERATING", "type": "esriFieldTypeString", "alias": "FuseRating", "length": 50, "domain": null }, { "name": "FUSESIZE", "type": "esriFieldTypeString", "alias": "FuseSize", "length": 50, "domain": { "type": "codedValue", "name": "Fuse Link Material", "description": "Fuse Size", "codedValues": [ { "name": "Fuse - 100amp Type K", "code": "343" }, { "name": "Fuse - 10amp Type K", "code": "334" }, { "name": "Fuse - 125amp Type E", "code": "350" }, { "name": "Fuse - 12amp Type K", "code": "458" }, { "name": "Fuse - 150amp Type E", "code": "949" }, { "name": "Fuse - 15amp Type K", "code": "335" }, { "name": "Fuse - 200amp Type E", "code": "950" }, { "name": "Fuse - 200amp Type K", "code": "344" }, { "name": "Fuse - 20amp Type K", "code": "336" }, { "name": "Fuse - 25amp Type E", "code": "346" }, { "name": "Fuse - 25amp Type K", "code": "337" }, { "name": "Fuse - 30amp Type K", "code": "338" }, { "name": "Fuse - 40amp Type K", "code": "339" }, { "name": "Fuse - 50amp Type E", "code": "347" }, { "name": "Fuse - 50amp Type K", "code": "340" }, { "name": "Fuse - 5amp Type E", "code": "345" }, { "name": "Fuse - 65amp Type E", "code": "348" }, { "name": "Fuse - 65amp Type K", "code": "341" }, { "name": "Fuse - 6amp Type K", "code": "332" }, { "name": "Fuse - 80amp Type E", "code": "349" }, { "name": "Fuse - 80amp Type K", "code": "342" }, { "name": "Fuse - 8amp Type K", "code": "333" }, { "name": "Fuse - 100amp Type E", "code": "1215" }, { "name": "Fuse - 20amp Type E", "code": "351" }, { "name": "Fuse - 3amp Type K", "code": "1396" }, { "name": "Fuse - 1amp Type K", "code": "1423" }, { "name": "Fuse - 2amp Type K", "code": "1424" }, { "name": "Fuse - 10amp Type E", "code": "1425" }, { "name": "Fuse - 15amp Type E", "code": "1457" }, { "name": "Fuse - 30amp Type E", "code": "1458" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CITYWORKSPROJECT", "type": "esriFieldTypeInteger", "alias": "Cityworks Project?", "domain": { "type": "codedValue", "name": "Yes No Numeric Indicator", "description": "Used Everywhere (Int:0,1)", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VOLTAGERATING", "type": "esriFieldTypeString", "alias": "Voltage Rating", "length": 50, "domain": null }, { "name": "TSYSTEMSASSETID", "type": "esriFieldTypeString", "alias": "TSYSTEMSASSETID", "length": 50, "domain": { "type": "codedValue", "name": "T_Systems AssetID", "description": "The join between T_Systems and the T_* tables", "codedValues": [ { "name": "MH13N-1 - AC", "code": "TSYST184553" }, { "name": "MH13N-1 - Communication", "code": "TSYST184554" }, { "name": "MH13N-1 - DC", "code": "TSYST184555" }, { "name": "MH13N-1 - HV Bus", "code": "TSYST184556" }, { "name": "MH13N-1 - MV Bus", "code": "TSYST184557" }, { "name": "MH13N-1 - Relays", "code": "TSYST184558" }, { "name": "MH13N-1 - Site", "code": "TSYST184559" }, { "name": "MH13N-1 - Transformers", "code": "TSYST184560" }, { "name": "MHS-2 - AC", "code": "TSYST184561" }, { "name": "MHS-2 - Communication", "code": "TSYST184562" }, { "name": "MHS-2 - DC", "code": "TSYST184563" }, { "name": "MHS-2 - HV Bus", "code": "TSYST184564" }, { "name": "MHS-2 - MV Bus", "code": "TSYST184565" }, { "name": "MHS-2 - Relays", "code": "TSYST184566" }, { "name": "MHS-2 - Site", "code": "TSYST184567" }, { "name": "MHS-2 - Transformers", "code": "TSYST184568" }, { "name": "MH69S-3 - AC", "code": "TSYST184569" }, { "name": "MH69S-3 - Communication", "code": "TSYST184570" }, { "name": "MH69S-3 - DC", "code": "TSYST184571" }, { "name": "MH69S-3 - HV Bus", "code": "TSYST184572" }, { "name": "MH69S-3 - MV Bus", "code": "TSYST184573" }, { "name": "MH69S-3 - Relays", "code": "TSYST184574" }, { "name": "MH69S-3 - Site", "code": "TSYST184575" }, { "name": "MH69S-3 - Transformers", "code": "TSYST184576" }, { "name": "MH69S-5 - AC", "code": "TSYST184577" }, { "name": "MH69S-5 - Communication", "code": "TSYST184578" }, { "name": "MH69S-5 - DC", "code": "TSYST184579" }, { "name": "MH69S-5 - HV Bus", "code": "TSYST184580" }, { "name": "MH69S-5 - MV Bus", "code": "TSYST184581" }, { "name": "MH69S-5 - Relays", "code": "TSYST184582" }, { "name": "MH69S-5 - Site", "code": "TSYST184583" }, { "name": "MH69S-5 - Transformers", "code": "TSYST184584" }, { "name": "MHS-6 - AC", "code": "TSYST184585" }, { "name": "MHS-6 - Communication", "code": "TSYST184586" }, { "name": "MHS-6 - DC", "code": "TSYST184587" }, { "name": "MHS-6 - HV Bus", "code": "TSYST184588" }, { "name": "MHS-6 - MV Bus", "code": "TSYST184589" }, { "name": "MHS-6 - Relays", "code": "TSYST184590" }, { "name": "MHS-6 - Site", "code": "TSYST184591" }, { "name": "MHS-6 - Transformers", "code": "TSYST184592" }, { "name": "MHS-7 - AC", "code": "TSYST184593" }, { "name": "MHS-7 - Communication", "code": "TSYST184594" }, { "name": "MHS-7 - DC", "code": "TSYST184595" }, { "name": "MHS-7 - HV Bus", "code": "TSYST184596" }, { "name": "MHS-7 - MV Bus", "code": "TSYST184597" }, { "name": "MHS-7 - Relays", "code": "TSYST184598" }, { "name": "MHS-7 - Site", "code": "TSYST184599" }, { "name": "MHS-7 - Transformers", "code": "TSYST184600" }, { "name": "MHS-8 - AC", "code": "TSYST184601" }, { "name": "MHS-8 - Communication", "code": "TSYST184602" }, { "name": "MHS-8 - DC", "code": "TSYST184603" }, { "name": "MHS-8 - HV Bus", "code": "TSYST184604" }, { "name": "MHS-8 - MV Bus", "code": "TSYST184605" }, { "name": "MHS-8 - Relays", "code": "TSYST184606" }, { "name": "MHS-8 - Site", "code": "TSYST184607" }, { "name": "MHS-8 - Transformers", "code": "TSYST184608" }, { "name": "MHS-9 - AC", "code": "TSYST184609" }, { "name": "MHS-9 - Communication", "code": "TSYST184610" }, { "name": "MHS-9 - DC", "code": "TSYST184611" }, { "name": "MHS-9 - HV Bus", "code": "TSYST184612" }, { "name": "MHS-9 - MV Bus", "code": "TSYST184613" }, { "name": "MHS-9 - Relays", "code": "TSYST184614" }, { "name": "MHS-9 - Site", "code": "TSYST184615" }, { "name": "MHS-9 - Transformers", "code": "TSYST184616" }, { "name": "MHS-10 - AC", "code": "TSYST184617" }, { "name": "MHS-10 - Communication", "code": "TSYST184618" }, { "name": "MHS-10 - DC", "code": "TSYST184619" }, { "name": "MHS-10 - HV Bus", "code": "TSYST184620" }, { "name": "MHS-10 - MV Bus", "code": "TSYST184621" }, { "name": "MHS-10 - Relays", "code": "TSYST184622" }, { "name": "MHS-10 - Site", "code": "TSYST184623" }, { "name": "MHS-10 - Transformers", "code": "TSYST184624" }, { "name": "MHS-11 - Communications", "code": "TSYST195505" }, { "name": "MHS-11 - Site", "code": "TSYST195506" }, { "name": "MHS-11 - HV Bus", "code": "TSYST195507" }, { "name": "MHS-11 - MV Bus", "code": "TSYST195508" }, { "name": "MHS-11 - Transformers", "code": "TSYST195509" }, { "name": "MHS-11 - Relays", "code": "TSYST195510" }, { "name": "MHS-11 - AC", "code": "TSYST195511" }, { "name": "MHS-11 - DC", "code": "TSYST195512" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NAMEPLATEPHOTONUMBER", "type": "esriFieldTypeString", "alias": "Name Plate Photo Number", "length": 50, "domain": null } ], "indexes": [ { "name": "G1147SUBSTATIONI", "fields": "SUBSTATIONID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1147TSYSTEMSASS", "fields": "TSYSTEMSASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R522_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": {}, "id": 1, "name": "Limited Load Break" }, { "domains": {}, "id": 2, "name": "No Load Break" }, { "domains": {}, "id": 3, "name": "Rated Load Break" }, { "domains": {}, "id": 4, "name": "Blade" }, { "domains": {}, "id": 5, "name": "Shunt" } ], "subtypes": [ { "domains": {}, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "INSTALLATIONDATE": null, "ENERGIZATIONDATE": null, "ASSETID": null, "SUBSTATIONID": null, "SUBTYPECD": null, "COMPATIBLEUNITID": null, "DEVICENUMBER": null, "COMMENTS": null, "MANUFACTURER": null, "MANUFACTUREDATE": null, "MODEL": null, "SERIALNUMBER": null, "NOMINALVOLTAGE": null, "OPERATINGVOLTAGE": null, "PHASEDESIGNATION": null, "BILRATING": null, "CONTACTTYPE": null, "GANGOPERATEDINDICATOR": null, "MANUALLYOPERATEDINDICATOR": null, "MAXCONTINUOUSCURRENT_A": null, "MAXINTERRUPTINGCURRENT_KA": null, "MAXOPERATINGVOLTAGE": null, "NORMALPOSITION": null, "PRESENTPOSITION": null, "SCADAINDICATION": null, "STYLE": null, "TAGGEDOUT": null, "FUSEMANUFACTURER": null, "FUSEMODEL": null, "FUSERATING": null, "FUSESIZE": null, "CITYWORKSPROJECT": null, "VOLTAGERATING": null, "TSYSTEMSASSETID": null, "NAMEPLATEPHOTONUMBER": null }, "code": 1, "name": "Limited Load Break" }, { "domains": {}, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "INSTALLATIONDATE": null, "ENERGIZATIONDATE": null, "ASSETID": null, "SUBSTATIONID": null, "SUBTYPECD": null, "COMPATIBLEUNITID": null, "DEVICENUMBER": null, "COMMENTS": null, "MANUFACTURER": null, "MANUFACTUREDATE": null, "MODEL": null, "SERIALNUMBER": null, "NOMINALVOLTAGE": null, "OPERATINGVOLTAGE": null, "PHASEDESIGNATION": null, "BILRATING": null, "CONTACTTYPE": null, "GANGOPERATEDINDICATOR": null, "MANUALLYOPERATEDINDICATOR": null, "MAXCONTINUOUSCURRENT_A": null, "MAXINTERRUPTINGCURRENT_KA": null, "MAXOPERATINGVOLTAGE": null, "NORMALPOSITION": null, "PRESENTPOSITION": null, "SCADAINDICATION": null, "STYLE": null, "TAGGEDOUT": null, "FUSEMANUFACTURER": null, "FUSEMODEL": null, "FUSERATING": null, "FUSESIZE": null, "CITYWORKSPROJECT": null, "VOLTAGERATING": null, "TSYSTEMSASSETID": null, "NAMEPLATEPHOTONUMBER": null }, "code": 2, "name": "No Load Break" }, { "domains": {}, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "INSTALLATIONDATE": null, "ENERGIZATIONDATE": null, "ASSETID": null, "SUBSTATIONID": null, "SUBTYPECD": null, "COMPATIBLEUNITID": null, "DEVICENUMBER": null, "COMMENTS": null, "MANUFACTURER": null, "MANUFACTUREDATE": null, "MODEL": null, "SERIALNUMBER": null, "NOMINALVOLTAGE": null, "OPERATINGVOLTAGE": null, "PHASEDESIGNATION": null, "BILRATING": null, "CONTACTTYPE": null, "GANGOPERATEDINDICATOR": null, "MANUALLYOPERATEDINDICATOR": null, "MAXCONTINUOUSCURRENT_A": null, "MAXINTERRUPTINGCURRENT_KA": null, "MAXOPERATINGVOLTAGE": null, "NORMALPOSITION": null, "PRESENTPOSITION": null, "SCADAINDICATION": null, "STYLE": null, "TAGGEDOUT": null, "FUSEMANUFACTURER": null, "FUSEMODEL": null, "FUSERATING": null, "FUSESIZE": null, "CITYWORKSPROJECT": null, "VOLTAGERATING": null, "TSYSTEMSASSETID": null, "NAMEPLATEPHOTONUMBER": null }, "code": 3, "name": "Rated Load Break" }, { "domains": {}, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "INSTALLATIONDATE": null, "ENERGIZATIONDATE": null, "ASSETID": null, "SUBSTATIONID": null, "SUBTYPECD": null, "COMPATIBLEUNITID": null, "DEVICENUMBER": null, "COMMENTS": null, "MANUFACTURER": null, "MANUFACTUREDATE": null, "MODEL": null, "SERIALNUMBER": null, "NOMINALVOLTAGE": null, "OPERATINGVOLTAGE": null, "PHASEDESIGNATION": null, "BILRATING": null, "CONTACTTYPE": null, "GANGOPERATEDINDICATOR": null, "MANUALLYOPERATEDINDICATOR": null, "MAXCONTINUOUSCURRENT_A": null, "MAXINTERRUPTINGCURRENT_KA": null, "MAXOPERATINGVOLTAGE": null, "NORMALPOSITION": null, "PRESENTPOSITION": null, "SCADAINDICATION": null, "STYLE": null, "TAGGEDOUT": null, "FUSEMANUFACTURER": null, "FUSEMODEL": null, "FUSERATING": null, "FUSESIZE": null, "CITYWORKSPROJECT": null, "VOLTAGERATING": null, "TSYSTEMSASSETID": null, "NAMEPLATEPHOTONUMBER": null }, "code": 4, "name": "Blade" }, { "domains": {}, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "INSTALLATIONDATE": null, "ENERGIZATIONDATE": null, "ASSETID": null, "SUBSTATIONID": null, "SUBTYPECD": null, "COMPATIBLEUNITID": null, "DEVICENUMBER": null, "COMMENTS": null, "MANUFACTURER": null, "MANUFACTUREDATE": null, "MODEL": null, "SERIALNUMBER": null, "NOMINALVOLTAGE": null, "OPERATINGVOLTAGE": null, "PHASEDESIGNATION": null, "BILRATING": null, "CONTACTTYPE": null, "GANGOPERATEDINDICATOR": null, "MANUALLYOPERATEDINDICATOR": null, "MAXCONTINUOUSCURRENT_A": null, "MAXINTERRUPTINGCURRENT_KA": null, "MAXOPERATINGVOLTAGE": null, "NORMALPOSITION": null, "PRESENTPOSITION": null, "SCADAINDICATION": null, "STYLE": null, "TAGGEDOUT": null, "FUSEMANUFACTURER": null, "FUSEMODEL": null, "FUSERATING": null, "FUSESIZE": null, "CITYWORKSPROJECT": null, "VOLTAGERATING": null, "TSYSTEMSASSETID": null, "NAMEPLATEPHOTONUMBER": null }, "code": 5, "name": "Shunt" } ], "relationships": [ { "id": 47, "name": "T_Systems", "relatedTableId": 245, "role": "esriRelRoleDestination", "keyField": "TSYSTEMSASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }