Expected synthetic load counts

Run 4 SQL verification aid. Separate from Run 1 human-only reviewer checklist (not published on site).md.
Counts match source_manifest.csv from synthetic source pack (seed 42).

raw / stg row counts (post full load)

Table	Expected rows	Source file
raw.CareCallContact	25,942	carecall_contacts.csv
raw.CareCase	3,631	carecase_cases.csv
raw.LegendaryReferral	7,928	legendary_care_referrals.csv
raw.RosterFlowShift	40,926	rosterflow_shifts.csv
raw.LedgerPosting	7,360	ledgerwise_ledger.csv

QA view expectations

qa.MonthlyContactCaseTrend

ReportingMonth	IUCSContactCount (approx)	CaseOpenedCount (approx)	CasesWithoutSourceContact (approx)
2026-02	1,477	525	123
2026-03	1,272	542	322

March: cases up, IUCS down, cases without source contact sharply up.

qa.OrphanCareCaseSourceContact

Non-zero orphan SourceContactId rows possible (background noise).

qa.ExpiredLocalOpsMappingInUse

~9 rows with expired ValidToDate per profiling DQ004.

mart.ProviderMonthUrgentCare

Populated by Run 5 measure builder or ADF mart refresh spec — 9 months × 1 provider (DRH).