Skip to main content
v2026.11,858 entries · CC-BY 4.0
LAC HealthMedical & Research SuppliesReagents, PPE & instruments — chain-of-custody documented.Fast, traceable sourcing built for regulated research environments, from bench consumables to instrumentation.Shop lac.us CodeCASRAIlac.us

Medi-Span vs. First Databank (FDB MedKnowledge): 14-Digit GPI Hierarchy, GCN Codes, Drug CDS, and RxNorm Mapping

Technical guide to Wolters Kluwer Medi-Span and First Databank (FDB MedKnowledge): 14-digit Generic Product Identifier (GPI), GCN, NDCs, and RxNorm mapping.

Written and maintained by CASRAI Editorial Board

Last updated

Medi-Span (maintained by Wolters Kluwer Clinical Drug Information) is one of the two foundational commercial medication knowledge bases—alongside First Databank (FDB MedKnowledge)—that power Computerized Provider Order Entry (CPOE), retail and inpatient pharmacy dispensing, and Pharmacy Benefit Manager (PBM) claims adjudication across the United States. Because the U.S. Food and Drug Administration’s 11-digit National Drug Code (NDC) identifies medications only at the granular manufacturer, product, and package-size level without encoding pharmacological class or clinical equivalence, Electronic Health Records (EHRs) cannot rely on raw NDCs alone to run clinical decision support system (CDSS) drug safety checks.

Medi-Span and First Databank bridge this gap by curating continuously updated relational tables and APIs that link every marketed NDC to standardized clinical formulations, therapeutic hierarchies, wholesale pricing benchmarks, and deterministic screening rules for drug-drug interactions, drug-allergy cross-reactivity, renal/hepatic dose limits, and medication reconciliation.

What Is Medi-Span? The 14-Digit Generic Product Identifier (GPI) Architecture

The defining informatics structure of Wolters Kluwer’s Medi-Span database (historically distributed via the Master Drug Data Base [MDDB] and modern cloud REST/HL7 FHIR APIs) is the Generic Product Identifier (GPI). The GPI is a proprietary 14-character hierarchical alphanumeric code composed of seven 2-character couplets (levels) that classify a pharmaceutical product from its broad therapeutic category down to its exact chemical salt, dosage form, and strength:

GPI Character Positions Hierarchy Level Name Taxonomic Granularity Clinical & Pharmacoepidemiology Use Case
Digits 1–2 (Couplet 1) Drug Group Broadest anatomical or therapeutic category (e.g., Antihyperlipidemics, Antidiabetics, Analgesics). High-level disease-category utilization dashboards and comorbidity burden indices.
Digits 3–4 (Couplet 2) Drug Class Pharmacological mechanism or chemical class (e.g., HMG-CoA Reductase Inhibitors [Statins]). Therapeutic class-effect cohort definition in observational claims studies (GPI-4).
Digits 5–6 (Couplet 3) Drug Subclass Sub-mechanism or combination grouping within the class. Refining subclass exclusions or step-therapy rules in PBM formulary design (GPI-6).
Digits 7–8 (Couplet 4) Drug Base Name Core generic active ingredient moiety (e.g., Atorvastatin, Metformin). Ingredient-level exposure definition across all salts and routes (GPI-8).
Digits 9–10 (Couplet 5) Drug Name Extension Specific chemical salt, ester, or combination ratio (e.g., Atorvastatin Calcium). Distinguishing pharmacokinetic differences between distinct salts (GPI-10, such as Metoprolol Tartrate vs. Succinate).
Digits 11–12 (Couplet 6) Dosage Form Physical form and route (e.g., Oral Tablet, Extended-Release Tablet, Intravenous Solution). Separating inpatient parenteral infusions from outpatient oral maintenance therapy (GPI-12).
Digits 13–14 (Couplet 7) Strength Exact quantitative concentration or mass per unit (e.g., 20 mg, 40 mg, 100 mg/5 mL). Full 14-digit pharmaceutical equivalence (GPI-14) for generic substitution and daily dose (MME/DDD) calculation.

Because the hierarchy is embedded directly into the string positions of the 14-character code, SQL queries in claims warehouses (such as MarketScan, Optum Clinformatics, or Medicaid TAF) can aggregate prescriptions at any taxonomic depth using a simple substring prefix (for example, WHERE SUBSTR(gpi, 1, 4) = '3940' for all statins, or matching all 14 characters for bioequivalent generic substitution).

Medi-Span vs. First Databank (FDB MedKnowledge): Compendium Comparison

When a hospital health system or EHR platform selects a commercial drug compendium to drive its CPOE ordering dictionary and smart pump drug library governance, the decision almost always comes down to Wolters Kluwer Medi-Span versus Hearst Health First Databank (FDB MedKnowledge, formerly known as NDDF Plus). While both databases curate the same FDA-marketed drugs, their data models differ structurally:

Architectural Dimension Wolters Kluwer Medi-Span First Databank (FDB MedKnowledge)
Core Formulation Equivalence Key 14-character GPI (encodes both therapeutic hierarchy and exact active ingredient + salt + form + strength). GCN_SEQNO (Clinical Formulation ID / Generic Code Number Sequence Number): a flat 5-to-6-digit numeric key identifying unique ingredient + route + dosage form + strength.
Therapeutic Classification Structure Single-parent tree embedded directly in the first 6–10 digits of the 14-digit GPI. Decoupled from GCN_SEQNO; uses FDB’s Enhanced Therapeutic Classification (ETC) tree (which supports poly-hierarchy where one drug belongs to multiple clinical indications) plus AHFS classes.
Routed vs. Dispensable Drug Concepts Links GPI-10 (ingredient/salt), GPI-12 (form), and GPI-14 (dispensable strength) to package-level 11-digit NDCs. Explicitly models Routed Generic (ROUTED_GEN_ID), Routed Dosage Form, and Dispensable Drug (GCN_SEQNO) levels for inpatient e-prescribing before a specific brand/NDC is chosen by pharmacy.
Clinical Screening Modules Drug-Drug Interaction (DDI), Drug-Allergy (DAM), Duplicate Therapy, Dose Screening, Pregnancy/Lactation, Beers Criteria, and Med-Condition (ICD-10-CM/SNOMED CT). DDI, Drug-Allergy (DAM), Dose Range Checking (DRC with neonatal/pediatric/geriatric/renal adjustments), Duplicate Therapy, and Pharmacogenomic (PGx) decision support modules.

How Medi-Span and FDB Crosswalk to NLM RxNorm in EHR and Research Workflows

Because Medi-Span’s GPI and First Databank’s GCN_SEQNO are proprietary commercial intellectual property requiring paid licensing, federal interoperability standards—including the ONC United States Core Data for Interoperability (USCDI) and HL7 FHIR Medication and MedicationRequest profiles—mandate the use of RxNorm, the public-domain normalized drug nomenclature maintained by the U.S. National Library of Medicine (NLM).

In real-world EHR integration and observational research data pipelines (such as converting EHR orders into the OHDSI OMOP Common Data Model or PCORnet CDM), systems maintain a dual-coding architecture:

  • Point-of-Care Ordering and Alerting (Medi-Span / FDB): Inside the EHR database, the clinician searches the licensed Medi-Span or FDB orderable catalog, and the CPOE inference engine runs proprietary Medi-Span or FDB drug-interaction and renal-dosing checks at order-select and order-sign.
  • Interoperability Export and Research Normalization (RxNorm Crosswalk): NLM integrates both Medi-Span (source vocabulary code SAB=MDDB) and First Databank (SAB=NDDF) directly into the RxNorm relational files (RXNCONSO.RRF). Using this crosswalk, the EHR maps every internal Medi-Span GPI or FDB GCN_SEQNO order to its corresponding public RxNorm Concept Unique Identifier (RxCUI) at the Clinical Drug (SCD) or Branded Drug (SBD) level before transmitting outbound HL7 FHIR payloads or populating de-identified clinical research warehouses.

Frequently Asked Questions

What is Medi-Span?

Medi-Span (published by Wolters Kluwer Health) is a commercial clinical drug knowledge base and pharmaceutical pricing compendium embedded in Electronic Health Records (EHRs), pharmacy dispensing systems, and Pharmacy Benefit Managers (PBMs). It classifies medications using its proprietary 14-character hierarchical Generic Product Identifier (GPI) and powers real-time Computerized Provider Order Entry (CPOE) drug-interaction, allergy, and dosing alerts.

How is Medi-Span used in clinical research and healthcare?

In healthcare delivery, Medi-Span provides the knowledge base for EHR medication ordering, drug-drug and drug-allergy safety screening, and PBM formulary adjudication. In pharmacoepidemiology and health economics outcomes research (HEOR), investigators use Medi-Span’s 14-digit hierarchical GPI codes to group thousands of package-specific FDA National Drug Codes (NDCs) into standardized therapeutic classes, active ingredients, dosage forms, and strengths.

How does Medi-Span differ from First Databank (FDB MedKnowledge) and RxNorm?

Medi-Span (Wolters Kluwer) and First Databank’s FDB MedKnowledge (Hearst Health) are the two dominant commercial drug compendia in the United States. Medi-Span encodes therapeutic hierarchy and formulation equivalence inside a single 14-character hierarchical code (GPI), whereas FDB traditionally pairs a flat Clinical Formulation ID (GCN_SEQNO) with separate therapeutic classification trees (ETC/AHFS). By contrast, RxNorm is the free, public federal drug nomenclature maintained by the National Library of Medicine (NLM) that crosswalks both Medi-Span and FDB concepts to open RxCUI identifiers for HL7 FHIR interoperability.

Follow CASRAI

Research-administration guidance, standards updates and independent tool reviews.

Ask CASRAI · free to try

Ask about Medi-Span vs. First Databank (FDB MedKnowledge): 14-Digit GPI Hierarchy, GCN Codes, Drug CDS, and RxNorm Mapping

Ask your first 2 questions free below. Subscribers get 150 a day for $29 a month.

An AI assistant specialized in research administration. It cites the sources behind every answer, labels web answers and says when it can't answer.

Answers draw on CASRAI's guides and dictionary plus the federal and funder documents we index: Federal Register, Grants.gov, Regulations.gov and UKRI.

Works on this site and inside Claude, Cursor and the AI tools you already use.

Everything CASRAI publishes — this page, the dictionary, the guides and the news — stays free to read, with no account and no card.

Referenced across the research world

University of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logoUniversity of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logo
  • University of Cambridge logo
  • Columbia University logo
  • Crossref logo
  • University of Edinburgh logo
  • Harvard University logo
  • University of Oxford logo
  • Princeton University logo
  • Stanford School of Medicine logo
  • University College London logo
  • ORCID logo

View CASRAI adoption →