[Case Study] Resolving Record Discrepancies Across Multiple State Health Departments

[Case Study] Resolving Record Discrepancies Across Multiple State Health Departments

[Case Study] Resolving Record Discrepancies Across Multiple State Health Departments

#Case #Study #Resolving #Record #Discrepancies #Across #Multiple #State #Health #Departments

EXPLAINER Discrepancy in case numbers from state and local health departments by KMIZ ABC 17 News

Title: EXPLAINER Discrepancy in case numbers from state and local health departments
Channel: KMIZ ABC 17 News
[Expert Advice] Physicians Discuss The Lifesaving Value Of Early Screenings

[Case Study] Resolving Record Discrepancies Across Multiple State Health Departments

In the United States, public health infrastructure is highly decentralized. Each state manages its own public health databases, immunization registries, and disease surveillance systems. While this localization allows states to tailor their health responses, it creates severe data silos for healthcare organizations operating across state lines.

When patient data is split across multiple state health departments, record discrepancies inevitably arise. These mismatches lead to duplicate records, incomplete vaccination histories, and compromised patient safety.

This case study examines how a regional healthcare network operating in three neighboring states successfully resolved critical patient record discrepancies, establishing a single, unified source of truth.


The Challenge: Fragmented Data in a Decentralized Public Health System

The Client and the Problem

The client, a tri-state healthcare network serving over 1.2 million patients annually, faced a major operational bottleneck. Because patients frequently crossed state lines for work, relocation, or specialized care, their medical histories were scattered across three different State Health Departments and their respective Immunization Information Systems (IIS).

The network discovered that over 18% of their patient population had conflicting or incomplete records across these state registries. This fragmentation caused:

  • Duplicate immunization series being administered.
  • Delayed reporting of infectious diseases to state authorities.
  • Significant administrative burden on clinical staff who had to manually verify records via phone and fax.

Why Cross-State Health Record Discrepancies Occur

Cross-state health data reconciliation is notoriously difficult due to several systemic factors:

  • Lack of a National Patient Identifier (NPI): Without a unique national ID for patients, systems must rely on demographic matching (name, date of birth, address, phone number), which is highly prone to errors.
  • Inconsistent Data Standards: While many states use HL7 2.5.1 standards for immunization reporting, individual state health departments often implement custom schemas, field requirements, and terminologies.
  • Data Entry Errors & Life Changes: Typos, hyphenated names, name changes after marriage, and frequent address changes across state lines quickly degrade data quality.
  • Varying State Privacy Laws: Different states have unique regulations regarding patient consent (opt-in vs. opt-out) for data sharing, complicating automatic cross-border queries.

The Solution: A Multi-Phased Data Reconciliation Strategy

To resolve these discrepancies, the healthcare network partnered with healthcare IT specialists to deploy a three-phased data reconciliation framework.

[Phase 1: Identity Resolution] ---> [Phase 2: Data Standardization] ---> [Phase 3: Legal & Governance]
(EMPI & Probabilistic Matching)     (HL7 FHIR & Translation Engines)      (Multi-State BAAs & MOUs)

Step 1: Automated Identity Resolution and Deduplication

The foundation of the project was the implementation of an Enterprise Master Patient Index (EMPI). The EMPI utilized advanced probabilistic matching algorithms to identify, link, and deduplicate patient records across different databases.

Unlike deterministic matching (which requires an exact match on all fields), probabilistic matching assigns weights to various identifiers. For example, if a patient record in State A reads "Jonathan Smith, DOB 12/04/1988" and State B reads "Jon Smith, DOB 12/04/1988" with a matching phone number, the system flags them as the same individual with a high confidence score.

Step 2: Standardizing Data Formats (HL7 FHIR & Translation Engines)

To bridge the gap between different state reporting standards, the technical team built a centralized data translation layer.

  1. Data Extraction: Patient data was extracted from the EHR and local state registries.
  2. Normalization: The translation engine converted disparate data formats into standardized HL7 FHIR (Fast Healthcare Interoperability Resources) resources.
  3. Validation: Automated validation rules checked for missing mandatory fields (such as vaccine lot numbers or manufacturer codes) before transmitting data.

Step 3: Establishing Cross-Jurisdictional Data Sharing Agreements

Technology alone cannot solve cross-state data issues; legal frameworks must support the integration. The healthcare network worked with legal counsel to draft comprehensive Business Associate Agreements (BAAs) and Memorandums of Understanding (MOUs) with all three state health departments.

These agreements established clear protocols for secure, HIPAA-compliant, bi-directional data queries across state lines, ensuring compliance with each state's specific opt-in/opt-out consent models.


Results: Measurable Improvements in Data Accuracy

Within nine months of deploying the data reconciliation strategy, the healthcare network achieved drastic improvements in data integrity, operational efficiency, and clinical safety.

| Key Performance Indicator (KPI) | Before Intervention | After Intervention | % Improvement | | :--- | :--- | :--- | :--- | | Patient Matching Accuracy Rate | 81.4% | 99.7% | +18.3% | | Average Record Reconciliation Time | 42 minutes (Manual) | < 3 seconds (Automated) | 99.9% Faster | | Duplicate Immunization Administrations | 4.2% of multi-dose series | 0.1% of multi-dose series | 97.6% Reduction | | Manual Review Backlog | 1,200+ records weekly | < 15 records weekly | 98.7% Reduction |


Best Practices for Healthcare Organizations Managing Multi-State Data

For healthcare providers, health systems, and health information exchanges (HIEs) facing similar challenges, the following best practices are recommended:

  • Invest in a Modern EMPI: Do not rely on native EHR search capabilities to resolve duplicates. A dedicated EMPI with machine-learning-based matching algorithms is essential for high-volume, multi-state data.
  • Enforce Point-of-Care Data Validation: Prevent bad data from entering the system. Train front-desk and clinical staff to collect standardized demographic details, such as legal names (avoiding nicknames), current zip codes, and middle initials.
  • Leverage National Frameworks: Participate in national interoperability frameworks such as TEFCA (Trusted Exchange Framework and Common Agreement), Carequality, or CommonWell Health Alliance to facilitate easier cross-state queries.
  • Implement Real-Time Querying: Instead of relying on batch uploads (which delay data availability), configure your system to perform real-time, bi-directional queries to state registries during patient check-in.

Conclusion: The Future of Interoperable Public Health Reporting

Resolving record discrepancies across multiple state health departments is no longer just an administrative challenge—it is a clinical necessity. As this case study demonstrates, combining advanced identity resolution technology, data standardization via HL7 FHIR, and proactive legal frameworks can successfully bridge the gaps in our decentralized public health infrastructure.

By prioritizing data integrity and interoperability, healthcare organizations can eliminate costly administrative redundancies, improve public health reporting compliance, and ultimately deliver safer, more coordinated patient care.

[Data Insight] Mapping Seasonal Pathogen Trends Using State Surveillance Databases

SUNY Downstate School of Health Professions Interprofessional Case Study by Downstate TV

Title: SUNY Downstate School of Health Professions Interprofessional Case Study
Channel: Downstate TV
[Policy Alert] State Lawmakers Pass Major Maternal Funding Bills

My Health Record consumer case study Kelly Powell by Australian Dept of Health, Disability and Ageing

Title: My Health Record consumer case study Kelly Powell
Channel: Australian Dept of Health, Disability and Ageing

12 Seri Evaluasi dalam Kesehatan Masyarakat Menggunakan Studi Kasus Sadiq Sani SoPHR by UK Health Security Agency

Title: 12 Seri Evaluasi dalam Kesehatan Masyarakat Menggunakan Studi Kasus Sadiq Sani SoPHR
Channel: UK Health Security Agency