Evidence map›Paper›PMID 42523198›Full record

ArticleACI open2025

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

Colin T Purmal, Michael E Matheny, Lucila Ohno-Machado, Gary Tarasovsky, Rick Larsen, Mary A Whooley

Abstract readCase Reports
In one paragraph

Article in ACI open, 2025. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Not yet cited in PubMed.

0numbers the graph read from it
0cells of the map it votes in
0citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

0 citing papers in PubMed.

No citing paper in PubMed yet.

4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

6 authors.

Colin T PurmalSan Francisco VA Health Care System, San Francisco, California, United States.ORCID 0000-0003-0982-3911
Michael E MathenyVA Tennessee Valley Health Care System, Nashville, Tennessee, United States.ORCID 0000-0003-3217-4147
Lucila Ohno-MachadoDepartment of Biomedical Informatics and Data Science, Yale School of Medicine, New Haven, Connecticut, United States.ORCID 0000-0002-8005-7327
Gary TarasovskySan Francisco VA Health Care System, San Francisco, California, United States.ORCID 0009-0000-9093-6299
Rick LarsenUniversity of California, San Francisco, California, United States.
Mary A WhooleySan Francisco VA Health Care System, San Francisco, California, United States.ORCID 0000-0002-5943-0078

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

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.

Indexed as

common data modelhealth information exchangeinteroperability

Identifiers

PMID42523198
PMCPMC13393552

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.