F_DEVICE

IMPORTANT:
  • ObjectID fields are automatically created (by Esri) when you create the schema.

  • GlobalID fields are required by Fiber Manager and are created with Esri's Add Global ID tool (Manage > Add Global IDs).

  • Tables must be versioned for an SDE database. See Esri’s documentation for more information about versioning tables.

  • Tables must also be converted to ArcFM Objects.

  • In ArcGIS applications, there are four numeric data types: Short Integer, Long Integer, Float, and Double. The choices reflect a balance between minimizing storage space while still allowing enough range and precision for the field to be useful. For example, because lengths typically have decimals, these fields are assigned either Float or Double.

    In the table below, any field set to integer does need to be either a Short or Long Integer, as these fields cannot contain decimals. So, the decision comes down to the minimum and maximum values you need for the field:

    • Short Integer Storable Range: -32,768 to 32,767

    • Long Integer Storable Range: -2,147,483,648 to 2,147,483,647

    So, as an example, would you ever have more than 32,767 patch panels on a single rack? No. So, the RackPosition field could be a Short Integer. Conversely, foot or meter stamps along a cable could easily exceed 32,767. So, CableMarking fields should be a Long Integer. Our integer recommendations err on the side of more range and usefulness, but your company could decide to change a Long Integer to a Short Integer (or a Double down to a Float) if you knew the maximum values would never exceed the types’ upper threshold.

Alias: Device

TIP: You can change the length of Text fields to a number that is appropriate for your organization.

Field

Data Type

Default Value

Domain

Length/Precision

DeviceHeight

Alias: Height

Integer

2

   

DefaultWidth

Alias: Width

Integer

32

   

FiberChildClassModelName

Alias: Fiber Child Class Model Name

Text

EndDevicePort

 

50

FiberParent

Alias: Fiber Parent

Guid

     

FiberParentClassModelName

Alias: Fiber Parent Class Model Name

Text

   

50

Name

Text

   

50

NumberOfPortColumns

Alias: Number of Columns

Integer

10

   

NumberOfPortRows

Alias: Number of Rows

Integer

1

   

RackPosition

Alias: Position

Integer

     

RackSides

Alias: Sides of Rack Shown On

Text

 

Fiber Connection Location

50

ThisFiberClassModelName

Alias: This Fiber Class Model Name

Text

EndDevice

 

50

Field Display

Primary Display Field: Choose this field in the ArcFM Properties Manager. The chosen field is displayed when using ArcFM tools such as the ArcFM Locator and ArcFM Attribute Editor. Your company can choose the most useful field to display for the end users. If the chosen field is null for the selected or identified features, the display field defaults to the ObjectID.

Because this choice also determines what is displayed on the Patch Panel Connection Report and the Circuit Trace Report, Name is recommended.

Model Names

ENDDEVICE, FIBERDATATABLESOURCE, FIBERGRIDABLECONTAINER, FIBERGRIDABLEOBJECT, FIBEROBJECT

Field Model Names

DeviceHeight: FIBERGRIDDEFAULTHEIGHT

DefaultWidth: FIBERGRIDDEFAULTWIDTH

FiberChildClassModelName: FIBERCHILDCLASSMODELNAME

FiberParent: FIBERPARENT

FiberParentClassModelName: FIBERPARENTCLASSMODELNAME

Name: FIBERCIRCUITREPORTFIELD

NumberOfPortColumns: FIBERNUMBERGRIDCOLUMNS

NumberOfPortRows: FIBERNUMBERGRIDROWS

RackPosition: FIBERGRIDPOSITION

RackSides: FIBERFACETSCONTAINEDBY

ThisFiberClassModelName: THISFIBERCLASSMODELNAME

Object AutoUpdaters

On Feature Delete: ArcFM Fiber Object Deleted

Field Autoupdaters

ChangeDate — On Feature Update: ArcFM Current Date

ChangeUser — On Feature Update: ArcFM Login User Name

CreationDate — On Feature Create: ArcFM Current Date

CreationUser — On Feature Create: ArcFM Login User Name

QR code for this page

Was this helpful?