SGA ↔ Gen4 Power BI Validation

Cross-bridge tie-out · Legacy Company "Gen4" practices · SGA bridge vs Gen4 CDM
… April 2026
Scope Matrix
Net Production
Collections
Dr Days
Provider Days
Visits
New Patients
Coverage Gaps

Per-practice × per-metric drift

Clean (≤1%) Minor (1–2%) Watch (2–5%) Action (>5%) Both zero / missing SGA value on top, Gen4 below · drift = (SGA − Gen4) / max(|SGA|,|Gen4|)

Net Production — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4Δ $Drift

Collections — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4Δ $Drift

Dr Days — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4ΔDrift

Provider Days Worked — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4ΔDrift

Visits — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4ΔDrift

New Patients — per practice

CleanMinorWatchAction
PracticeROD · StateSGAGen4ΔDrift

Gen4 locations with no SGA crosswalk match

Practices Gen4 reports but no SGA Practice Code resolves
Gen4 LocationIDGen4 PracticeReason

SGA practices (Legacy=Gen4) with no Gen4 record

SGA bridge has April data but Gen4 PBI has no corresponding location
SGA CodeSGA PracticeSGA Net ProdCollDr DaysVisits
Data: data/validation.json · pull script: pull.js · reconcile: build.js · crosswalk: data/crosswalk.json.
SGA bridge ds e3fcdf32 (ops) + 9fe377a5 (Provider Leaderboard, for Provider Days Worked). Gen4 ds 984af361 (CDM via SP). Period: April 2026.