Technical Reference
Data Model
A normalized, RxNorm-centered schema with modular enrichment layers for drug intelligence, clinical inference, and market pricing. Every table is API-accessible and designed for direct integration into analytics workflows.
Schema Overview
Core entity relationships across the drug hierarchy, enrichment layers, and pricing systems. Click any entity in the detailed view below to inspect columns.
Tables by Layer
RxNorm Foundation
FoundationComplete drug hierarchy — ingredient through branded product. One row per SCD/SBD concept.
Ingredient + dose form (strength-agnostic). Central join point for enrichment layers.
RxNorm ingredient concepts (TTY = IN or MIN).
ICD-10 diagnosis code reference table.
WHO ATC therapeutic classification hierarchy.
Drug Intelligence
Reference IntelligenceUtilization-weighted drug-to-diagnosis mappings. Multi-provider consensus scoring across conditions.
Therapy behavior classification per drug form — maintenance, specialty, benefit channel, adherence eligibility.
Suspecting Rules
Inference & AnalyticsExecutable clinical logic for diagnosis inference from claims data. Supports compound rules across specialty, age, concurrent Rx, and medical history.
Market Pricing
Market IntelligenceWeekly CMS NADAC rates per NDC. National average drug acquisition cost for retail pharmacy.
Quarterly Medicare Part B ASP+6% payment limits per HCPCS code.
Spending Analytics
Market IntelligenceCleaned Medicaid State Drug Utilization with RxCUI resolution, anomaly flags, and dual-path NDC matching.
Cleaned Medicare Part D spending at ingredient level with year-over-year analytics.
Common Join Paths
Pre-validated join paths for the most common analytical workflows. Each path represents a tested integration pattern available through the API.
Navigate the full RxNorm concept tree from ingredient through drug form to specific product
Resolve drug-to-condition relationships with utilization-weighted volume estimates
From drug concept to executable inference rules with structured rule logic
Weekly acquisition cost per NDC joined to the drug hierarchy
Quarterly Medicare Part B payment limits per HCPCS code
Claims volume and cost trending at ingredient or drug level
Enumerated Values
Standardized enum values used across enrichment layers. All values are validated at ingestion time.
Column Naming
| Concept | Column Name | RxNorm TTY | Example |
|---|---|---|---|
| Drug (ingredient + form + strength) | drug_id | SCD / SBD | 617314 |
| Ingredient | ingredient_rxcui | IN / MIN | 143 |
| Clinical Drug Form | clinical_drug_form_rxcui | SCDF / SBDF | 310193 |
| NDC 11-digit | ndc11 | — | 00071213901 |
| NDC 9-digit | ndc9 | — | 000712139 |
| HCPCS Code | hcpcs_code | — | J7502 |
| ATC Code | atc_code | — | C10AA05 |