Structures Dataset for ArcGIS Pro - ArcFM Solution Documentation Portal

AddressPoint (AddressPointData)

DHFC object name: AddressPointData

GIS design table name: AddressPoint

GIS built table name: AddressPoint

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
AerialStructureId	AerialStructureId	Guid				FALSE	Required	BiDirectional
CommercialMDUCount	Commercial MDU Count	Integer				FALSE	Required	BiDirectional
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
HouseNo	House Number	String		40		TRUE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
ResidentialMDUCount	Residential MDU Count	Integer				FALSE	Required	BiDirectional
StreetName	Street Name	String		100		TRUE	Required	BiDirectional
SymbolRotation	Symbol Rotation	Double		38	8	FALSE	Required	BiDirectional
TapId	TapId	Guid				FALSE	Required	BiDirectional
TapId_D	TapId_D	Guid				FALSE	Required	BiDirectional
UGStructureId	UGStructureId	Guid				FALSE	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
Workflow_Status	Workflow Status	String	WorkflowState			TRUE	Optional	ToGisOnly

Relationships

None.

MduBoundary (MduBoundaryData)

DHFC object name: MduBoundaryData

GIS design table name: MduBoundary

GIS built table name: MduBoundary

GIS table type: FeatureClass

Geometry type: Polygon

Fields

Name	Alias	Type	Domain	Length	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId			FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry			FALSE	Required	BiDirectional
Name	Name	String		50	TRUE	Required	BiDirectional
NetworkId	NetworkId	Guid			FALSE	Required	BiDirectional
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
Workflow_Status	Workflow Status	String	WorkflowState		TRUE	Optional	ToGisOnly

Relationships

MduPathElement (MduPathElementData)

DHFC object name: MduPathElementData

GIS design table name: MduPathElement

GIS built table name: MduPathElement

GIS table type: FeatureClass

Geometry type: Path

Fields

Name	Alias	Type	Length	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId		FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry		FALSE	Required	BiDirectional
MduBoundaryId	MduBoundaryId	Guid		FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid		FALSE	Required	BiDirectional
Style	Style	String	500	TRUE	Required	BiDirectional
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

Relationships

None.

MduPolygonElement (MduPolygonElementData)

DHFC object name: MduPolygonElementData

GIS design table name: MduPolygonElement

GIS built table name: MduPolygonElement

GIS table type: FeatureClass

Geometry type: Polygon

Fields

Name	Alias	Type	Length	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId		FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry		FALSE	Required	BiDirectional
MduBoundaryId	MduBoundaryId	Guid		FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid		FALSE	Required	BiDirectional
Style	Style	String	500	TRUE	Required	BiDirectional
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

Relationships

None.

MduTextElement (MduTextElementData)

DHFC object name: MduTextElementData

GIS design table name: MduTextElement

GIS built table name: MduTextElement

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Length	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId		FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry		FALSE	Required	BiDirectional
MduBoundaryId	MduBoundaryId	Guid		FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid		FALSE	Required	BiDirectional
Style	Style	String	500	TRUE	Required	BiDirectional
Text	Text	String	1000	TRUE	Required	BiDirectional
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

Relationships

None.

OverheadSpan (OverheadSpanData)

DHFC object name: OverheadSpanData

GIS design table name: OverheadSpan

GIS built table name: OverheadSpan

GIS table type: FeatureClass

Geometry type: Path

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
IsInMdu	Is In MDU	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
Length	Length	Double		38	8	FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
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
Workflow_Status	Workflow Status	String	WorkflowState			TRUE	Optional	ToGisOnly

Relationships

None.

RFDrop (RFDropData)

DHFC object name: RFDropData

GIS design table name: RFDrop

GIS built table name: RFDrop

GIS table type: FeatureClass

Geometry type: Path

Fields

Name	Alias	Type	Domain	Length	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId			FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry			FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid			FALSE	Required	BiDirectional
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
OH_UG	Overhead/Underground	Integer	RfOverheadUnderground		TRUE	Optional	ToGisOnly
Workflow_Status	Workflow Status	String	WorkflowState		TRUE	Optional	ToGisOnly

Relationships

None.

RFUndergroundJunction (RFUndergroundJunctionData)

DHFC object name: RFUndergroundJunctionData

GIS design table name: RFUndergroundJunction

GIS built table name: RFUndergroundJunction

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
IsInMdu	Is In Mdu	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
SymbolRotation	Symbol Rotation	Double		38	8	FALSE	Required	BiDirectional
Type	Underground Junction Type	SmallInteger	UndergroundJunctionType			FALSE	Required	BiDirectional
Workflow_Status	Workflow Status	String	WorkflowState			FALSE	Required	BiDirectional
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

Relationships

None.

SupportStructure (SupportStructureData)

DHFC object name: SupportStructureData

GIS design table name: SupportStructure

GIS built table name: SupportStructure

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
CommercialCount	Commercial Count	Integer				FALSE	Required	BiDirectional
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
IsInMdu	Is In Mdu	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
PoleType	PoleType	SmallInteger	PoleType			FALSE	Required	BiDirectional
ResidentialCount	Residential Count	Integer				FALSE	Required	BiDirectional
RiserDistance	Riser Distance	Double		38	8	TRUE	Required	BiDirectional
SymbolRotation	Symbol Rotation	Double		38	8	FALSE	Required	BiDirectional
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
Workflow_Status	Workflow Status	String	WorkflowState			TRUE	Optional	ToGisOnly

Relationships

None.

UndergroundSpan (UndergroundSpanData)

DHFC object name: UndergroundSpanData

GIS design table name: UndergroundSpan

GIS built table name: UndergroundSpan

GIS table type: FeatureClass

Geometry type: Path

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
ContainsDuct	Contains Duct	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
IsInMdu	Is In Mdu	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
Length	Length	Double		38	8	FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
Workflow_Status	Workflow Status	String	WorkflowState			FALSE	Required	BiDirectional
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
NumberOfDucts	Number of Ducts	Integer				TRUE	Optional	ToGisOnly

Relationships

None.

UndergroundStructure (UndergroundStructureData)

DHFC object name: UndergroundStructureData

GIS design table name: UndergroundStructure

GIS built table name: UndergroundStructure

GIS table type: FeatureClass

Geometry type: Point

Fields

Name	Alias	Type	Domain	Length	Precision	Nullable	Field Role	Data Transfer
CatalogId	CatalogId	Guid				FALSE	Required	BiDirectional
CommercialCount	Commercial Count	Integer				FALSE	Required	BiDirectional
EsriId	OBJECTID	ObjectId				FALSE	Required	BiDirectional
Geometry	SHAPE	Geometry				FALSE	Required	BiDirectional
IsInMdu	Is In Mdu	SmallInteger	EsriYesNoEnum			FALSE	Required	BiDirectional
NetworkId	NetworkId	Guid				FALSE	Required	BiDirectional
ResidentialCount	Residential Count	Integer				FALSE	Required	BiDirectional
StructureType	Structure Type	String	StructureType	50		TRUE	Required	BiDirectional
SymbolRotation	Symbol Rotation	Double		38	8	FALSE	Required	BiDirectional
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
SpecSymbology	Spec Symbology	String		50		TRUE	Optional	ToGisOnly
Workflow_Status	Workflow Status	String	WorkflowState			TRUE	Optional	ToGisOnly

Relationships