WDM Step 2: Create Required Tables

This topic outlines the tables {object classes} that must 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_PASSIVECOMMONPORT

Alias: Passive Device Com. Port

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
PortType Alias: Type	Text		Fiber Port Type	255
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	PassiveCommonPort		255
Width	Long Integer

F_PASSIVEDEVICE

Alias: Passive Device

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

Alias: Passive Device Split Port

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
PortType Alias: Type	Text		Fiber Port Type
Sides	Text	FB	Fiber Sides	50
ThisFiberClassModelName	Text	PassiveSplitPort		255
Width	Long Integer

F_SHELF

Alias: 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_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
FiberCircuitGraph Alias: Graph	Text		2000
FiberCircuitHeaderClass	Text		255
FiberCircuitHeaderGlobalID	Guid
FiberCircuitTraceStyle	Long Integer
FiberLambda Alias: Wavelength (nm)	Double
GlobalID	Global ID
ObjectID	Object ID