National Drug Code
ndcDefinition
ISO-11179 Definition
The National Drug Code (NDC) is the FDA's universal product identifier for human drugs, including prescription drugs, over-the-counter products, and insulin. Every drug product marketed in the United States is assigned a unique NDC that identifies the labeler (manufacturer or distributor), the specific drug product formulation, and the specific package size and type. The NDC is an 11-digit number structured as three segments: a 5-digit labeler code, a 4-digit product code, and a 2-digit package code.
The same active ingredient at the same strength available from different manufacturers will have different labeler codes, making NDC the finest-grained drug product identifier in the US healthcare system. NDC codes are the primary drug identifier in pharmacy claims transactions (NCPDP D.0 standard), PBM adjudication systems, formulary management, medication adherence analytics, and drug safety surveillance. HEDIS pharmacy-based quality measures such as Medication Adherence for Diabetes, Cholesterol, and Hypertension medications rely on NDC codes to identify qualifying drug dispensing events.
Drug Enforcement Administration (DEA) controlled substance schedules are mapped to NDC codes for pharmacovigilance and formulary tier management. The FDA updates the NDC directory weekly as new drug products are approved and existing products are discontinued. Healthcare data engineers face a pervasive normalization challenge with NDC codes because the same drug product arrives from different source systems in incompatible formats: 5-4-2 dash-segmented (12345-6789-01), 11-digit flat with leading zeros (12345678901), 10-digit without leading zeros (1234567890), and various hybrid formats.
All must be normalized to 11-digit no-dash format by stripping dashes and left-padding with zeros before joining to the FDA NDC directory or CMS drug reference files. NDC columns should be stored as VARCHAR(11) — never as integers, which drop leading zeros. Common data model components include a drug reference dimension table populated from the FDA NDC directory containing proprietary name, nonproprietary name, dosage form, route, strength, DEA schedule, and therapeutic class, joined to pharmacy claims fact tables via the normalized 11-digit NDC.
Related identifiers include the Generic Product Identifier (GPI), RxNorm for normalized drug concepts, and HCPCS J-codes for injectable drugs billed on medical claims.
Standard Abbreviation
ndc
Category
Production DDL — FACT_PHARMACY_CLAIM
CREATE OR REPLACE TABLE FACT_PHARMACY_CLAIM (
rx_clm_key INTEGER NOT NULL -- surrogate key,
rx_clm_id VARCHAR(50) NOT NULL -- pharmacy claim ID,
mbr_key INTEGER NOT NULL -- FK to DIM_MEMBER,
ndc_cd VARCHAR(11) -- national drug code,
drug_nm VARCHAR(255) -- drug name,
drug_gnrc_ind CHAR(1) -- generic indicator,
days_sply_cnt SMALLINT -- days supply count,
qty_dspnd DECIMAL(10,3) -- quantity dispensed,
rx_fill_dt DATE -- fill date,
formulary_tier SMALLINT -- formulary tier,
rx_cost_amt DECIMAL(10,2) -- total drug cost,
mbr_pay_amt DECIMAL(10,2) -- member pay amount,
plan_pay_amt DECIMAL(10,2) -- plan pay amount,
prior_auth_ind CHAR(1) -- prior auth required,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical pharmacy table. Convert to BigQuery or Databricks →
Why This Term Matters
Pharmacy data is among the most regulated and codified data in healthcare, governing controlled substances, PBM adjudication, and Medicare Part D reporting. A data engineer fluent in pharmacy terminology builds pipelines that correctly parse NDC codes, validate DEA numbers, and detect drug utilization anomalies before they reach compliance teams. Errors in pharmacy field definitions frequently trigger PBM contract disputes and CMS audit findings.
Related Content
Related Definitions
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms