Get hands-on with dim_icd — the ICD-10 reference table that anchors every clinical SQL query. Practice basic single-table SELECT, WHERE on a categorical field, and ORDER BY before any joins enter the picture.
Welcome aboard. Before you touch any encounter data, you need to know what's in the codebook. Pull every ICD-10 code in the Circulatory body system from dim_icd — give me the code, description, CCSR clinical category, whether it's flagged chronic, and whether it maps to a CMS-HCC. Sort alphabetically by icd_code so the cardiology codes line up. This is the codebook view our coders see when they start a chart — getting comfortable with it now will save you in every mission downstream.
| 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 filtered SELECT. dim_icd is the only table you need.
Filter on the body_system TEXT column — the briefing names the body region; the column groups codes by anatomical category (cardiology codes share one bucket).
Sort alphanumerically by the ICD code so the codebook reads in registry order.