Relationship

Available with Data Reviewer license.

Summary

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

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.

Learn more about relationship rules

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:

Validation			Constraint
Reviewer batch job	Reviewer map rule	Attribute (validation) rule	No
Yes	No	Yes (ArcGIS Pro 2.9 or later)

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 on which to run the check.	Validation
Search Goal	Yes	The relationship properties you want to validate. Note: The 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 any 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 you define of the error when a noncompliant feature is found. This information is used to provide guidance to facilitate 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 logical (AND/OR, IN/NOT IN, LIKE/NOT LIKE, IS NULL) operators.