F_CIRCUIT

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: Circuit

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

Field	Data Type	Domain	Length/Precision
CircuitChannel Alias: Channel	Text	Fiber Circuit Channel	50
CircuitLength Alias: Length	Double
CircuitName Alias: Name	Text		50
CircuitType Alias: Type	Text	Fiber Circuit Type	50
CircuitStatus Alias: Status	Text	Fiber Circuit Status	50
FiberCircuitGraph Alias: Fiber Circuit Graph	Text		Less than 4,000, if possible IMPORTANT: This field contains a character-based tracking method to understand the connections within the circuit. It is automatically populated and maintained by the application. A short circuit would look something like: {“start”:0,“edges”:[[0,1],[1,2],[2,3]]} The above circuit is 39 characters. Ideally, this field’s length would be no more than the longest circuit’s character count in your system because the shorter the length, the better the performance of Circuit Manager. We recommend you trace and create your longest circuit, find its character length in this field, and use that number + a small buffer of additional characters as the global length for this field. Finally, if the length exceeds 4,000 characters, your enterprise database (SQL or Oracle) converts this field to a BLOB. While that improves storage efficiency, it slows end user performance while using Circuit Manager, especially while in an editing session. That is why the recommendation is less than 4,000, if possible.
FiberCircuitHeaderClass Alias: Fiber Circuit Header Class	Text		50
FiberCircuitHeaderGlobalID Alias: Fiber Circuit Header Global ID	Guid
FiberCircuitTraceStyle Alias: Fiber Circuit Trace Style	Long Integer
FiberLambda Alias: Wavelength (nm)	Double
GlobalID Alias: Global ID	Guid

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 Circuit Trace Report, CircuitName is recommended.

Model Names

FIBERCIRCUITTABLE

Field Model Names

CircuitChannel: CIRCUITCHANNEL

CircuitLength: CALCULATEDFIBERCIRCUITLENGTH

CircuitName: FIBERCIRCUITNAME

CircuitStatus: FIBERSTATUS

CircuitType: CIRCUITTYPE

FiberCircuitGraph: FIBERCIRCUITGRAPH

FiberCircuitHeaderClass: FIBERCIRCUITHEADERCLASS

FiberCircuitHeaderGlobalID: FIBERCIRCUITHEADERGLOBALID

FiberCircuitTraceStyle: FIBERCIRCUITTRACESTYLE

FiberLambda: FIBERLAMBDA

GlobalID: GLOBALID

Object AutoUpdaters

On Feature Create — ArcFM Fiber Calculated Circuit Length

On Feature Update — ArcFM Fiber Calculated Circuit Length

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