Intro

  • Medication Classification Systems
    • NDC
    • RxNorm
    • ATC
  • Worked Examples

National Drug Codes

  • Submissions by manufacturers, database maintained by the FDA
  • https://www.fda.gov/drugs/drug-approvals-and-databases/national-drug-code-directory
  • does not mean drug is FDA approved
  • excludes blood products, drugs only available as part of combination
  • updated daily
  • Coding System
    • 10-11 digit code
    • first 4-6 digits are manufacturer code
    • next 3-4 digits are for name, strength, dose, form (non-standardized)
    • next 1-2 digits are package codes (# of pills per package)

National Drug Codes

National Drug Codes

Mapping Problem

  • For most research use cases, the specific manufacturer of a chemical compound is irrelevant
  • Need to map all of these different codes to some intrinsic clinical meaning
  • commercial and public databases available

RxNorm

  • Maintained by NLM, Part of UMLS
  • https://www.nlm.nih.gov/research/umls/rxnorm/index.html
  • Normalized naming system for generic and branded drugs
  • Mapping between drug terminologies and pharmacy knowledge base systems
  • Excludes Non-therapeutic radiopharmaceuticals, bulk powders, contrast media, food, dietary supplements, and medical devices

RxNorm Sources

RxNorm

ATC

  • Anatomic Therapeutic Chemical Classification
  • Controlled by WHO
  • Classifies drugs based on therapeutic of pharmaceutical class / subclass
  • 5 levels
    • First Level: Anatomic main group
    • Second Level: Pharmacologic OR Therapeutic Group
    • Third Level: Pharmacologic OR Therapeutic SubGroup
    • Fourth Level: Additional Pharmacologic OR Therapeutic Group
    • Fifth Level: Chemical Substance
  • Issues: many drugs have mixed mechanisms of actions, or multiple indications, but only classified into a single ATC group
  • Some drugs assigned under MoA rather than indication
  • ex: Beta Blockers: propranolol

Core Tables of Interest

  • MedicationDim
  • MedicationCodeDim
  • MedicationSetDim
  • MedicationOrderFact
  • MedicationDispenseFact
  • MedicationAdministrationFact

Data Diagram

Data Diagram

Examples

  • See video