Why the same payer has a dozen names in your data
Ask a specialty brand which payers are slowing patients down and the answer usually starts with a cleanup exercise. The hub records the plan name the patient read off their card. Each specialty pharmacy sends its own payer name, sometimes the PBM, sometimes the plan, sometimes the employer. Claims data carries processor identifiers rather than names. Put the files together and one national plan appears under many spellings, while a meaningful share of patients sits under other or unknown.
The consequences reach every access conversation. Approval rates and time to therapy by payer look different depending on which name a patient was filed under. A formulary win at a PBM cannot be tied to the patients it should have helped. Payer mix in the brand review and payer mix in the finance forecast disagree, and nobody can say which is right. Field reimbursement teams chase the wrong accounts because the plan in front of them is labelled differently from the plan in the contract.
The fix is not a better spreadsheet of name corrections. It is a payer hierarchy: one owned model of who pays, who manages the benefit and which book of business each patient belongs to, with every source value mapped into it. This article sets out why payer data drifts, what a hierarchy that holds up contains, and how to put one in place. It builds on our guides to mapping SP and hub status codes and gross to net in specialty pharma.
Four reasons payer data drifts
Every source names payers its own way
Hub intake captures what is on the card. Specialty pharmacies send what their billing system holds. Claims carry processor identifiers. None of them share a payer ID.
- Plan, PBM and employer used interchangeably
- Abbreviations and misspellings
- Free-text payer fields at intake
Payer is several things at once
A patient's coverage involves a parent organisation, a plan, a PBM that manages the pharmacy benefit and a channel such as commercial, Medicare Part D or Medicaid. Reports that keep one field lose the others.
- PBM decisions judged at plan level
- Channel mixed into payer name
- Medical and pharmacy benefit blended
Relationships change over time
Plans move PBMs, employers change plans and patients change coverage, often at the start of a year. Without dates on the mapping, history rewrites itself when someone edits a row.
- January coverage changes
- Last year's payer mix restated
- No record of when a mapping changed
New values land in other
A payer name nobody has seen before is not mapped, so it falls into other by default. The other bucket grows quietly until it is one of the largest payers on the dashboard.
- No alert for unmapped values
- Unknown share never reported
- Cleanup done by hand before each QBR
What a payer hierarchy that holds up looks like
How to put it in place
Pull every payer value in use
List every payer, plan and PBM value from the hub, each specialty pharmacy and claims data, with how many patients each one covers.
Agree the levels
Bring market access, patient services, brand and finance together to agree the hierarchy levels and the channel definitions, written down with examples.
Map the largest values first
Map the values that cover most patients first, using claim identifiers where they exist. Review the long tail with the people who know the accounts.
Date it and alert on gaps
Add effective dates to every mapping and an alert for unmapped values. Plan for the January coverage changes before they arrive.
Use it everywhere
Point the access dashboard, payer mix reporting, field reimbursement views and gross to net analysis at the same hierarchy, so every team reads the same payer.
Questions leaders ask about payer hierarchies
What is a payer hierarchy in pharma?
Why does our access dashboard show so many patients under other or unknown?
Should we report access by plan or by PBM?
Can we buy a payer hierarchy instead of building one?
How often does the payer hierarchy need updating?
Compare your payer data with ours
Send us the list of payer values from your hub and specialty pharmacy files. We will show how many real payers sit behind them and what a hierarchy would look like for your brand. More on our work at specialty pharma analytics and automation.
Part of our Pharma Commercial and Patient Analytics hub. Start with our specialty pharmacy analytics.