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 or through ArcGIS REST API.

The Associations table stores information about the following:

  • The associations in a utility network
  • The features or objects that participate in an association
  • Whether 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 are the following:

  • 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

The status value is used 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. You can use the From Path option Data From Path on the Add Data drop-down menu Add Data to add the Associations table to a map. This can be used 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 in the Contents pane under Standalone tables.

Interpret status values

The Status attribute field value indicates whether modifications have been made to an association or the features and objects that participate in the association. The values displayed in the attribute field represent decimal values that correspond with a bit encoded value. The following table outlines the status bit values and how these are presented in the Status field:

Status bitStatus field valueDescription

N/A

0

The association is not dirty or deleted.

0

1

The association is deleted.

1

2

The feature or object on the From side of the association is deleted.

2

4

The feature or object on the To side of the association is deleted.

3

8

The association is dirty.

4

16

The object on the From side of the association is dirty.

5

32

The object on the To side of the association is dirty.

For example, a status bit of 4 would be represented in the Status field as 16 (2^4 = 16) and indicate that the object on the From side of the association has been modified and is dirty. An association record that has not been modified or deleted does not have a bit value set and is represented with a Status attribute value of 0. These values are summated when multiple modifications are made to an association record. For example, a Status attribute of 49 indicates that the From and To object in the association is dirty and that the association itself has been deleted: (2^4 + 2^5 + 2^0) = 49.