Pharmacy Benefit Manager
pbmDefinition
ISO-11179 Definition
A Pharmacy Benefit Manager (PBM) is a third-party administrator that manages prescription drug benefits on behalf of health plans, employers, and government programs. The three largest PBMs — CVS Caremark, Express Scripts (Cigna), and OptumRx (UnitedHealth Group) — together manage pharmacy benefits for more than 200 million Americans. PBMs perform several core functions: they negotiate drug prices and rebates with pharmaceutical manufacturers, contract with retail and specialty pharmacies to build drug distribution networks, adjudicate pharmacy claims in real time at the point of dispensing, manage formularies (the tiered lists of covered drugs), and operate mail-order and specialty pharmacy programs.
PBM contracts are complex and contain provisions for formulary rebate sharing, spread pricing (the difference between what the PBM pays the pharmacy and charges the plan), and performance guarantees. PBM data is essential for pharmacy cost management, medication adherence analytics, formulary optimization, and HEDIS pharmacy quality measure calculation. Understanding PBM data structures requires knowledge of NCPDP transaction standards, which govern the electronic messaging between pharmacies and PBMs during claim adjudication.
The NCPDP D.0 standard defines the fields in a pharmacy claim: NDC code, days supply, quantity dispensed, DAW code, prescriber NPI and DEA number, pharmacy NPI, ingredient cost, dispensing fee, copay, and plan paid amount. Formulary tier is a critical analytical field that determines the member's cost share and indicates whether generic substitution was available. Healthcare data engineers build PBM data warehouses that integrate multiple data feeds: the claim adjudication file (approved and rejected claims), the reversal file (cancelled fills), the formulary file (drug tiers and prior authorization requirements), and the rebate allocation file.
NDC normalization to 11-digit no-dash format is a mandatory first step because PBM feeds from different systems use inconsistent NDC formats. Days supply validation is equally critical — PBM feeds routinely contain values of 999 (unlimited supply) or 0 (data entry error) that must be capped or excluded before calculating medication adherence metrics. Common PBM analytics include proportion of days covered (PDC) for HEDIS adherence measures, specialty drug trend analysis, generic substitution rate reporting, and formulary compliance dashboards that identify opportunities to shift utilization to lower-cost therapeutic alternatives.
Standard Abbreviation
pbm
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