Success and Challenges Querying OMOP-transformed EHR Data from Different Healthcare Organizations
ACI Open · 01.07.2025 · 09 (02) · e42-e53
DOI: 10.1055/a-2668-3461 ↗Kurz gefasst
Fallbericht in der Zeitschrift ACI Open, erschienen am 01.07.2025. Verfasst von Colin T Purmal und 5 weiteren Autor:innen. Beteiligte Einrichtung: San Francisco VA Health Care System, San Francisco, California, United States. Die Arbeit nennt 16 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Adoption of a common data model (CDM), such as the Observational Medical Outcomes Partnership (OMOP) CDM, is a critical component of health information exchange, but the extent to which CDMs facilitate patient-level interoperability is unclear. We sought to determine the feasibility of using a CDM for health information exchange between two healthcare organizations. We executed a single Structured Query Language (SQL) query on OMOP-transformed data from the University of California, San Francisco (UCSF) and the San Francisco VA Healthcare System for five patients. The SQL query was successfully executed, and complementary healthcare information was obtained for five of five patients, but interoperability was limited by (1) lack of uniform patient identifiers, (2) use of different coding vocabularies, and (3) variations in mapping of source data to the CDM. Although transformation of EHR data to a CDM can facilitate health information exchange, our study suggests that patient-level interoperability of a CDM may require further alignment of both semantics and syntax.
Schlagwörter
Stichwörter der Autor:innen
Autor:innen und Institutionen
- San Francisco VA Health Care System, San Francisco, California, United States.
- University of California, San Francisco, California, United States.
- VA Tennessee Valley Health Care System, Nashville, Tennessee, United States.
- Vanderbilt University, Nashville, Tennessee, United States.
- Department of Biomedical Informatics and Data Science, Yale School of Medicine, New Haven, Connecticut, United States.
ORCID-Profile: Colin T Purmal, Michael E Matheny, Lucila Ohno-Machado, Gary Tarasovsky, Mary A Whooley
Zitieren
APA
Purmal, C. T., Matheny, M. E., Ohno-Machado, L., Tarasovsky, G., Larsen, R., & Whooley, M. A. (2025). Success and Challenges Querying OMOP-transformed EHR Data from Different Healthcare Organizations. ACI Open, 09(02), e42-e53. https://doi.org/10.1055/a-2668-3461
Vancouver
Purmal CT, Matheny ME, Ohno-Machado L, Tarasovsky G, Larsen R, Whooley MA. Success and Challenges Querying OMOP-transformed EHR Data from Different Healthcare Organizations. ACI Open. 2025;09(02):e42-e53. doi:10.1055/a-2668-3461
BibTeX
@article{Purmal2025,
author = {Purmal, Colin T and Matheny, Michael E and Ohno-Machado, Lucila and Tarasovsky, Gary and Larsen, Rick and Whooley, Mary A},
title = {Success and Challenges Querying OMOP-transformed EHR Data from Different Healthcare Organizations},
journal = {ACI Open},
year = {2025},
volume = {09},
number = {02},
pages = {e42--e53},
doi = {10.1055/a-2668-3461}
}
EUVIMED