Circuit management tables

Every domain network consists of a set of feature classes and tables with a fixed schema. When you use the Add Telecom Domain Network tool to create the telecom domain network, three additional tables (Circuit, CircuitSection, and Subcircuit) are created to support circuit management in the network. These system-maintained tables are read-only; however, user-defined fields can be added for attribution..

Classes in a telecom domain network

The Circuit table stores information about the circuits in a telecom domain network. Each row represents a circuit and contains information about the sections that define it, when present.

The CircuitSection table stores information about the sections which define the circuits. Sections represent a collection of elements obtained through a single trace. A section can have multiple records in the table where each row represents a location (starting point, stopping point, or subcircuit) used in the section. Each section in the table must have one or more starting and stopping locations.

The Subcircuit table stores information about circuit subdivisions (subcircuits) which share the capacity or bandwidth of a circuit.

Information in the circuit management tables is updated when importing circuit definitions, when a circuit is verified, when the topology is enabled or validated, and when changes are made to a circuit. As with the other classes in a utility network, the circuit management tables are editor tracking enabled, and when working in an enterprise deployment, they are also branch versioned.

The circuit management tables are added to the map with the utility network layer and are also listed in the Contents pane for the active map.

Note:

Circuit management tables are only included in the schema for utility networks that contain a telecom domain network.

Circuit table

The Circuit table stores information about the following:

  • The name of a circuit.
  • The circuit status (Clean, Dirty, or Invalid).
  • Whether the circuit has been deleted (ISDELETED = True).
  • The last time information about a circuit was verified or exported.
  • When no sections are present (nonsectioned circuits), the starting and stopping locations that define the circuit are modeled using a single record in the table.
  • When sections are present, information about section ordering that defines the logical connectivity between sections in a circuit.

The Circuit table has the following attributes:

Field nameField aliasDescription
OBJECTID

Object ID

The object ID for the record in the table.

NAME

Name

The name of the circuit.

SECTIONORDER

Section order

Stores the logical connectivity graph between sections from the CircuitSection table as a JSON string. For example, with a circuit consisting of three sections (1, 2, and 3), if section 1 is connected to section 2, and section 2 is connected to section 3, the section order would be represented as {“1”:[2],“2”:[3],“3”:[]}. When no connection exists between sections, all sections of the circuit are interpreted as being arranged in parallel with the ROLE attribute value of Start and End. This is NULL when ISSECTIONED is False.

STATUS

Status

Specifies whether the circuit is clean, dirty, or invalid.

ISDELETED

Is deleted

Specifies whether the circuit has been marked as logically deleted. True means the circuit has been logically deleted, and False means it remains as a circuit in the telecom domain network.

The Export Circuits tool is used to delete the record or records from the table when ISDELETED is True and the Set export acknowledged parameter is checked.

LASTVERIFIED

Last verified

The last time the circuit in the table was verified using the verify operation or the Verify Circuits tool.

LASTEXPORTED

Last exported

The last time the circuit in the table was exported using the Export Circuits tool.

STARTLOCATIONSOURCEID

Start location source ID

The source ID of the feature or object that is associated with the starting point for the circuit. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is set to Unknown when ISSECTIONED is True. The default is NULL.

STARTLOCATIONID

Start location ID

The global ID of the feature or object that is associated with the starting point for the circuit. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when Is sectioned is True. The default is NULL.

STARTLOCATIONTERMINALID

Start location terminal ID

The terminal ID of the feature or object that is associated with the starting point in the circuit. This is used when modeling a non-sectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STARTLOCATIONFIRSTUNIT

Start location first unit

The first unit of the group associated with the starting point (for example, equipment unit ID). This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STARTLOCATIONLASTUNIT

Start location last unit

The last unit of the group associated with the starting point. This is used with the STARTLOCATIONFIRSTUNIT attribute to define the number of fiber strands that are grouped in the edge object and is also used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STOPLOCATIONSOURCEID

Stop location source ID

The source ID of the feature or object that is associated with the stopping point for the circuit. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STOPLOCATIONID

Stop location ID

The global ID of the feature or object that is associated with the stopping point for the circuit. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STOPLOCATIONTERMINALID

Stop location terminal ID

The terminal ID of the feature or object that is associated with the stopping point in the circuit. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STOPLOCATIONFIRSTUNIT

Stop location first unit

The first unit of the group associated with the stop location for the circuit (for example, equipment unit ID). This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

STOPLOCATIONLASTUNIT

Stop location last unit

The last unit of the group associated with the stop location for the circuit. This is used with the STOPLOCATIONFIRSTUNIT attribute to define the number of fiber strands that are grouped in the edge object. This is used when modeling a nonsectioned circuit with a single starting and stopping point. This is NULL when ISSECTIONED is True. The default is NULL.

ISSECTIONED

Is sectioned

Specifies whether the circuit is modeled with or without sections (in other words, is it a nonsectioned [simple] circuit with a single starting point and single stopping point). The default is False.

CIRCUITTYPE

Circuit type

Specifies whether the circuit is a physical circuit or a virtual circuit. A circuit is considered virtual when it contains one or more sections in which the SECTIONTYPE value is Virtual. The default is Physical.

CONFLICTCONTAINERSTATE

Conflict container state

Specifies whether the circuit or its related sections or subcircuits have changed since the last reconcile operation. All circuits are conflict containers.

GLOBALID

Global ID

The global ID of the row in the table. This value is referenced by the CircuitSection table as the CIRCUITID value, and the Subcircuit table as the PROVIDERID value where applicable.

You can add more fields to the Circuit table to communicate additional information about the circuit, such as ownership. These fields are editable and can be updated when you create or modify a circuit.

CircuitSection table

The CircuitSection table stores information about the following:

  • The information that composes a section in a circuit
  • The relationship with the circuit in which the section record participates
  • Information about the features or objects that define the section record

The CircuitSection table has the following attributes:

Field nameField aliasDescription
OBJECTID

Object ID

The object ID for the record in the table.

CIRCUITID

Circuit ID

The global ID of the circuit in which the section participates.

Tip:

The CircuitSection table can be ordered by the CIRCUITID field to group all sections belonging to a single circuit.

SECTIONID

Section ID

The ID for the section in the circuit.

STARTLOCATIONSOURCEID

Start location source ID

The source ID of the feature or object that is associated with the starting point for the circuit section. When the circuit section is associated with a subcircuit, this references the Subcircuit table alias. The default is NULL.

STARTLOCATIONID

Start location ID

The global ID of the feature or object that is associated with the starting point for the circuit section. When the circuit section is associated with a subcircuit, this references the global ID of the subcircuit. The default is NULL.

STARTLOCATIONTERMINALID

Start location terminal ID

The terminal ID of the feature or object that is associated with the starting point in the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STARTLOCATIONFIRSTUNIT

Start location first unit

The first unit of the group associated with the start location (for example, equipment unit ID) in the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STARTLOCATIONLASTUNIT

Start location last unit

The last unit of the group associated with the start location for the circuit section. This is used with the STARTLOCATIONFIRSTUNIT attribute to define the number of fiber strands that are grouped in the edge object for the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STOPLOCATIONSOURCEID

Stop location source ID

The source ID of the feature or object that is associated with the stopping point for the circuit section. When the circuit section is associated with a subcircuit, the value is NULL. The default is NULL.

STOPLOCATIONID

Stop location ID

The global ID of the feature or object that is associated with the stopping point for the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STOPLOCATIONTERMINALID

Stop location terminal ID

The terminal ID of the feature or object that is associated with the stopping point in the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STOPLOCATIONFIRSTUNIT

Stop location first unit

The first unit of the group associated with the stop location (for example, equipment unit ID) in the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

STOPLOCATIONLASTUNIT

Stop location last unit

The last unit of the group associated with the stop location for the circuit section. This is used with the STOPLOCATIONFIRSTUNIT attribute to define the number of fiber strands that are grouped in the edge object for the circuit section. When the circuit section is associated with a subcircuit, the value is -1. The default is NULL.

ROLE

Role

Specifies the role of the record in the circuit. This is used to identify the start, end, and midspan sections of a circuit. This system-maintained field is derived from the SECTIONORDER field in the Circuit table. The default is Start and End. The values are as follows:

  • Start and End
  • Start
  • End
  • Midspan

SECTIONTYPE

Section type

Specifies whether the circuit section is physical or virtual. The default is Physical.

GLOBALID

Global ID

The global ID of the row in the table.

Subcircuit table

The Subcircuit table stores information about the following:

  • The name of the subcircuit
  • The name of the provider circuit from which the subcircuit originates
  • The name of the circuit which consumes the subcircuit

The Subcircuit table has the following attributes:

Field nameField aliasDescription
OBJECTID

Object ID

The object ID for the record in the table.

NAME

Name

The name of the subcircuit

PROVIDERID

Provider ID

The global ID of the circuit in the Circuit table from which the subcircuit originates.

CONSUMERID

Consumer ID

The global ID of the circuit in the Circuit table that consumes the subcircuit.

GLOBALID

Global ID

The global ID of the row in the table.