Data values of two sets of attributes between records (cross record)DAMA: 23

Consistency (Cross-Record)

The degree to which data values of two sets of attributes between records comply with a rule.

Created: 10/30/2025
Business Impact
Positive Impacts
  • •Ensures that unique identifiers or key attributes are not improperly duplicated across different records representing distinct entities.
  • •Maintains the integrity of relationships where one record should uniquely map to another based on specific rules (e.g. one primary contact per account).
  • •Prevents ambiguity when linking records based on supposedly unique shared attributes.
  • •Supports accurate aggregation and counting when business rules dictate unique relationships between records.
Negative Impacts (if poor quality)
  • •Incorrect linkage of records leading to flawed analysis or operational errors (e.g. attributing multiple SSNs to one person indirectly).
  • •Violation of business rules that define unique relationships between different types of records.
  • •Difficulty in accurately identifying distinct entities when linking data based on shared attributes that should be unique in one table but map to multiple in another.
  • •Skewed counts or aggregations if cross-record uniqueness rules are violated.
Technical Description

%

Examples
Good quality vs poor quality indicators
Good Quality Examples

Logistics: All orders belonging to the same shipment share the same unique Vessel Voyage number.

E-commerce: Within a single order, all line items correctly reference the same unique Order ID.

Asset Management: All maintenance tasks scheduled for a specific piece of equipment correctly link to that equipment's unique asset ID.

Poor Quality Examples

Logistics: Two different employee records in the HR system show the same unique Social Security Number.

E-commerce: Multiple customer records exist with the exact same email address but different customer IDs.

Asset Management: Two distinct asset records in the maintenance system share the same unique serial number.

Local Network
Quick Stats
Dependent KPIs0
Improvement Standards0
CategoryData values of two sets of attributes between records (cross record)
API Access
GET /api/dq-dimensions/d0d350ee-86e0-48ab-bf86-f7b79a21aaa2