Public-health vaccination dates are sometimes missing in clinic extracts. How should the pipeline handle those nulls?

Public-health vaccination extracts often omit vaccination dates while still carrying valid clinic-visit facts. The pipeline should impute carefully where policy allows or, more commonly, flag missing dates and retain the row so coverage analytics, outreach, and clinic operations keep the visit. Filling missing vaccination dates with the clinic batch median date and retaining a quality flag invents clinical sequences and misrepresents when the current dose was actually given; explicit null handling preserves completeness with honesty about date quality.

Filling missing vaccination dates with the clinic batch median date and retaining a quality flag fails by concept: it reuses a batch-level aggregate for a new encounter and breaks dose-interval timelines, causing clinics to miscount follow-up needs even when flagged. Deriving missing vaccination dates from scheduled appointment dates and retaining a quality flag fabricates clinical timing because an appointment is not a vaccination, corrupting schedule and efficacy analysis even when flagged. Standardizing missing vaccination dates to the extract load date and retaining a quality flag is a brittle workaround that pollutes downstream date-typed analytics with a false recent date and skews interval and coverage calculations while protecting row counts.

Exam caveat: Null handling is contextual. Required keys may fail a batch; optional clinical dates more often quarantine, flag, or rule-based impute. Distinguish "fail closed on identity keys" from "preserve clinic rows with missing attributes."

Operational check: Process a clinic file with known null vaccination_date values and confirm rows land in silver with a missing-date flag (or approved imputation) rather than filling missing vaccination dates with the clinic batch median date and retaining a quality flag. Verify gold coverage metrics exclude or separately report flagged dates. Ensure a true poison null on a required key still fails or quarantines per the stricter rule set.