# Master data and identity resolution: matching HCPs, patients and products
Dr. Elena Marchetti prescribes an anticoagulant to her patients in Milan. In the national prescriber registry she is "MARCHETTI ELENA, Ospedale San Raffaele." In her IQVIA prescription-tracking record (IQVIA is a leading healthcare data and analytics vendor) she appears as "E. Marchetti MD, Cardiology Dept." In the manufacturer's CRMCRMCustomer Relationship Management: software and strategy to manage and analyse customer interactions throughout their lifecycle.View full definition → (customer relationship managementcustomer relationship managementCustomer Relationship Management: software and strategy to manage and analyse customer interactions throughout their lifecycle.View full definition → system used by sales reps), she's "Elena Marchetti, Key Account, Milan Territory 4." Three records. One physician.
If a pharma company's commercial analytics team doesn't know these are the same person, her prescribing volume gets split three ways. She looks like three low-value doctors instead of one high-value specialist. Sales targeting, medical education outreach and compliance monitoring all get it wrong at once.
This is the identity resolution problem, and solving it is the job of master data managementmaster data managementMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → (MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition →): the discipline of creating one trusted, unique record for each real-world entity (a doctor, a hospital, a drug) across all systems.
Every pharma company runs on data from multiple, independently built sources:
None of these systems were built to talk to each other. Names get misspelled, hospitals merge, doctors change addresses, and abbreviations vary ("St. Mary's Hosp." vs "Saint Mary Hospital"). Without a unifying layer, the same prescriber can generate five to ten fragmented "personas" across a single company's data estate. This is a well-documented issue in pharma commercial operations; industry benchmarking by firms like Reltio and Veeva (both MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition →/CRMCRMCustomer Relationship Management: software and strategy to manage and analyse customer interactions throughout their lifecycle.View full definition → vendors serving life sciences) routinely cites duplicate HCP (healthcare professional) records as a top data-quality complaint from commercial analytics teams.
MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → in pharma isn't just deduplication, it's building structured hierarchies:
HCP (Health Care Professional): an individual, like Dr. Marchetti.
HCO (Health Care Organization): the institution she works for, Ospedale San Raffaele, which itself may roll up into a larger hospital network.
A good MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → system links HCP to HCO to network, so a company can answer: "How much total value does the San Raffaele network represent?" not just "How much did this one doctor prescribe?" This matters commercially (accurate account planning) and legally: many transparency and anti-corruption regulations (like the US Sunshine Act, part of the Physician Payments Sunshine Act under the Affordable Care Act, or France's Loi Bertrand / Sunshine française) require companies to report payments to named, correctly identified providers. Misidentification risks compliance failures, not just bad analytics.
| Identifier | Scope | What it anchors |
|---|---|---|
| NPI | US only | Individual provider or organization |
| GMC/HPD numbers | UK, varies elsewhere in EU | National medical registry ID |
| DEA number | US only | Controlled substance prescribing authority |
| IQVIA OneKey ID | Global, commercial vendor | Cross-market HCP/HCO master reference |
Note there is no single global HCP identifier. This is why commercial MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → vendors (IQVIA OneKey, Veeva Network, Dun & Bradstreet for organizations) exist: they build and license cross-referenced "golden records" that mapmapUsing software to automate repetitive marketing tasks and campaigns, enabling personalisation at scale across channels like email, web, and social.View full definition → local IDs to one master ID.
The same fragmentation problem applies to drugs, and it's arguably higher stakes because it affects safety signal detection, not just sales analytics.
NDC (National Drug Code): an 11-digit US FDA identifier, unique to a specific product, strength, and package size. The same molecule from the same manufacturer can have multiple NDCs (different pack sizes, formulations).
ATC (Anatomical Therapeutic Chemical) classification: a World Health Organization system that groups drugs by the organ system they act on and their therapeutic/chemical properties (maintained by the WHO Collaborating Centre for Drug Statistics Methodology). Used globally, especially in Europe, for epidemiological and utilization studies.
A worked example of why this matters: if a pharmacovigilance team (drug safety monitoring) is scanning adverse event reports and one adverse event database logs a product by brand name, another by NDC, and another by generic molecule name, a genuine safety signal can get diluted across three "different" product records instead of surfacing as one clear pattern.
Example: is this the "same" product across systems?
System A (claims): NDC 00069-0420-30 -> "Zithromax 250mg, 30-count"
System B (EHR): "Azithromycin 250 MG Oral Tablet"
System C (WHO ATC): J01FA10 (Azithromycin, anti-infective class)
MDM/product master must resolve all three to one product entity,
while preserving the ability to roll up to molecule (azithromycin)
or therapeutic class (J01FA, macrolides) for epidemiological analysis.Free reference tool: the WHO ATC/DDD Index lets you look up any ATC code and cross-check classification logic, useful for anyone doing pharma market analysis.
Two core techniques, often used together:
Deterministic matching: exact-match rules on a trusted identifier. If two records share the same NPI, they're the same entity. Fast, precise, but fails when the identifier is missing or inconsistent (common outside the US).
Probabilistic matching: scoring similarity across multiple weaker signals (name similarity, address proximity, specialty, phone number) when no single reliable ID exists. This is where fuzzy matching algorithms and, increasingly, machine learning classifiers come in, trained to output a confidence score ("87% likely the same HCP") rather than a binary yes/no.
A pragmatic pharma MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → pipelinepipelineAll active sales opportunities across the stages of the sales process, together with their combined potential value and probability of closing.View full definition → layers both: try deterministic match first (cheap, high confidence), fall back to probabilistic matching for the remainder, and route low-confidence matches to human data stewards for manual review.
Knowledge check
1. In the Dr. Elena Marchetti example, what is the core business consequence of failing to resolve her identity across systems?
2. What is the primary purpose of master data management (MDM) in the pharma context described?
3. Why is identity resolution especially difficult across pharma data sources like CRM, claims data, and public registries?
4. Select ALL correct answers about sources of fragmented identity data in pharma analytics mentioned in the lesson.
Select all the correct answers.
5. Select ALL correct answers about why the same physician might appear differently across data systems.
Select all the correct answers.
Generic "data qualitydata qualityThe degree to which data is fit for purpose: accurate, complete, consistent, timely, valid and unique. Poor quality data undermines analytics, reporting and AI.View full definition →" is too vague to manage. Pharma MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → teams track specific, auditable metrics:
These metrics should appear on a data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition → dashboard reviewed regularly by a data governancedata governanceData governance is the set of policies, roles, and processes that ensure data is accurate, secure, well-defined, and used responsibly across an organization.View full definition → function, often reporting into a Chief Data Officer or equivalent, distinct from IT and distinct from commercial operations, precisely so that no single business unit's incentives distort the golden record.
🎬 [VIDEO: "What is Master Data ManagementMaster Data ManagementMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition →?" - youtube.com - search for this title from IBM Technology's channel for a vendor-neutral, plain-language walkthrough of MDMMDMMaster Data Management (MDM) is the discipline of creating and maintaining a single, consistent, trusted version of an organization's core business entities like customers, products, and suppliers.View full definition → concepts applicable beyond pharma]