Filter dim_icd on the hcc_flag column to surface CMS-HCC-eligible codes. HCCs drive risk-adjusted reimbursement; documenting them every calendar year is the analyst's quarterly recapture campaign.
Q1 documentation campaign kicks off Monday. Different cut from the chronic list I pulled last week — chronic and HCC overlap but they aren't the same column. CMS pays on hcc_flag; care management staffs on is_chronic. We need the master list of HCC-eligible codes for the coding team's worklist. Pull every ICD-10 in dim_icd where hcc_flag = 1 — code, description, CCSR category, body system, and the chronic flag too. Sort by body_system, then code. The chronic column tells the team which HCCs are recurring (carry forward annually) vs. acute (new event, new documentation).
| Column | Type | Key |
|---|---|---|
| icd_code | TEXT | PK |
| icd_description | TEXT | |
| ccsr_category | TEXT | |
| ccsr_description | TEXT | |
| body_system | TEXT | |
| is_chronic | INT | |
| hcc_flag | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Single table — dim_icd. WHERE hcc_flag = 1.
Five columns out: icd_code, icd_description, ccsr_description, body_system, is_chronic. Coders use the chronic flag to prioritize recurring HCCs over one-off acute ones.
ORDER BY body_system, icd_code. Body system lets coders work one specialty at a time; the icd_code secondary sort keeps related codes together within a system.