Mitigate Post-Merger MPI Data Conversion Errors

Updated on January 16, 2020

Part 1 of 2

By Karen Proffitt

An often-overlooked aspect of merger, acquisition or affiliation arrangements between healthcare organizations is the need to combine master patient index (MPI) databases. When improperly managed, data conversions can have serious short and long-term implications for impacted organizations and their patients.

To maintain data integrity, careful planning and extensive testing and validation must be undertaken. This will also address safety concerns and operational inefficiencies. To help smooth the conversion path, there are several best-practice strategies that go a long way toward minimizing the MPI quality degradation and errors. 

When put into practice, these strategies will help prevent post-conversion impairment of clinical data interoperability.

Planning:  Success requires a multi-disciplinary approach that starts with bringing to the planning table key stakeholders from departments including HIM, Revenue Cycle, Clinical Informatics, Risk Management and IT. Doing so ensures development of a comprehensive strategy that supports legal record retention and, more importantly, quality patient care. Other key components of the planning stage are a dedicated project manager and clearly defined, comprehensive scope of data to be converted. Development of a strategy for managing clinical data that currently resides in the legacy system is equally important.  

Analysis:  Pre-conversion analysis is essential to executing an efficient, comprehensive data conversion. The decisions made during this process will have a long-lasting impact on data quality and access, patient safety, end user satisfaction, regulatory compliance and operational workflows. This effort provides complete understanding of what is entailed and why it is critical. It is also important for minimizing legacy system maintenance, which helps prevent the need for long-term dedication of resources to that process. By extracting the legacy system MPI data into a test environment—or bringing in a third party to manage the process—overall data quality and aberrant records can be assessed. Shell records can also be identified and the number of possible duplicate and overlay records determined. 

Pre-Conversion Cleanup:  Duplicates are the unwelcomed gift that keeps on giving. The more that exist in the MPI, the faster duplicate creation rates climb. Thus, the recommendation is to clear duplicates from the source system prior to an MPI conversion, which will spare the source system from receiving more data “pollution.” If time and resources are lacking, the cleanup effort can be handed off to outside experts who can research and merge possible duplicates or overlaps in a much shorter timeframe. 

Technical Considerations and Data Survivorship Rules:  Frustration and re-work can be avoided with deliberate, careful planning designed with both expected outcomes and potential errors in mind. No one wants to be celebrating a successful conversion only to discover numerous issues hiding in work queues—issues that will take months and even years to resolve.

Testing:  To bullet proof the conversion plan, define test cases that cover a representative sample of the data. It’s important to include not just the first 100 or 1,000 records, but also first and oldest records in each batch file and additional random sub-sets throughout. Ideally, test the foreign system load in a test environment that is already populated with the full production MPI. Identify which errors are returned and plan resolution procedures and accountability. Estimate the level of manual effort likely required post-conversion to resolve intra-facility duplicate records that were not cleaned up prior to the merger of foreign data source records, as well as inter-facility overlaps that were not auto-combined.

Careful planning on the front end of any data conversion will prevent headaches on the back end.

Part Two of this two-part series will examine the factors that are critical to successfully achieving clinical data interoperability.

Karen Proffitt is Vice President of Industry Relations for Just Associates, a nationally recognized leader in patient matching and health information data integrity and management.

The Editorial Team at Healthcare Business Today is made up of skilled healthcare writers and experts, led by our managing editor, Daniel Casciato, who has over 25 years of experience in healthcare writing. Since 1998, we have produced compelling and informative content for numerous publications, establishing ourselves as a trusted resource for health and wellness information. We offer readers access to fresh health, medicine, science, and technology developments and the latest in patient news, emphasizing how these developments affect our lives.