Relationship

Available with ArcGIS Pro Standard and Data Reviewer licenses.

Summary

The Relationship check searches a relationship class to find violations of the relationship rules based on the specified conditions.

Supported workflows

ArcGIS Data Reviewer checks support multiple methods for implementing automated review of data. The following table identifies the supported implementation methods for this check:

Attribute rule type		Supported
Validation		Yes (ArcGIS Pro 2.9 and ArcGIS Enterprise 10.9.1 or later)
Constraint		No

Overview

Relationship classes associate feature and table records with one another. The tables in the relationship are assigned cardinality. If there is a prescribed relationship that has been set up for the feature class, features that are not part of it are returned as check results.

Syntax

Parameter	Required	Description	Workflow
Subtype	No	The subtype to which the rule is applied.	Validation
Attribute	No	A query that identifies the features to which the rule is applied.	Validation
Relationship Class	Yes	The relationship class to run the check on.	Validation
Search Goal	Yes	The relationship properties you want to validate. Note: Search Goal enables properties of the relationship chosen as an input data source. Origin unreferenced or null key value—Searches for values in the origin key field that do not have a counterpart in the destination and null values in the origin key field. Destination orphan or null key value—Searches for values in the destination key field that do not have a counterpart in the origin and null values in the destination key field. Cardinality violations—Searches for records that violate the cardinality rules set for a relationship, such as one-to-many and one-to-one. Relationship rule violations—Searches for violations of relationship rules, including the three options above.	Validation
Name	Yes	A unique name for the rule. This information is used to support data quality requirement traceability, automated reporting, and corrective workflows.	Validation
Description	No	A description of the error you define when a noncompliant feature is found. This information is used to provide guidance for corrective workflows.	Validation
Severity	No	The severity of the error assigned when a noncompliant feature is found. This value indicates the importance of the error relative to other errors. Values range from 1 to 5, with 1 being the highest priority and 5 being the lowest.	Validation
Tags	No	The tag property of the rule. This information is used in rule authoring and management workflows to support traceability and reporting of data quality requirements.	Constraint
			Validation

Notes

Keep the following in mind when using the check:

• The Validation Status attribute values of both the origin and destination data sources referenced in the Relationship Class parameter are ignored during evaluation. For example, input features with a validation status of 0 (No calculation required, no validation required, no error), 1 (No calculation required, no validation required, has error(s)), 4 (Calculation required, no validation required, no error), or 5 (Calculation required, no validation required, has error(s)) are still included during rule evaluation.
• Data sources for the Relationship Class parameter must include a global ID field. In a many-to-many relationship class, the intermediate relationship class table must also contain a global ID field.
• Include both the origin and destination data sources referenced in the Relationship Class parameter when sharing web layers with the Validation capability enabled.
• The Attribute filter parameter is limited to comparison (=, <>, >, <, >=, and <=) and logical (AND/OR, IN/NOT IN, LIKE/NOT LIKE, and IS NULL) operators.
• The Attribute filter parameter does not support the following field types: Big Integer, Date Only, Time Only, and Timestamp Offset. If selected, the row header is marked in red and does not allow the rule to be saved.