Smart Grid Applications Overview > Smart Operations Solution > SOS Configuration Overview > Network Adapter > Network Adapter for Multispeak > Network Adapter - MultiSpeak Data Model Worksheet |
Version: 10.1 |
Use this worksheet if your data model is based on the MultiSpeak data model, but with some customization.
Print out this worksheet and use it to map the MultiSpeak features/fields to the features and fields in your data model. Blank rows are provided specifically for this information and will be useful when creating your XSL style sheet and assigning model names.
*Some fields are not included in the MultiSpeak data model, but are required by DMS. Those are indicated with an asterisk (*) in the tables below. You may need to create these fields in your geodatabase.
CapacitorBank
MultiSpeak Table Name
Description
Custom Data Model Table Name
CapacitorBank
CapacitorBank represents a feature that neutralizes the effect of customer inductive loads, providing capacitive reactance to balance inductive reactance loss. One bank is associated with each phase; a three-phase circuit has three capacitor banks.
MultiSpeak Field Name
Description
Custom Data Model Field Name
BankKVAR
Code indicating CapacitorBank size in kVAR; domain values include 100 kVAR, 150 kVAR, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual transformer.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
CapacitorUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
CapacitorUnit
Capacitors store electrical energy and release it back into the power system when required to reduce voltage drops.
MultiSpeak Field Name
Description
Custom Data Model Field Name
KVAR
Code indicating CapacitorUnit size in kVAR; domain values may include 100 kVAR, 150 kVAR, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
ConductorInfo
MultiSpeak Table Name
Description
Custom Data Model Table Name
ConductorInfo
The conductors used in distribution are most often made of aluminum or copper. ConductorInfo stores information about material and other properties of the conductors that compose circuits. For a given current, a circuit’s resistance is the average rate at which electrical energy is converted to heat. This object class is associated with linear features but does not itself have a location on the map.
MultiSpeak Field Name
Description
Custom Data Model Field Name
CondSize
Code indicating size of a conductor; domain values may include 1/0, 1000, 2, 2/0, 250, 3/0, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
CondMatl
Code indicating material of conductor; domain values may include Copper, Aluminum, Steel, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
DynamicProtectiveDeviceBank
MultiSpeak Table Name
Description
Custom Data Model Table Name
DynamicProtectiveDeviceBank
In addition to opening when a fault is detected, dynamic protective device banks also reclose to attempt to reestablish service. If the fault remains after a prescribed number of reclosings, the device may lock open the circuit. Reclosing is designed to reduce or eliminate the effects of temporary faults. Other Dynamic Protective Devices include: Circuit Breaker, Recloser, Sectionalizer, Fault Interrupter.
MultiSpeak Field Name
Description
Custom Data Model Field Name
SubtypeCode
Code indicating the subtype of the device. 1=CircuitBreaker, 2=Recloser, 3=Sectionalizer
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual device.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
MaxContAmp
Code indicating maximum continuous current rating of device in amps, which is the amount of current that can flow through the device indefinitely; domain values may include 100 A, 200 A, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
POSA
Code indicating normal position of the device's A phase; domain values may include Closed, Open, and Not Applicable.
POSB
Code indicating normal position of the device's B phase; domain values may include Closed, Open, and Not Applicable.
POSC
Code indicating normal position of the device's C phase; domain values may include Closed, Open, and Not Applicable.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
ScadaMonitorID
ID of SCADA control.
Because this field is configured with a model name (SCADACONTROLID), it will never need to be transformed using a style sheet.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
DynamicProtectiveDeviceUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
DynamicProtectiveDeviceUnit
This table stores non-spatial data about DynamicProtectiveDeviceBank features.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
FuseBank
MultiSpeak Table Name
Description
Custom Data Model Table Name
FuseBank
Fuses are used to protect distribution devices from damaging currents. A fuse is an intentionally weakened spot in the electric circuit that opens the circuit at a predetermined current that is maintained for a predetermined amount of time. Fuses are not dynamic in that they remain open and do not reclose.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual fuse.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
POSA
Code indicating normal position of the Fuse's A phase; domain values may include Closed, Open, and Not Applicable.
POSB
Code indicating normal position of the Fuse's B phase; domain values may include Closed, Open, and Not Applicable.
POSC
Code indicating normal position of the Fuse's C phase; domain values may include Closed, Open, and Not Applicable.
FuseUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
FuseUnit
This table stores non-spatial data about fuses.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FuseType
Code indicating type of FuseUnit link, in terms of speed; domain values may include KLink, NLink, 200, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
LinkRtg
Size of FuseUnit link in amps; domain values may include 1 A, 10 A, 100 A, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
MiscNetFeature
MultiSpeak Table Name
Description
Custom Data Model Table Name
MiscNetFeature
MiscNetFeature captures those subtypes that protect distribution network equipment from temporary and permanent faults. Network Adapter only exports features with a subtype value of 5 (FaultIndicator). If you have FaultIndicator modeled as an individual feature class, enter it in the Custom Data Model Table Names field for MiscNetFeature.
MultiSpeak Field Name
MultiSpeak Field Name
Description
Custom Data Model Field Name
SubtypeCD
Code indicating the subtype of the MiscNetworkFeature. Network Adapter exports only features with a subtype of 5 (FaultIndicator).
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
PrimaryOHLineSection
MultiSpeak Table Name
Description
Custom Data Model Table Name
PrimaryOHLineSection
Overhead electric line segments carry electric current and are supported by structures including power poles, H-frames, and towers.
MultiSpeak Field Name
Description
Custom Data Model Field Name
NeutSize
Size of neutral wire; domain values may include 1/0 AWG, 1000 Concentric Neutral, etc.
NeutType
Material of neutral wire; domain values may include All, Aluminum Conductor, Copper, etc.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
OperVolt
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
PrimaryUGLineSection
MultiSpeak Table Name
Description
Custom Data Model Table Name
PrimaryUGLineSection
Primary URD cables are usually single-conductor, concentric-neutral insulated with polyethylene or cross-linked polyethylene.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
OperVolt
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
NeutType
Material of neutral wire; domain values may include All, Aluminum Conductor, Copper, etc.
NeutSize
Size of neutral wire; domain values may include 1/0 AWG, 1000 Concentric Neutral, etc.
RegulatorUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
RegulatorUnit
This table stores non-spatial data about voltage regulators.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
RatedKVA
kVA of RegulatorUnit at nominal voltage; domain values may include 10 kVA, 112 kVA, 333 kVA, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
ServiceLocation
MultiSpeak Table Name
Description
Custom Data Model Table Name
ServiceLocation
ServiceLocation is the point at which the distribution feeder terminates and energy is supplied to a customer. A service location can have one or many meters.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
*ConsumptionType
This field is not part of the MultiSpeak data model, but it is required by DMS. Indicates the type of energy consumption; domain values may include Residential.
Because this field is configured with a model name (MULTISPEAKEXTENSION), it will never need to be transformed using a style sheet.
Source
MultiSpeak Table Name
Description
Custom Data Model Table Name
Source
The Source table stores attributes that describe characteristics of the circuit measured or estimated at the breaker or recloser. These attributes include capacity, measured in kilowatts (kW); resistance, measured in ohms; and load, measured in reactive kilovolt-amperes (kVAR).
MultiSpeak Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
SubstationName
Name of the substation.
ConnectionConfiguration
Optional field. Code indicating configuration of conductors; domain values may include Delta, Wye, etc.
SwitchBank
MultiSpeak Table Name
Description
Custom Data Model Table Name
SwitchBank
SwitchBanks are used to disconnect circuits. SwitchBanks are installed at strategic locations throughout distribution feeder circuits to redirect power flows to balance loads or for sectionalizing to allow repair of damaged lines or equipment. SwitchBanks may act as tie devices, which are set in an open state and energized from two directions at once. SwitchBanks can be manually or power operated and can be operated individually or as a group. OpenPoint maps to SwitchBank. Be sure to include OpenPoints in your export to prevent a multitude of loops.
MultiSpeak Field Name
Description
Custom Data Model Field Name
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual switchbank.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
POSA
Code indicating normal position of the SwitchBank's A phase; domain values may include Closed, Open, and Not Applicable.
POSB
Code indicating normal position of the SwitchBank's B phase; domain values may include Closed, Open, and Not Applicable.
POSC
Code indicating normal position of the SwitchBank's C phase; domain values may include Closed, Open, and Not Applicable.
MaxContAmp
Code indicating maximum continuous current rating of Switch in amps; domain values may include 100 Amps, 200 Amps, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
ScadaMonitorID
ID of SCADA control.
Because this field is configured with a model name (SCADACONTROLID), it will never need to be transformed using a style sheet.
SwitchUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
SwitchUnit
This table stores non-spatial data about SwitchBanks.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
TransformerBank
MultiSpeak Table Name
Description
Custom Data Model Table Name
TransformerBank
The TransformerBank feature class captures information about distribution and power transformers. Subtypes may include Network, Single Phase Overhead, Single Phase Underground, Two Phase Overhead, Three Phase Overhead, Three Phase Underground, Step, and Power.
MultiSpeak Field Name
Description
Custom Data Model Field Name
WindingCode
This field contains a concatenation of the transformers's highside and lowside configuration.
PriProt
Code indicating type of overcurrent protection used at primary side of Transformer; domain values may include Breaker, Bayonet Fuse, Dry Well Canister, None, Oil Immersed, Weak Link.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual transformer.
*LowSideGroundResistance
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains the name of the ground resistance of secondary side in ohms.
*Owner
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains the name of the transformer's owner.
*Priority
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains a value for the priority of the transformer.
*ConsumptionType
This field is not part of the MultiSpeak data model, but it is required by DMS. Indicates the type of energy consumption; domain values may include Residential.
Because this field is configured with a model name (MULTISPEAKEXTENSION), it will never need to be transformed using a style sheet.
FeederID
Optional field. Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
SecVolt
The voltage on the secondary winding of the transformer.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.
TransformerUnit
MultiSpeak Table Name
Description
Custom Data Model Table Name
TransformerUnit
This table stores non-spatial data about transformers.
MultiSpeak Field Name
Description
Custom Data Model Field Name
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
RatedKVA
kVA of TransformerUnit at nominal voltage; domain values may include 10 kVA, 112 kVA, 333 kVA, etc.
This field is used to define the default EquipmentID value in case the EquipmentID field is not populated. If the EquipmentID field has a value, this field is not necessary.
EquipmentID
A unique ID used to identify equipment. Because the EquipmentID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
VoltageRegulator
MultiSpeak Table Name
Description
Custom Data Model Table Name
VoltageRegulator
This device compensates for voltage drop along electric lines.
MultiSpeak Field Name
Description
Custom Data Model Field Name
WindingCode
This field contains a concatenation of the voltage regulator's highside and lowside configuration.
PriProt
Code indicating type of overcurrent protection used at primary side of voltage regulator; domain values may include Breaker, Bayonet Fuse, Dry Well Canister, None, Oil Immersed, Weak Link.
PhasingCode
Code indicating phases present; domain values may include A, AB, AC, etc.
FacilityID
Optional field. Meaningful company-assigned unique identifier for each individual voltage regulator.
*LowSideGroundResistance
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains the name of the ground resistance of secondary side in ohms.
*Owner
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains the name of the transformer's owner.
*Priority
Supported, but not required. This field is not part of the MultiSpeak data model, but it is supported by DMS. It contains a value for the priority of the transformer.
*ConsumptionType
This field is not part of the MultiSpeak data model, but it is required by DMS. Indicates the type of energy consumption; domain values may include Residential.
FeederID
Optional field. Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
SecVolt
The voltage on the secondary winding of the voltage regulator.
OperatingVoltage
Optional field. Code indicating standard level at which system is currently being operated that may vary above or below nominal voltage; domain values may include 120 volts, 480 volts, etc.