Appl Clin Inform 2014; 05(01): 284-298
DOI: 10.4338/ACI-2013-11-RA-0096
Research Article
Schattauer GmbH

Using a Scripted Data Entry Process to Transfer Legacy Immunization Data While Transitioning Between Electronic Medical Record Systems

J. Michel
1  Children‘s Hospital of Philadelphia, Pediatrics, Philadelphia, Pennsylvania, United States
,
A. Hsiao
2  Yale School of Medicine, Pediatrics and Emergency Medicine, New Haven, Connecticut, United States
,
A. Fenick
2  Yale School of Medicine, Pediatrics and Emergency Medicine, New Haven, Connecticut, United States
› Author Affiliations
Further Information

Correspondence to:

Jeremy J. Michel
Suite 1024
3535 Market Street
Philadelphia, PA 19104

Publication History

received: 12 November 2013

accepted: 27 January 2014

Publication Date:
20 December 2017 (online)

 

Summary

Background: Transitioning between Electronic Medical Records (EMR) can result in patient data being stranded in legacy systems with subsequent failure to provide appropriate patient care. Manual chart abstraction is labor intensive, error-prone, and difficult to institute for immunizations on a systems level in a timely fashion.

Objectives: We sought to transfer immunization data from two of our health system’s soon to be replaced EMRs to the future EMR using a single process instead of separate interfaces for each facility.

Methods: We used scripted data entry, a process where a computer automates manual data entry, to insert data into the future EMR. Using the Center for Disease Control’s CVX immunization codes we developed a bridge between immunization identifiers within our system’s EMRs. We performed a two-step process evaluation of the data transfer using automated data comparison and manual chart review.

Results: We completed the data migration from two facilities in 16.8 hours with no data loss or corruption. We successfully populated the future EMR with 99.16% of our legacy immunization data – 500,906 records – just prior to our EMR transition date. A subset of immunizations, first recognized during clinical care, had not originally been extracted from the legacy systems. Once identified, this data – 1,695 records – was migrated using the same process with minimal additional effort.

Conclusions: Scripted data entry for immunizations is more accurate than published estimates for manual data entry and we completed our data transfer in 1.2% of the total time we predicted for manual data entry. Performing this process before EMR conversion helped identify obstacles to data migration. Drawing upon this work, we will reuse this process for other healthcare facilities in our health system as they transition to the future EMR.

Citation: Michel J, Hsiao A, Fenick A. Using a scripted data entry process to transfer legacy immunization data while transitioning between electronic medical record systems. Appl Clin Inf 2014; 5: 284–298 http://dx.doi.org/10.4338/ACI-2013-11-RA-0096


#

 


#

Conflicts of Interest

The authors declare that they have no conflicts of interest in the research. In particular, the authors are not associated with nor do they derive any income from the consulting group who was hired to assist in this project.


Correspondence to:

Jeremy J. Michel
Suite 1024
3535 Market Street
Philadelphia, PA 19104