Data quality and query resolution

Incoming data → checks → flagged records → review or query → resolution → analysis-ready data

Flow diagram

Data quality and query resolutionData quality and query resolutionNoYesF1.S1Incoming data versionF1.S2Run declared quality checksF1.S3Issues requiring review?F1.S4No unresolved issuesF1.S5Investigate or queryF1.S6Correct or document exceptionF1.S7Recheck affected dataF1.S8Data ready for defined useF1.N1Data quality issue logCheckIssueAffectedunitOwnerResolutionStatusVersionIssueF1.N2Unresolved issue handling

Steps

Incoming data version

Identify the source extract and expected schema.

Run declared quality checks

Specify schema, range, chronology, completeness and cross-source checks.

Issues requiring review?

Separate unresolved issues from accepted limitations.

No unresolved issues

Record checks performed and their coverage.

Investigate or query

Assign issue ownership and preserve the original value.

Correct or document exception

Record resolution rationale; do not silently replace source data.

Recheck affected data

Verify resolution or retain an explicit unresolved status.

Data ready for defined use

Record remaining limitations and reviewer decision.

Tables and supporting information

Data quality issue log

Data quality issue logCheckIssueAffectedunitOwnerResolutionStatusVersionIssue

Unresolved issues remain visible; readiness is a recorded decision, not an automated certification.

Unresolved issue handling

Define escalation and repeat checks where unresolved issues remain.

Sources