Electric - Geometric Network

IMPORTANT: High-fidelity feeder data is important to a successful implementation.

Field Name	Applicable to Feature Class Type*	Field Data Type	Description
Designer Component ID	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 “Related DesignerComponent ID.”
Facility ID	All	Text	Used for identification.
Load Profile ID	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.
Normal Position	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.
Operating Voltage	Any Asset Type that acts as a source, sub-source, or sub-network controller	Short	Rated operating voltage of a device.
Phases	All Asset Types	Short	Phases.
Rated kVA	Voltage Regulator, Supply Transformer, Distribution Transformer, Step Transformer, Grounding Transformer, Generator Transformer, Three Winding Transformer	Double	The Rated kVA is used to calculate transformer loading.
Rated voltage (secondary)	Voltage Regulator, Supply Transformer, Distribution Transformer, Step Transformer, Grounding Transformer, Generator Transformer, Three Winding Transformer	Double	A coded value domain containing descriptive text describing all voltages available on the secondary winding of the transformer. Usually both the phase-to-phase voltage and phase-to-neutral voltages are included in the coded value description.
SubtypeBreaker	Breaker, Recloser	Short	Subtype of the switch.
WMS Code	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	RelatedDesignerComponentId	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called DesignerComponentId.
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	RelatedDesignerComponentId	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called DesignerComponentId.
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	RelatedDesignerComponentId	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called DesignerComponentId.
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	RelatedDesignerComponentId	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called DesignerComponentId.
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	RelatedDesignerComponentId	GUID	In the Schema.xml, this field is mapped to the related feature class’s field called DesignerComponentId.
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.