Clinical Operations Analytics Path · Mission 13 of 25Hard
Encounters carrying multiple HCCs
GROUP BY at encounter grain with HAVING COUNT(DISTINCT) ≥ N. Pairs the per-encounter aggregate with the cohort-filtering pattern. Multi-HCC encounters are the high-value documentation targets pop-health teams work first.