Before import
Profile the source file for duplicate identifiers, invalid dates, inconsistent phone/email formats, unknown departments or cadres, missing mandatory fields, and conflicting identity data.
During import
Use controlled import jobs for large files. Keep an import reference and preserve rejected rows with a reason that a data steward can understand.
Quarantine instead of guessing
When the platform cannot safely resolve a conflict, route the record to the data-quality queue. A human reviewer should decide whether to correct, merge, reject, or request more evidence.
After import
Compare source and accepted row counts, inspect representative records, review quarantine reasons, and confirm dashboard totals before announcing the registry as complete.