Evidence map›Paper›PMID 31645076›Full record

ArticleApplied clinical informatics2019

Incrementally Transforming Electronic Medical Records into the Observational Medical Outcomes Partnership Common Data Model: A Multidimensional Quality Assurance Approach.

Kristine E Lynch, Stephen A Deppen, Scott L DuVall, Benjamin Viernes, Aize Cao, Daniel Park, Elizabeth Hanchrow, Kushan Hewa, Peter Greaves, Michael E Matheny

Abstract read
In one paragraph

Article in Applied clinical informatics, 2019. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 38 papers, 1 of them a synthesis that pooled it.

0numbers the graph read from it
0cells of the map it votes in
38citing papers in PubMed, 1 pooled it
–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

38 citing papers in PubMed, 1 synthesis or guideline pooled it.

  1. Electronic health record data quality assessment and tools: a systematic review.Journal of the American Medical Informatics Association : JAMIA · 2023
    Pooled it
  2. Albuminuria Changes as a surrogate endpoint inmedRxiv : the preprint server for health sciences · 2026
    Article
  3. Article
  4. Article
  5. Article
  6. Article
  7. Article
  8. Article
  9. Article
  10. Article
  11. Article
  12. Article
  13. Article
  14. Hospital and Patient Factors Affecting Veterans' Hospital Choice.Medical care research and review : MCRR · 2024
    Article
  15. Article
  16. Article
  17. Lifelong Association of Disorders Related to Military Trauma with Subsequent Parkinson's Disease.Movement disorders : official journal of the Movement Disorder Society · 2023
    Article
  18. Article
  19. Article
  20. Article
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

10 authors.

Kristine E LynchVA Salt Lake City Health Care System, Salt Lake City, Utah, United States.
Stephen A DeppenVanderbilt University Medical Center, Nashville, Tennessee, United States.
Scott L DuVallVA Salt Lake City Health Care System, Salt Lake City, Utah, United States.
Benjamin ViernesVA Salt Lake City Health Care System, Salt Lake City, Utah, United States.
Aize CaoVanderbilt University Medical Center, Nashville, Tennessee, United States.
Daniel ParkTennessee Valley Healthcare System, Nashville, Tennessee, United States.
Elizabeth HanchrowVanderbilt University Medical Center, Nashville, Tennessee, United States.
Kushan HewaVanderbilt University Medical Center, Nashville, Tennessee, United States.
Peter GreavesVanderbilt University Medical Center, Nashville, Tennessee, United States.
Michael E MathenyVanderbilt University Medical Center, Nashville, Tennessee, United States.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

backgroundThe development and adoption of health care common data models (CDMs) has addressed some of the logistical challenges of performing research on data generated from disparate health care systems by standardizing data representations and leveraging standardized terminology to express clinical information consistently. However, transforming a data system into a CDM is not a trivial task, and maintaining an operational, enterprise capable CDM that is incrementally updated within a data warehouse is challenging.

objectivesTo develop a quality assurance (QA) process and code base to accompany our incremental transformation of the Department of Veterans Affairs Corporate Data Warehouse health care database into the Observational Medical Outcomes Partnership (OMOP) CDM to prevent incremental load errors.

methodsWe designed and implemented a multistage QA) approach centered on completeness, value conformance, and relational conformance data-quality elements. For each element we describe key incremental load challenges, our extract, transform, and load (ETL) solution of data to overcome those challenges, and potential impacts of incremental load failure.

resultsCompleteness and value conformance data-quality elements are most affected by incremental changes to the CDW, while updates to source identifiers impact relational conformance. ETL failures surrounding these elements lead to incomplete and inaccurate capture of clinical concepts as well as data fragmentation across patients, providers, and locations.

conclusionDevelopment of robust QA processes supporting accurate transformation of OMOP and other CDMs from source data is still in evolution, and opportunities exist to extend the existing QA framework and tools used for incremental ETL QA processes.

Indexed as

Models, StatisticalQuality Assurance, Health CareDelivery of Health CareElectronic Health Records

Identifiers

PMID31645076
PMCPMC6811349

What OpenQuestion holds

Textmetadata
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.