Data quality rules

Data quality rules are defined checks, conditions, and acceptance criteria used to determine whether data is fit for its intended use. In manufacturing and regulated operations, they commonly apply to master data, transactional records, sensor values, genealogy data, quality results, and integrations between systems such as MES, ERP, LIMS, QMS, and historians.

These rules commonly test whether data is accurate, complete, consistent, valid, timely, and unique. Examples include requiring a lot number on a production record, confirming a material code exists in the approved master data set, checking that a measurement falls within an expected range, or enforcing that timestamps follow a required format and sequence.

Data quality rules are not the same as the data itself. They are the criteria used to evaluate or control data quality. They may be applied at data entry, during system integration, in batch validation jobs, or in reporting and analytics pipelines.

How the term is used in operations

Operationally, data quality rules often appear as field validations, interface checks, exception logic, reconciliation rules, and review workflows. They may prevent invalid records from being saved, flag suspicious values for review, or identify mismatches across systems. In regulated environments, they also help support consistent records and clearer evidence trails, but they do not by themselves guarantee compliance or correctness of the underlying process.

• Completeness rules: required fields must be populated.

• Validity rules: values must match allowed formats, code lists, or units.

• Consistency rules: related fields or systems must not conflict.

• Range or logic rules: values must fall within expected limits or follow business logic.

• Uniqueness rules: identifiers such as serial numbers should not be duplicated where duplication is not allowed.

• Timeliness rules: data must be captured or updated within a defined time window.

Common confusion

Data quality rules are often confused with business rules and data validation. Business rules govern how a process or transaction should work more broadly. Data validation is one way to enforce or test a data quality rule, usually at entry or transfer points. The term is also different from data integrity, which commonly refers to the reliability and preservation of data over time, including issues such as unauthorized changes, loss, or corruption.

Manufacturing example

A work order completion record may be subject to data quality rules that require an operator ID, equipment ID, lot number, quantity, and completion timestamp, while also checking that the reported quantity does not exceed the planned quantity and that the lot exists in the material traceability record.