Skip to content

Instantly share code, notes, and snippets.

View jpryda's full-sized avatar

Jordan Ryda jpryda

  • Meta
  • NYC
View GitHub Profile
@jpryda
jpryda / scdc_rxcui_ndc.sql
Last active December 4, 2023 15:40
Mapping from RxNorm to NDC [Brand/Generic RXCUI (SCD/SBD/GPCK/BPCK) and SCDC Crosswalks]
/*
RxNorm SCDC and Brand/Generic RXCUI (SCD/SBD/GPCK/BPCK) to NDC Crosswalks
We care about semantically defined RxNorm normal forms for clinical/branded drugs and packs ONLY.
Certain NDCs that are associated with Non-RxNorm Concepts are ignored even though these may occur (infrequently) in real data.
e.g.
44946104501
50967031730
76439025810