Electric - Geometric Network

IMPORTANT: High-fidelity feeder data is important to a successful implementation. If you have used a different data model, then your Esri/GIS field names might differ. That’s OK. Read the Description column to properly map the Designer XI field to the Esri field. Designer XI is not looking for a specific Esri field name, but rather the Esri field that stores the same data as the Designer XI field.

Designer Field Name	Esri/GIS Field Name	Applicable to Feature Class Type*	Field Data Type	Description
DesignerComponentID	GlobalID	Any feature classes that have a related object table such as Conductor, Fuse, Recloser, Switch, and Transformer	GUID	This field is used for relating unit records to banks. In the Schema.xml, this field is mapped to the related table’s field called “RelatedFeatureNDID.”
FacilityID	FacilityID	All	Text	Used for identification.
SpecID	LOADPROFILEID	Service Point	GUID	Used by the Load Profile filter when placing electric service points in the application; this is not a spec for the service point, but it is a spec for the load. Alternatively, instead of using a GUID, you could really use any kind of field (text, domain, integer, etc.) to inform the feature-to-spec-mapping rules. It depends on your implementation, but the important note is this field is required, but its type is flexible given your company’s rules.
NormalPosition_[phase]	NORMALPOSITION_[phase]	Switchable devices such as Breaker, Recloser, Fuse, Clamp, Jumper, Load Break Switch, Sectionalizer, Elbow, Disconnector, Rack	Short	Normal status (open or closed) of a switchable device. Normal position is mapper per phase. Append an underscore and phase letter for each applicable phase (e.g., NormalPosition_A).
OperatingVoltage	OPERATINGVOLTAGE	Any Asset Type that acts as a source, sub-source, or sub-network controller	Short	Rated operating voltage of a device. A coded value domain containing descriptive text describing all voltages available. Usually both the phase-to-phase voltage and phase-to-neutral voltages are included in the coded value description.
Phases	PHASEDESIGNATION	All Asset Types	Short	Phases.
RatedkVA	RATEDKVA	Voltage Regulator, Supply Transformer, Distribution Transformer, Step Transformer, Grounding Transformer, Generator Transformer, Three Winding Transformer	Double	The Rated kVA is used to calculate transfer loading.
HighsideVoltage	HIGHSIDERATEDVOLTAGE	Supply Transformer, Distribution Transformer, Step Transformer, Grounding Transformer, Generator Transformer, Three Winding Transformer	Short	A coded value domain containing descriptive text describing all voltages available. Usually both the phase-to-phase voltage and phase-to-neutral voltages are included in the coded value description.
LowsideVoltage	LOWSIDERATEDVOLTAGE	Supply Transformer, Distribution Transformer, Step Transformer, Grounding Transformer, Generator Transformer, Three Winding Transformer	Short	A coded value domain containing descriptive text describing all voltages available. Usually both the phase-to-phase voltage and phase-to-neutral voltages are included in the coded value description.
SubtypeBreaker	SUBTYPECD	Breaker, Recloser	Short	Subtype of the switch.
WMSCode	WMSCode	All	Text	This field stores the code generated by the integrated WMS; this code is used during removals, as it is the reference for the application to know what specs were installed initially.

*Some of these feature classes do not currently have a component in Designer XI. In these cases, those feature classes are mapped to electric network components. An electric network component is a generic feature against which a specific feature CU can be assigned. Electric network components are akin to a “catch all” for electric features that do not have a designated Designer XI component.

Object Tables

IMPORTANT: These object tables must include a field to store the foreign key of its parent feature class (this should have already been established when the relationship was created). The field that stores the foreign key is later used in the Schema so the application knows where to look when gathering attributes for dynamic spec assignment, or “specs on the fly.”

Object Table	Field Name	Type	Description
Conductor Info	RelatedFeatureNDID	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called RelatedFeatureNDID.
Conductor Info	RelatedBankGlobalId	GUID	This is the field referenced in the Important note above. It is a field to store the foreign key of the parent feature class.
Fuse Unit	RelatedFeatureNDID	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called RelatedFeatureNDID.
Fuse Unit	RelatedBankGlobalId	GUID	This is the field referenced in the Important note above. It is a field to store the foreign key of the parent feature class.
Recloser Unit	RelatedFeatureNDID	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called RelatedFeatureNDID.
Recloser Unit	RelatedBankGlobalId	GUID	This is the field referenced in the Important note above. It is a field to store the foreign key of the parent feature class.
Switch Unit	RelatedFeatureNDID	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called RelatedFeatureNDID.
Switch Unit	RelatedBankGlobalId	GUID	This is the field referenced in the Important note above. It is a field to store the foreign key of the parent feature class.
Transformer Unit	RelatedFeatureNDID	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called RelatedFeatureNDID.
Transformer Unit	RelatedBankGlobalId	GUID	This is the field referenced in the Important note above. It is a field to store the foreign key of the parent feature class.