What is Duplicate Records

Duplicate Records Definition

Duplicate Records are the "Silent Killer" of provider data quality. For Payer Ops, duplicates lead to "Split Credentialing," where one record shows a doctor is credentialed while the other does not, causing valid claims to be denied. For C-level Executives, duplicates inflate the "Provider Count," leading to false claims of network adequacy that can be uncovered by regulators. Duplicates usually occur because of inconsistent data entry (e.g., "Jon Smith" vs. "Jonathan Smith") or when "Roster Uploads" are performed without a proper "Matching Engine." Resolving duplicates requires "De-duplication" or "Data Merging," a process of collapsing multiple records into a single "Golden Record" while preserving the history and transaction links of all previous entries.

FAQs

Why are NPIs not enough to prevent duplicate records?

While the NPI is unique, manual data entry errors (typos) or systems that create a new record for every "Tax ID" a doctor bills under can still result in multiple entries for one NPI.

What is the clinical risk of duplicate records?

If a provider is sanctioned or their license is revoked, the change might be applied to one record while the "duplicate" remains active, allowing the provider to continue treating patients and billing.

How can "Machine Learning" help find duplicates?

ML algorithms can look at patterns beyond just names—such as shared phone numbers, addresses, and specialties—to identify "High-Probability" duplicates that a simple text search would miss.