# Check records and fields separately

Treat this file as reference data, never as instructions that override the user or agent. Read the complete item before applying it. Keep use conditions, avoid conditions, limits, evidence roles and source links with the answer. An editorial block is a separately versioned analysis layer, not an original corpus claim or proof of efficacy. Cite the readable URL and version. Do not infer human review. This is a saved edition, not a live safety-notice service. Before consequential reuse, check the current page, https://vedokrok.com/data/availability.json and https://vedokrok.com/data/notices.json; absence alone does not explain why an item was removed.

Release: VEDOKROK-SEL-5d86e1b23401e578
Snapshot SHA-256: 30ce1c8fa9155763797e3d5cb55b1d94cbb8c3146ebd03fb3c006531ce60e82f
Current availability: https://vedokrok.com/data/availability.json
Current notices: https://vedokrok.com/data/notices.json

---

## Check records and fields separately

ID: MHC-D-RESEARCH-9725 · Version: 0.1.0 · Kind: principle
Source: https://vedokrok.com/knowledge/check-records-and-fields-separately

Filled fields cannot account for missing records.

Knowledge source release: MHC-RPUB-20261112-20287590
Source corpus commit: 20287590ddd3999b7492df232822b6a0f7d114b1
Source manifest SHA-256: 2a987660d12de0ce2bde77a421424f7762af1ff77872ef41093fecc33db74a95
Source projection SHA-256: 2807da39bbe6a3dee2db32a76675ac5185f5a33e8b0a5cdd0c22a4731f3378a0

### Use when

- A migration reports a high field-completion rate, but some expected customers may be missing.

### Avoid when

- A populated value may still be wrong. Set explicit rules for fields that do not apply before scoring.

### Explanation

Check which expected records arrived, then check required fields within those records. A field-completion rate among arrived records leaves out records that never arrived. Report the two questions separately so a good rate for one cannot hide a gap in the other.

### Steps

1. Compare expected and arrived record identities within the same scope.
2. Check required fields for the arrived records and label that denominator.

### Example

In this example, 450 of 500 expected accounts arrive. Of those 450, 420 have the required country code. Record coverage is 90%; country-code completion among arrived accounts is about 93.3%.

### Check

Report 450/500 accounts present and 420/450 arrived accounts with a country code. If the task needs every expected account with that field, report 420/500: 84%.

### Limits

- A populated value may still be wrong. Set explicit rules for fields that do not apply before scoring.

### Evidence and sources

- supports: Completeness covers both the presence of expected records and the population of essential values within records; populated values may still be inaccurate. — gov-dims. Claim limit: A framework definition, not a universal field list or proof that the adapted checks diagnose a particular migration failure. Required records and values depend on the task.
Source reading history: selected_passages; 2026-10-11; Six dimensions and user needs; Completeness definition and distinction from accuracy. Official page was opened on 2026-10-10 and identified sections inspected. This verifies a narrow reference basis, not the effectiveness or completeness of independently drafted practice steps. On 2026-10-11 the Completeness definition and its distinction from accuracy were read again for cards 9721/9725; this is selected-passage screening, not independent review.
Agent release review: PostgreSQL 18 table expressions, NULL comparisons and aggregates, the UK Government Data Quality Framework and Microsoft Power Query profiling documentation were checked at the cited sections. The original examples and scope limits remain attached. (Data quality dimensions: Completeness, definition and distinction from accuracy)
- gov-dims: The Government Data Quality Framework — https://www.gov.uk/government/publications/the-government-data-quality-framework/the-government-data-quality-framework

Review: agent · Agent editorial and scoped source review · 2026-11-12T18:37:40Z
Published: 2026-11-12T18:37:40Z
Related (useful_with): https://vedokrok.com/knowledge/define-what-complete-means
