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 name||Field alias||Description|
The object ID for the record in the table.
From network source ID
The unique identifier for the From network source in the utility network.
From global ID
The global ID of the From feature or object in the association.
From terminal ID
The terminal ID of the From feature or object in the association (if applicable).
To network source ID
The unique identifier for the To network source in the utility network.
To global ID
The global ID of the To feature or object in the association.
To terminal ID
The terminal ID of the To feature or object in the association (if applicable).
The association type.
Is content visible
A Boolean flag indicating whether the content is visible. This is only applicable to containment associations.
The percent along value for junction-edge midspan connectivity associations between a junction object and an edge object.
Displays a bit encoded value to communicate whether the association or its participating features or objects have been modified.
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.
Additional contextual information associated with the error.
The date the association was created.
The user who created the association.
The last time the row in the table was updated.
The last user to update a row in the table.
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 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