title: A rational approach to legacy data validation when transitioning between electronic health record systems.
abstract: The objective of this project was to use statistical techniques to determine the completeness and accuracy of data migrated during electronic health record conversion.
  
  
  
  Data validation during migration consists of mapped record testing and validation of a sample of the data for completeness and accuracy. We statistically determined a randomized sample size for each data type based on the desired confidence level and error limits.
  
  
  
  The only error identified in the post go-live period was a failure to migrate some clinical notes, which was unrelated to the validation process. No errors in the migrated data were found during the 12- month post-implementation period.
  
  
  
  Compared to the typical industry approach, we have demonstrated that a statistical approach to sampling size for data validation can ensure consistent confidence levels while maximizing efficiency of the validation process during a major electronic health record conversion.
authors.affiliation: Division of Critical Care Medicine Department of Pediatrics, Stanford University School of Medicine Division of Systems Medicine, Department of Pediatrics, Stanford University School of Medicine, Stanford, CA Information Services Department, Stanford Children's Health, CA npageler@stanford.edu.
authors.forename: Natalie M
authors.initials: NM
authors.lastname: Pageler
authors.affiliation: Department of Statistics, Carnegie Mellon University, Pittsburgh, PA.
authors.forename: Max Jacob
authors.initials: MJ
authors.lastname: Grazier G'Sell
authors.affiliation: Information Services Department, Stanford Children's Health, CA.
authors.forename: Warren
authors.initials: W
authors.lastname: Chandler
authors.affiliation: Information Services Department, Stanford Children's Health, CA.
authors.forename: Emily
authors.initials: E
authors.lastname: Mailes
authors.affiliation: Information Services Department, Stanford Children's Health, CA.
authors.forename: Christine
authors.initials: C
authors.lastname: Yang
authors.affiliation: Departments of Biomedical Informatics and Pediatrics, University of California San Diego, CA.
authors.forename: Christopher A
authors.initials: CA
authors.lastname: Longhurst
mesh_terms: D003199:Computer Systems; D057286:Electronic Health Records; D016347:Medical Records Systems, Computerized
keywords: Data migration; applied clinical informatics; data validation; electronic health record; electronic medical record; implementation