Smart Grid Applications Overview > Smart Operations Solution > SOS Configuration Overview > Network Adapter > Network Adapter for Multispeak > Network Adapter - Electric Distribution Data Model Worksheet |
Version: 10.1 |
Use this worksheet if your data model is based on the Electric Distribution data model, but with some customization.
Print out this worksheet and use it to map the Electric Distribution 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 Electric Distribution 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.
BreakerUnit
The Electric Distribution data model does not have a BreakerUnit table. Non-spatial data for breakers is stored in the CircuitSource table.
BusBar
Electric Distribution Table Name
Description
Custom Data Model Table Name
Busbar
BusBar is a large rigid conductor that connects devices in switching facilities to feed power to two or more circuits.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
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.
NeutralMaterial
Optional field. Material of neutral wire; domain values may include All, Aluminum Conductor, Copper, etc.
NeutralSize
Optional field. Size of neutral wire; domain values may include 1/0 AWG, 1000 Concentric Neutral, etc.
Capacitor
See PFCorrectingEquipment.
CapacitorUnit
Electric Distribution 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.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
CircuitSource
Electric Distribution Table Name
Description
Custom Data Model Table Name
CircuitSource
A circuit (feeder) is the aggregate of the conductors and equipment downstream of a substation breaker or recloser. CircuitSource 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).
Electric Distribution Field Name
Description
Custom Data Model Field Name
ID
Unique identifier of feeder initiated at this source. This may map to a FeederID field.
SubstationID
Substation identifier.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
ConductorInfo
Electric Distribution 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.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
ConductorMaterial
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
ConductorSize
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
DynamicProtectiveDevice
Electric Distribution Table Name
Description
Custom Data Model Table Name
DynamicProtectiveDevice
In addition to opening when a fault is detected, dynamic protective devices 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. Dynamic Protective Device subtypes: Circuit Breaker, Recloser, Sectionalizer, Fault Interrupter. You may find these subtypes modeled as individual classes in a custom data model.
Electric Distribution Field Name
Description
Custom Data Model Field Name
SubtypeCD
Code indicating the subtype of the device.
Note: This field is necessary only if you have a corresponding feature that uses subtypes in your geodatabase. If you do not use a subtype field, then all unit tables must be separate (e.g., BreakerUnit, SectionalizerUnit) rather than a single CircuitSource table.
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
MaxContinuousCurrent
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
NormalPosition_A
Code indicating normal position of the device's A phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_B
Code indicating normal position of the device's B phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_C
Code indicating normal position of the device's C phase; domain values may include Closed, Open, and Not Applicable.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
ScadaControlID
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.
Fuse
Electric Distribution Table Name
Description
Custom Data Model Table Name
Fuse
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.
Electric Distribution Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
NormalPosition_A
Code indicating normal position of the Fuse's A phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_B
Code indicating normal position of the Fuse's B phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_C
Code indicating normal position of the Fuse's C phase; domain values may include Closed, Open, and Not Applicable.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
FuseUnit
Electric Distribution Table Name
Description
Custom Data Model Table Name
FuseUnit
This table stores non-spatial data about fuses.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
LinkType
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
LinkRating
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
MiscNetworkFeature
Electric Distribution Table Name
Description
Custom Data Model Table Name
MiscNetworkFeature
MiscNetworkFeature captures those subtypes that protect distribution network equipment from temporary and permanent faults. Network Adapter only exports features with a subtype value of 2 (FaultIndicator). If you have FaultIndicator modeled as an individual feature class, enter it in the Custom Data Model Table Name field for MiscNetworkFeature.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
SubtypeCD
Code indicating the subtype of the MiscNetworkFeature. Network Adapter exports only features with a subtype of 2 (FaultIndicator).
*Direction
Direction (upstream/downstream) in which the MiscNetworkFeature is detecting faults. The Direction field is used by DMS and may need to be created in your geodatabase.
Because this field is configured with a model name (FAULTINDICATORDIRECTION), it will never need to be transformed using a style sheet.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
PFCorrectingEquipment
Electric Distribution Table Name
Description
Custom Data Model Table Name
PFCorrectingEquipment
Power distribution is more efficient if operated when the power factor (PF) is unity. PFCorrectingEquipment such as capacitors help maintain the power factor at unity by providing a static source of leading reactive current and can be installed close to the load. Subtypes may include: CapacitorBank, SeriesCapacitor, ShuntReactor. If you have any of these "subtypes" modeled as individual features, enter them in the Maps To field for PFCorrectingEquipment.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
TotalKVAR
Total reactive power of bank in kVAR.
This field is used to define the default EquipmentID value in case the CatalogID field is not populated. If the CatalogID 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.
PriOHElectricLineSegment
Electric Distribution Table Name
Description
Custom Data Model Table Name
PriOHElectricLineSegment
Overhead electric line segments carry electric current and are supported by structures including power poles, H-frames, and towers.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
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.
NeutralMaterial
Material of neutral wire; domain values may include All, Aluminum Conductor, Copper, etc.
NeutralSize
Size of neutral wire; domain values may include 1/0 AWG, 1000 Concentric Neutral, etc.
PriUGElectricLineSegment
Electric Distribution Table Name
Description
Custom Data Model Table Name
PriUGElectricLineSegment
Primary URD cables are usually single-conductor, concentric-neutral insulated with polyethylene or cross-linked polyethylene. You may find voltage levels (High, Medium, Low) modeled as individual classes in a custom data model.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
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.
NeutralMaterial
Material of neutral wire; domain values may include All, Aluminum Conductor, Copper, etc.
NeutralSize
Size of neutral wire; domain values may include 1/0 AWG, 1000 Concentric Neutral, etc.
RecloserUnit
Electric Distribution Table Name
Description
Custom Data Model Table Name
RecloserUnit
This table stores non-spatial data about reclosers.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
RegulatorUnit
Electric Distribution Table Name
Description
Custom Data Model Table Name
RegulatorUnit
This table stores non-spatial data about voltage regulators.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
SectionalizerUnit
Electric Distribution Table Name
Description
Custom Data Model Table Name
SectionalizerUnit
This table stores non-spatial data about sectionalizers.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
ServicePoint
Electric Distribution Table Name
Description
Custom Data Model Table Name
ServicePoint
ServicePoint is the point at which the distribution feeder terminates and energy is supplied to a customer. A service point can have one or many meters.
Electric Distribution Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
*ConsumptionType
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.
Switch
Electric Distribution Table Name
Description
Custom Data Model Table Name
Switch
Switches are used to disconnect circuits. Switches 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. Switches may act as tie devices, which are set in an open state and energized from two directions at once. Switches can be manually or power operated and can be operated individually or as a group. OpenPoint maps to Switch. Be sure to include OpenPoints in your export to prevent a multitude of loops.
Electric Distribution Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
MaxContinuousCurrent
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
NormalPosition_A
Code indicating normal position of the Switch's A phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_B
Code indicating normal position of the Switch's B phase; domain values may include Closed, Open, and Not Applicable.
NormalPosition_C
Code indicating normal position of the Switch's C phase; domain values may include Closed, Open, and Not Applicable.
ScadaControlID
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
Electric Distribution Table Name
Description
Custom Data Model Table Name
SwitchUnit
This table stores non-spatial data about switches.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
Transformer
Electric Distribution Table Name
Description
Custom Data Model Table Name
Transformer
Transformer 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.
Electric Distribution Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
OperatingVoltage
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.
HighSideProtection
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.
Because this field is configured with a model name (MULTISPEAKEXTENSION), it will never need to be transformed using a style sheet.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
HighSideConfiguration
Configuration of primary side of Transformer; domain values may include SinglePhaseLine-Ground, Open, SinglePhaseLine-Line, Wye.
Because this field is configured with a model name (HIGHSIDECONFIGURATION), it will never need to be transformed using a style sheet.
LowSideConfiguration
Configuration of secondary side of Transformer; domain values may include 3 Wire Delta, 4 Wire Delta, Delta, Single Phase, Wye.
Because this field is configured with a model name (LOWSIDECONFIGURATION), it will never need to be transformed using a style sheet.
LowSideVoltage
The voltage on the secondary winding of the transformer.
*Owner
Supported, but not required. This field is not part of the Electric Distribution 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 Electric Distribution data model, but it is supported by DMS. It contains a value for the priority of the transformer.
*LowSideGroundResistence
Supported, but not required. This field is not part of the Electric Distribution data model, but it is supported by DMS. It contains the value of the ground resistence of secondary side in ohms.
*ConsumptionType
This field is not part of the Electric Distribution data model, but it is required by DMS. Indicates the type of energy consumption; domain values may include Residential.
TransformerUnit
Electric Distribution Table Name
Description
Custom Data Model Table Name
TransformerUnit
This table stores non-spatial data about transformers.
Electric Distribution Field Name
Description
Custom Data Model Field Name
PhaseDesignation
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 CatalogID field is not populated. If the CatalogID field has a value, this field is not necessary.
*CatalogID
This field is not part of the Electric Distribution data model, but it is required by DMS. The CatalogID field is a unique ID used by DMS to identify equipment.
Because the CatalogID field is configured with a model name (MULTISPEAKEQUIPMENT), it will never need to be transformed using a style sheet.
VoltageRegulator
Electric Distribution Table Name
Description
Custom Data Model Table Name
VoltageRegulator
This device compensates for voltage drop along electric lines.
Electric Distribution Field Name
Description
Custom Data Model Field Name
FeederID
Feeder Manager identifier assigned to feeders and devices that participate in a specific distribution circuit.
OperatingVoltage
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.
HighSideProtection
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.
Because this field is configured with a model name (MULTISPEAKEXTENSION), it will never need to be transformed using a style sheet.
PhaseDesignation
Code indicating phases present; domain values may include A, AB, AC, etc.
HighSideConfiguration
Configuration of primary side of Transformer; domain values may include SinglePhaseLine-Ground, Open, SinglePhaseLine-Line, Wye.
Because this field is configured with a model name (HIGHSIDECONFIGURATION), it will never need to be transformed using a style sheet.
LowSideConfiguration
Configuration of secondary side of Transformer; domain values may include 3 Wire Delta, 4 Wire Delta, Delta, Single Phase, Wye.
Because this field is configured with a model name (LOWSIDECONFIGURATION), it will never need to be transformed using a style sheet.
LowSideVoltage
The voltage on the secondary winding of the transformer.
*Owner
Supported, but not required. This field is not part of the Electric Distribution 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 Electric Distribution data model, but it is supported by DMS. It contains a value for the priority of the transformer.
*LowSideGroundResistence
Supported, but not required. This field is not part of the Electric Distribution data model, but it is supported by DMS. It contains the value of the ground resistence of secondary side in ohms.
*ConsumptionType
This field is not part of the Electric Distribution data model, but it is required by DMS. Indicates the type of energy consumption; domain values may include Residential.