Appearance
Data validation report
Template: Enter aggregate metrics rather than personal or sensitive row-level values.
| Field | Value |
|---|---|
| Dataset / batch ID | [Identifier] |
| Source / target | [Systems] |
| Run date | [YYYY-MM-DD] |
| Mapping / rule version | [Version] |
| Validator | [Name or system] |
1. Results summary
| Metric | Result |
|---|---|
| Total input records | [Count] |
| Passed records | [Count] |
| Warning records | [Count] |
| Rejected records | [Count] |
| Duplicate records | [Count] |
| Required-field completeness | [Percent] |
Reconciliation check: [Explain whether totals balance; warning categories may overlap.]
2. Rules tested
| Rule ID | Field / scope | Expected condition | Severity | Failures |
|---|---|---|---|---|
| [VAL-01] | [Record ID] | [Unique and nonblank] | [Error] | [Count] |
| [VAL-02] | [Date field] | [Valid YYYY-MM-DD] | [Warning] | [Count] |
3. Exceptions and corrective actions
| Issue | Affected count | Owner | Resolution | Status |
|---|---|---|---|---|
| [Missing ID] | [Count] | [Role] | [Remap / request source correction] | [Open] |
4. Release decision
- [ ] Critical validation failures resolved or documented
- [ ] Sample transformed output inspected
- [ ] Totals reconciled against source
- [ ] Approved exception list retained in secure location
- [ ] Destination import test completed
Decision: [Ready / Ready with approved exceptions / Not ready]
Approved by: [Name and date]