Skip to main content
The terminology crosswalks (ICD-10 → diabetes / heart-failure / risk-category mappings) are already committed in the repo — nothing to load into your warehouse. Ana joins them in her Python sandbox at query time (see ontology/notes/terminology-join-pattern.md), so the grouper logic works with zero warehouse writes.

​
3.1 · Prove the groupers work

Prompt
You’ll see: raw ICD-10 codes resolved to meaningful clinical categories, with the join-in-sandbox pattern explained.

​
3.2 · Refresh or extend the reference data — optional

You don’t need this on day one — the current crosswalks are already committed. Come back when a standards version updates (CCSR/CMS-HCC release annually) or when you need certified VSAC value sets. And you don’t run the scripts yourself — Ana does:
Prompt
Prompt
You’ll see: refreshed reference tables arriving as a reviewable PR — same governance motion as everything else.

​
✅ Checkpoint

  • A grouper question worked against your data with no warehouse writes
  • You can explain the join-in-sandbox pattern in one sentence
  • You know how terminology refreshes (loader) and how licensed value sets hydrate (UMLS key)