Create Tables

This topic outlines the tables {object classes} that should exist in your geodatabase in order to utilize WDM functionality.

After creating these tables, GlobalIDs must be added to them. Right-click each table and select Manage > Add Global IDs.
These tables must be versioned for an SDE database. See the Esri documentation for more information about versioning tables.
These tables must also be converted to ArcFM objects.

F_ACTIVEDEVICE

Field	Data Type	Default Value	Domain	Length
ActiveDeviceType	Text		Fiber Active Device Type	10
Comments	Text			255
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			255
DateModified Alias: Date Modified	Date
Description	Text			100
DeviceConfiguration	Text		Fiber Splitter Type	10
DeviceHeight Alias: Height	Double	1
DeviceName Alias: Name	Text			255
DevicePosition Alias: Position	Long Integer	1
DeviceWidth Alias: Width	Double	1
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text		Fiber Parent Type	255
GlobalID	Global ID
LastUser Alias: Modified By	Text			255
Manufacturer	Text			50
Model	Text			50
NumberOfPortColumns Alias: # of Port Columns	Long Integer
NumberOfPortRows Alias: # of Port Rows	Long Integer
Owner	Text		Fiber Owner	100
PartNum	Text			20
SerialNumber	Text			50
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceLNFromJunctionID	Long Integer
SourceLNToJunctionID	Long Integer
SourceObjectID	Long Integer
SourceParentClassName	Text			50
SourceParentDeviceObjectID	Long Integer
SourceParentObjectID	Long Integer
ThisFiberClassModelName	Text	ActiveDevice		25

F_ACTIVETRANSMITPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			25
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	ActiveDevice		255
GlobalID	Global ID
Height	Long Integer
ImpliedAlignment	Long Integer	1
ImpliedConnectionSourceGuid	Guid
LambdaMax Alias: Wavelength Max	Double
LambdaMin Alias: Wavelength Min	Double
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnDevice Alias: Position	Long Integer
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceObjectID	Long Integer
SourcePanelDeviceObjectID	Long Integer
Subtype	Long Integer	0
ThisFiberClassModelName	Text	ActiveTransmitPort		255
Width	Long Integer

F_ACTIVERECEIVEPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			25
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	ActiveDevice		255
GlobalID	Global ID
Height	Long Integer
LambdaMax Alias: Wavelength Max	Double
LambdaMin Alias: Wavelength Min	Double
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PigtailColor	Text		Fiber Colors	25
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnDevice Alias: Position	Long Integer
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceObjectID	Long Integer
Subtype	Long Integer	0
ThisFiberClassModelName	Text	ActiveReceivePort		255
Width	Long Integer

F_PASSIVECOMMONPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			255
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text			255
GlobalID	Global ID
Height	Long Integer
LambdaMax Alias: Wavelength Max	Double
LambdaMin Alias: Wavelength Min	Double
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnDevice Alias: Position	Long Integer
PortStatus Alias: Status	Long Integer	4	FiberPortStatus
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	PassiveCommonPort		255
Width	Long Integer

F_PASSIVEDEVICE

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			255
DateModified Alias: Date Modified	Date
DeviceHeight Alias: Height	Long Integer	1
DeviceName Alias: Name	Text			25
DevicePosition Alias: Position	Long Integer
DeviceWidth Alias: Width	Long Integer	1
FiberChildClassModelName	Text			25
FiberParent	Guid
FiberParentClassModelName	Text		Fiber Parent Type	25
GlobalID	Global ID
LastUser Alias: Modified By	Text			25
NumberOfPortColumns Alias: # of Columns	Long Integer
NumberOfPortRows Alias: # of Rows	Long Integer
ObjectID	Object ID
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	PassiveDevice		25

F_PASSIVESPLITPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			255
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	PassiveDevice		255
GlobalID	Global ID
Height	Long Integer
ImpliedAlignment Alias: Implied Alignment	Long Integer
ImpliedConnectionSourceGuid	Guid
LambdaMax Alias: Wavelength Max	Double			25
LambdaMin Alias: Wavelength Min	Double			25
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnDevice Alias: Position	Long Integer
PortStatus Alias: Status	Long Integer	4	FiberPortStatus
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	PassiveSplitPort		255
Width	Long Integer

F_SHELF

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			255
DateModified Alias: Date Modified	Date
DeviceOrientation Alias: Orientation	Text		Fiber Slot Orientation	25
EquipmentType Alias: Type	Text			100
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	PassiveDevice		255
GlobalID	Global ID
LastUser Alias: Modified By	Text			255
NumberOfDeviceColumns Alias: Columns	Long Integer
NumberOfDeviceRows Alias: Rows	Long Integer
ObjectID	Object ID
RackPosition Alias: Position	Long integer
ShelfHeight Alias: Height	Long Integer	0
ShelfName Alias: Name	Text			25
ShelfWidth Alias: Width	Long Integer	0
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	Shelf		255

F_SFP

Field	Data Type	Default Value	Domain	Length
Comments	Text			255
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			25
DateModified Alias: Date Modified	Date
Description	Text			100
DeviceHeight Alias: Height	Double	1
DeviceName Alias: Name	Text			255
DevicePosition Alias: Position	Long Integer	1
DeviceWidth Alias: Width	Double	1
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	ActiveDevice	Fiber Parent Type	255
GlobalID	Global ID
LastUser Alias: Modified By	Text			255
Manufacturer	Text			50
Model	Text			50
NumberOfPortColumns Alias: # of Columns	Long Integer
NumberOfPortRpws Alias: # of Rows	Long Integer
ObjectID	Object ID
PartNum	Text			20
SerialNumber	Text			50
SFPConfiguration	Text		SFP Configuration	25
SFPType	Text		SFP Type	25
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceLNFromJunctionID	Long Integer
SourceLNToJunctionID	Long Integer
SourceObjectID	Long Integer
SourceParentClassName	Text			50
SourceParentDeviceObjectID	Long Integer
SourceParentObjectID	Long Integer
ThisFiberClassModelName	Text	SFP		255
TransmitDistanceKm	Double
TransmitPowerdB	Double

F_SFPCOMMONPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			25
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	SFP		255
GlobalID	Global ID
Height	Long Integer
LambdaMax Alias: Wavelength Max	Double
LambdaMin Alias: Wavelength Min	Double
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnSFP Alias: Position	Long Integer
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceObjectID	Long Integer
Subtype	Long Integer	0
ThisFiberClassModelName	Text	SFPCommonPort		255
Width	Long Integer

F_SFPSPLITPORT

Field	Data Type	Default Value	Domain	Length
CreationDate Alias: Date Created	Date
CreationUser Alias: Created By	Text			25
DateModified Alias: Date Modified	Date
FiberChildClassModelName	Text			255
FiberParent	Guid
FiberParentClassModelName	Text	SFP		255
GlobalID	Global ID
Height	Long Integer
ImpliedAlignment	Long Integer	1
ImpliedConnectionSourceGuid	Guid
LambdaMax Alias: Wavelength Max	Double
LambdaMin Alias: Wavelength Min	Double
LastUser Alias: Modified By	Text			255
ObjectID	Object ID
PortName Alias: Name	Text			25
PortNumber Alias: Number	Long Integer
PortPositionOnSFP Alias: Position	Long Integer
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
SourceClassName	Text			50
SourceObjectID	Long Integer
Subtype	Long Integer	0
ThisFiberClassModelName	Text	SFPSplitPort		255
Width	Long Integer

F_CIRCUIT

Field	Data Type	Domain	Length/Precision
CircuitLength Alias: Length (ft)	Double
CircuitName Alias: Name	Text		255
CircuitStatus Alias: Status	Text	Fiber Circuit Status	50
CircuitType	Text	Fiber Circuit Type	255
FiberCircuitGraph Alias: Graph	Text		5000
FiberCircuitHeaderClass	Text		255
FiberCircuitHeaderGlobalID	Guid
FiberCircuitTraceStyle	Long Integer
FiberLambda Alias: Wavelength (nm)	Double
GlobalID	Global ID
ObjectID	Object ID