Configuring Responder/Smart Grid
Network Adapter - Electric Distribution Data Model Worksheet

Version: 10.1

Resource Center Home

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.

 


Send Comment to documentation@schneider-electric.com