Success and Challenges Querying OMOP-transformed EHR Data from Different Healthcare Organizations

Abstract

Background

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.

Materials and Methods

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.

Results

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.

Conclusion

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.

Keywords

interoperability - common data model - health information exchange

Protection of Human and Animal Subjects

Use of EHR data from five separate deceased patients who received care at both the UCSF and SFVA was approved by the UCSF Institutional Review Board (IRB) and the SFVA Research & Development Committee.

Publikationsverlauf

Eingereicht: 06. Mai 2025

Angenommen: 10. Juli 2025

Artikel online veröffentlicht:
26. August 2025

• References

• 1 Congress. 21st Century Cures Act. Secondary 21st Century Cures Act 2016 . Accessed August 16, 2024 at: https://www.congress.gov/114/plaws/publ255/PLAW-114publ255.pdf
• 2 Health IT.gov. Trusted Exchange Framework and Common Agreement (TEFCA). Accessed August 16, 2024 at: https://www.healthit.gov/topic/interoperability/policy/trusted-exchange-framework-and-common-agreement-tefca
• 3 Health IT.gov. Interoperability Standards Advisory (ISA). United States Core Data for Interoperability (USCDI). Accessed August 16, 2024 at: https://www.healthit.gov/isp/
• 4 Choi M, Starr R, Riley M, Duke J. OMOP on FHIR for Data Analytic Application Platform. Accessed December 16, 2024 at: https://www.ohdsi.org/web/wiki/lib/exe/fetch.php?media=resources:omoponfhir_for_data_analytics.pdf/
• 5 Lamer A, Depas N, Doutreligne M. et al. Transforming French electronic health records into the Observational Medical Outcome Partnership's common data model: a feasibility study. Appl Clin Inform 2020; 11 (01) 13-22
• 6 National Cancer Institute. BRIDG: An international standard for biomedical research concepts designed to support computable semantic interoperability. Accessed August 16, 2024 at: https://bridgmodel.nci.nih.gov/
• 7 OHDSI. Standardized Data: The OMOP Common Data Model. Accessed August 16, 2024 at: https://www.ohdsi.org/data-standardization
• 8 Food and Drug Commission. The Future of Drug Safety: Promoting and Protecting the Health of the Public. Accessed August 16, 2024 at: https://www.fda.gov/media/77173/download
• 9 Reisinger SJ, Ryan PB, O'Hara DJ. et al. Development and evaluation of a common data model enabling active drug safety surveillance using disparate healthcare databases. J Am Med Inform Assoc 2010; 17 (06) 652-662
• 10 Stang PE, Ryan PB, Racoosin JA. et al. Advancing the science for active surveillance: rationale and design for the Observational Medical Outcomes Partnership. Ann Intern Med 2010; 153 (09) 600-606
• 11 The Book of OHDSI. Accessed August 16, 2024 at: https://ohdsi.github.io/TheBookOfOhdsi/
• 12 Overhage JM, Ryan PB, Reich CG, Hartzema AG, Stang PE. Validation of a common data model for active safety surveillance research. J Am Med Inform Assoc 2012; 19 (01) 54-60
• 13 Rosenbloom ST, Carroll RJ, Warner JL, Matheny ME, Denny JC. Representing knowledge consistently across health systems. Yearb Med Inform 2017; 26 (01) 139-147
• 14 Suchard MA, Schuemie MJ, Krumholz HM. et al. Comprehensive comparative effectiveness and safety of first-line antihypertensive drug classes: a systematic, multinational, large-scale analysis. Lancet 2019; 394 (10211): 1816-1826
• 15 Chen R, Suchard MA, Krumholz HM. et al. Comparative first-line effectiveness and safety of ACE (angiotensin-converting enzyme) inhibitors and angiotensin receptor blockers: a multinational cohort study. Hypertension 2021; 78 (03) 591-603
• 16 Ohno-Machado L, Agha Z, Bell DS. et al; pSCANNER team. pSCANNER: patient-centered Scalable National Network for Effectiveness Research. J Am Med Inform Assoc 2014; 21 (04) 621-626
• 17 OI&T VDL. Computerized Patient Record System (CPRS) User Guide: GUI Version. 2023 . Accessed August 16, 2024 at: https://www.va.gov/vdl/documents/Clinical/Comp_Patient_Recrd_Sys_(CPRS)/cprsguium.pdf
• 18 Hillestad R, Bigelow JH, Chaudhry B. et al. Identity Crisis: An Examination of the Costs and Benefits of a Unique Patient Identifier for the U.S. Health Care System. Santa Monica, CA: RAND Corporation; 2008
• 19 Mainz J, Hess MH, Johnsen SP. The Danish unique personal identifier and the Danish Civil Registration System as a tool for research and quality improvement. Int J Qual Health Care 2019; 31 (09) 717-720
• 20 Ludvigsson JF, Otterblad-Olausson P, Pettersson BU, Ekbom A. The Swedish personal identity number: possibilities and pitfalls in healthcare and medical research. Eur J Epidemiol 2009; 24 (11) 659-667
• 21 Szarfman A, Levine JG, Tonning JM. et al. Recommendations for achieving interoperable and shareable medical data in the USA. Commun Med (Lond) 2022; 2: 86
• 22 FitzHenry F, Resnic FS, Robbins SL. et al. Creating a common data model for comparative effectiveness with the Observational Medical Outcomes Partnership. Appl Clin Inform 2015; 6 (03) 536-547
• 23 de Mello BH, Rigo SJ, da Costa CA. et al. Semantic interoperability in health records standards: a systematic literature review. Health Technol (Berl) 2022; 12 (02) 255-272
• 24 Garza M, Del Fiol G, Tenenbaum J, Walden A, Zozus MN. Evaluating common data models for use with a longitudinal community registry. J Biomed Inform 2016; 64: 333-341
• 25 Xu Y, Zhou X, Suehs BT. et al. A comparative assessment of observational medical outcomes partnership and mini-sentinel common data models and analytics: implications for active drug safety surveillance. Drug Saf 2015; 38 (08) 749-765