Evidence map›Paper›PMID 38058679›Full record

ArticleJAMIA open2023

Transforming Estonian health data to the Observational Medical Outcomes Partnership (OMOP) Common Data Model: lessons learned.

Marek Oja, Sirli Tamm, Kerli Mooses, Maarja Pajusalu, Harry-Anton Talvik, Anne Ott, Marianna Laht, Maria Malk, Marcus Lõo, Johannes Holm and 7 more

Abstract read
In one paragraph

Article in JAMIA open, 2023. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 27 papers.

0numbers the graph read from it
0cells of the map it votes in
27citing 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

27 citing papers in PubMed.

  1. Article
  2. Data Resource Profile: EST-Health-30.International journal of epidemiology · 2026
    Article
  3. Article
  4. Observational
  5. Article
  6. Article
  7. Article
  8. Article
  9. Article
  10. Article
  11. Article
  12. Article
  13. Article
  14. Review
  15. Article
  16. Article
  17. 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

17 authors.

Marek OjaInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.ORCID https://orcid.org/0000-0002-3650-8194
Sirli TammInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Kerli MoosesInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Maarja PajusaluInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Harry-Anton TalvikInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Anne OttInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Marianna LahtInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Maria MalkInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Marcus LõoInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Johannes HolmInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Markus HaugInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Hendrik ŠuvalovInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Dage SärgInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Jaak ViloInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.ORCID https://orcid.org/0000-0001-5604-4107
Sven LaurInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Raivo KoldeInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.
Sulev ReisbergInstitute of Computer Science, University of Tartu, 51009 Tartu, Estonia.ORCID https://orcid.org/0000-0001-6835-9632

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

Objective: To describe the reusable transformation process of electronic health records (EHR), claims, and prescriptions data into Observational Medical Outcome Partnership (OMOP) Common Data Model (CDM), together with challenges faced and solutions implemented. Materials and Methods: We used Estonian national health databases that store almost all residents' claims, prescriptions, and EHR records. To develop and demonstrate the transformation process of Estonian health data to OMOP CDM, we used a 10% random sample of the Estonian population ( Results: In total, we transformed over 100 million entries to standard concepts using standard OMOP vocabularies with the average mapping rate 95%. For conditions, observations, drugs, and measurements, the mapping rate was over 90%. In most cases, SNOMED Clinical Terms were used as the target vocabulary. Discussion: During the transformation process, we encountered several challenges, which are described in detail with concrete examples and solutions. Conclusion: For a representative 10% random sample, we successfully transferred complete records from 3 national health databases to OMOP CDM and created a reusable transformation process. Our work helps future researchers to transform linked databases into OMOP CDM more efficiently, ultimately leading to better real-world evidence.

Indexed as

EHRelectronic health recordETLmappingOMOP

Identifiers

PMID38058679
PMCPMC10697784

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.