StructureJunction (AddressPointData, RFUndergroundJunctionData, SupportStructureData, UndergroundStructureData)

DHFC object name: AddressPointData, RFUndergroundJunctionData, SupportStructureData, UndergroundStructureData

GIS design table name: StructureJunction

GIS built table name: StructureJunction

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
AerialStructureId	AerialStructureId	Guid				TRUE	Required	BiDirectional
CatalogId	CatalogId	Guid				TRUE	Required	BiDirectional
CommercialCount	Commercial Count	Integer				TRUE	Required	BiDirectional
CommercialMDUCount	Commercial MDU Count	Integer				TRUE	Required	BiDirectional
EsriId	OBJECTID	ObjectId				TRUE	Required	BiDirectional
Geometry	SHAPE	Geometry				TRUE	Required	BiDirectional
HouseNo	House Number	String		40		TRUE	Required	BiDirectional
IsInMdu	Is In Mdu	SmallInteger	EsriYesNoEnum			TRUE	Required	BiDirectional
NetworkId	NetworkId	Guid				TRUE	Required	BiDirectional
PoleType	PoleType	SmallInteger	PoleType			TRUE	Required	BiDirectional
ResidentialCount	Residential Count	Integer				TRUE	Required	BiDirectional
ResidentialMDUCount	Residential MDU Count	Integer				TRUE	Required	BiDirectional
RiserDistance	Riser Distance	Double		38	8	TRUE	Required	BiDirectional
StreetName	Street Name	String		100		TRUE	Required	BiDirectional
StructureType	Structure Type	String	StructureType	50		TRUE	Required	BiDirectional
SymbolRotation	Symbol Rotation	Double		38	8	TRUE	Required	BiDirectional
TapId	TapId	Guid				TRUE	Required	BiDirectional
TapId_D	TapId_D	Guid				TRUE	Required	BiDirectional
Type	Underground Junction Type	SmallInteger	UndergroundJunctionType			TRUE	Required	BiDirectional
UGStructureId	UGStructureId	Guid				TRUE	Required	BiDirectional
AmpId	Amp Id	String		3		TRUE	Optional	ToGisOnly
Cascade	Cascade	String		2		TRUE	Optional	ToGisOnly
CreationUser	Creation User	String		50		TRUE	Optional	BiDirectional
DateCreated	Date Created	Date				TRUE	Optional	BiDirectional
DateModified	Date Modified	Date				TRUE	Optional	BiDirectional
LastUser	Last User	String		50		TRUE	Optional	BiDirectional
Market	Market	String		255		TRUE	Optional	ToGisOnly
NetPath	Network Path	String		255		TRUE	Optional	ToGisOnly
NodeId	Node	String		50		TRUE	Optional	ToGisOnly
NodeLeg	Node Leg	String		2		TRUE	Optional	ToGisOnly
PowerSupplyId	Power Supply	String		255		TRUE	Optional	ToGisOnly
SpecSymbology	Spec Symbology	String		50		TRUE	Optional	ToGisOnly
Workflow_Status	Workflow Status	String	WorkflowState			TRUE	Optional	ToGisOnly

Relationships

Click the image to open it full size in a separate browser tab.

Address Point	Support Structure	Underground Structure