Consistency (Record-Level)
The degree to which data values of two sets of attributes within a record comply with a rule.
- •Ensures logical sense and adherence to business rules within individual data records.
- •Prevents internal contradictions within a record that could lead to processing errors or misinterpretation.
- •Improved data quality at the most granular level, forming a reliable base for aggregation.
- •Reduced exceptions in automated data validation and processing.
- •Illogical data entries (e.g., shipment date before order date) leading to process failures or incorrect calculations.
- •Increased manual effort to identify and correct internal inconsistencies within records.
- •Reduced reliability of individual records used in decision-making or customer interactions.
- •Poor performance of AI models if training data contains internally inconsistent records.
%
Logistics: In an employee record, 'HireDate' is always earlier than or equal to 'TerminationDate' (if the latter is present).
HR: An employee's age calculated from 'DateOfBirth' is consistent with their listed 'AgeGroup' category.
Finance: In a loan application record, the 'LoanAmountRequested' is less than or equal to the 'MaximumLoanAmountAllowed' for that loan type.
Logistics: A shipment record shows 'DateShipped' is earlier than 'DateBooked'.
HR: An employee record has a 'TerminationDate' that is before their 'HireDate'.
Finance: An invoice record has a 'DueDate' earlier than its 'IssueDate'.
Customer Credit Limit Validation improves 24
Date Range Validation improves 24
Work Order Status Lifecycle Validation improves 24
Future Date Prohibition (Transaction Dates) improves 24
Weight/Volume Consistency Check improves 24