PDF icon PDF herunterladen
Open Access
CC BY-NC-ND 4.0 · Appl Clin Inform 2025; 16(01): 137-144
DOI: 10.1055/a-2441-3677
Case Report

Discrepancies in Aggregate Patient Data between Two Sources with Data Originating from the Same Electronic Health Record: A Case Study

Allen J. Yiu
1   Department of Emergency Medicine, University of California, Irvine, California, United States
2   Department of Pediatrics, Children's National Hospital, Washington, District of Columbia, United States
3   Department of Pediatrics, George Washington University School of Medicine and Health Sciences, Washington, District of Columbia, United States
,
Graham Stephenson
1   Department of Emergency Medicine, University of California, Irvine, California, United States
,
Emilie Chow
4   Department of Medicine, University of California, Irvine, California, United States
,
Ryan O'Connell
1   Department of Emergency Medicine, University of California, Irvine, California, United States
5   Department of Pathology, University of California, Irvine, California, United States
› Institutsangaben
Funding None.
› Weitere Informationen
Auch verfügbar aufeRef
  Lizenzen und Reprints
Preview

Abstract

Background Data exploration in modern electronic health records (EHRs) is often aided by user-friendly graphical interfaces providing “self-service” tools for end users to extract data for quality improvement, patient safety, and research without prerequisite training in database querying. Other resources within the same institution, such as Honest Brokers, may extract data sourced from the same EHR but obtain different results leading to questions of data completeness and correctness.

Objectives Our objectives were to (1) examine the differences in aggregate output generated by a “self-service” graphical interface data extraction tool and our institution's clinical data warehouse (CDW), sourced from the same database, and (2) examine the causative factors that may have contributed to these differences.

Methods Aggregate demographic data of patients who received influenza vaccines at three static clinics and three drive-through clinics in similar locations between August 2020 and December 2020 was extracted separately from our institution's EHR data exploration tool and our CDW by our organization's Honest Brokers System. We reviewed the aggregate outputs, sliced by demographics and vaccination sites, to determine potential differences between the two outputs. We examined the underlying data model, identifying the source of each database.

Results We observed discrepancies in patient volumes between the two sources, with variations in demographic information, such as age, race, ethnicity, and primary language. These variations could potentially influence research outcomes and interpretations.

Conclusion This case study underscores the need for a thorough examination of data quality and the implementation of comprehensive user education to ensure accurate data extraction and interpretation. Enhancing data standardization and validation processes is crucial for supporting reliable research and informed decision-making, particularly if demographic data may be used to support targeted efforts for a specific population in research or quality improvement initiatives.

Keywords

electronic health record - databases - data quality - data completeness - data analysis

Protection of Human and Animal Subjects

The studies were performed in compliance with the World Medical Association Declaration of Helsinki on Ethical Principles for Medical Research Involving Human Subjects. This study did not constitute human subject research and met the criteria for NHSR self-determination at the University of California, Irvine, CA.




Publikationsverlauf

Eingereicht: 14. Juli 2024

Angenommen: 04. September 2024

Artikel online veröffentlicht:
12. Februar 2025

© 2025. The Author(s). This is an open access article published by Thieme under the terms of the Creative Commons Attribution-NonDerivative-NonCommercial License, permitting copying and reproduction so long as the original work is given appropriate credit. Contents may not be used for commercial purposes, or adapted, remixed, transformed or built upon. (https://creativecommons.org/licenses/by-nc-nd/4.0/)

Georg Thieme Verlag KG
Rüdigerstraße 14, 70469 Stuttgart, Germany