Associations table

The Associations table stores information about all associations in a utility network. It is a system-maintained table that is hidden by default. Each row represents an association and information about the features or objects that participate in the association. Information in this table is updated when the topology is enabled or validated, and when changes are made to an association using the Modify Associations pane.

The Associations table stores information about the following:

  • The associations in a utility network.
  • The features or objects that participate in an association.
  • Whether or not an association has been modified or is in error.
  • Editor tracking details for association records.

The Associations table contains the following attributes:

Field nameField aliasDescription

OBJECTID

Object ID

The object ID for the record in the table.

FROMNETWORKSOURCEID

From network source ID

The unique identifier for the From network source in the utility network.

FROMGLOBALID

From global ID

The global ID of the From feature or object in the association. 

FROMTERMINALID

From terminal ID

The terminal ID of the From feature or object in the association (if applicable).

TONETWORKSOURCEID

To network source ID

The unique identifier for the To network source in the utility network.

TOGLOBALID

To global ID

The global ID of the To feature or object in the association.

TOTERMINALID

To terminal ID

The terminal ID of the To feature or object in the association (if applicable).

ASSOCIATIONTYPE

Association type

The association type.

Values:

  • Junction-Junction Connectivity association = 1​
  • Containment association = 2​
  • Structural Attachment association = 3​
  • Junction-Edge From Connectivity association = 4
  • Junction-Edge Midspan Connectivity association = 5
  • Junction-Edge To Connectivity association = 6

ISCONTENTVISIBLE

Is content visible

A Boolean flag indicating whether the content is visible. This is only applicable to containment associations.

PERCENTALONG

Percentage along

The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object.

STATUS

Status

Displays a bit encoded value to communicate whether the association or its participating features or objects have been modified.

Learn more about how to interpret Status values

ERRORCODE

Error code

Errors on the association are displayed using a bit encoded value that can represent one or more errors. An association with an error code of 0 indicates a record with no errors.

ERRORMESSAGE

Error message

Additional contextual information associated with the error.

CREATIONDATE

Creation date

The date the association was created.

CREATOR

Creator

The user who created the association.

LASTUPDATE

Last update

The last time the row in the table was updated.

UPDATEDBY

Updated by

The last user to update a row in the table.

GLOBALID

Global ID

The global ID of the row in the table.

Access the associations table

The Associations table is a system-maintained table that is hidden by default. The Add Data Add Data command can be used to add the Associations table to a map to provide context and support conflict management when conflicts are detected on an association record. To add the table, provide the service URL path appended with the layer ID for the Associations table (500001) as shown in the following example: https://myserver.domain.com/server/rest/services/<service name>/FeatureServer/500001.

The table is added to the map on the Contents pane under Standalone tables.

Interpret status values

The Status field uses bitwise encoding to represent modifications made to an association or the features and objects that participate in the association. The values displayed in the field represent decimal values that correspond with the bit encoded value. For example, a status of 4 would be represented as 16 (2^4 = 16) and indicate that the feature or object on the From side of the association has been modified and is dirty. An association with a status of 0 represents an association record that has not been modified or deleted. The values presented in the Status field are derived from the following:

  • 0—The association is deleted.
  • 1—The feature or object on the From side of the association is deleted.
  • 2—The feature or object on the To side of the association is deleted.
  • 3—The association is dirty.
  • 4—The feature or object on the From side of the association is dirty.
  • 5—The feature or object on the To side of the association is dirty.

These values are summated when multiple modifications are made to an association record. For example, a status of 49 indicates that the From and To feature or object in an association is dirty and that the association itself has been deleted.

  • Example: (2^4 + 2^5 + 2^0) = 49