Evidence map›Paper›PMID 42609725›Full record

ArticleFrontiers in digital health2026

Harmonizing patient health data into the OMOP common data model: a case study using tuberculosis data from Douala General Hospital, Cameroon.

Brenda Mbouamba Yankam, Fankoua Tchaptchet Luc Baudoin, François Anicet Onana Akoa, Pauline Andeso, Steve Bicko Cygu, Samuel Iddi, Michael Ochola, Tathagata Bhattacharjee, Mbele Onana Charles Lebon, Miranda Barasa and 2 more

Abstract read
In one paragraph

Article in Frontiers in digital health, 2026. 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

12 authors.

Brenda Mbouamba YankamData Science Without Borders Project, Douala General Hospital, Douala, Cameroon.
Fankoua Tchaptchet Luc BaudoinData Science Without Borders Project, Douala General Hospital, Douala, Cameroon.
François Anicet Onana AkoaData Science Without Borders Project, Douala General Hospital, Douala, Cameroon.
Pauline AndesoAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Steve Bicko CyguAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Samuel IddiAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Michael OcholaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Tathagata BhattacharjeeDepartment of Population Health, Faculty of Epidemiology and Population Health, London School of Hygiene and Tropical Medicine, University of London, London, United Kingdom.
Mbele Onana Charles LebonInternal Medicine Department, Douala General Hospital, Douala, Cameroon.
Miranda BarasaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Agnes KiraggaAfrican Population and Health Research Center (APHRC), Nairobi, Kenya.
Bertrand Hugo Mbatchou NgahaneData Science Without Borders Project, Douala General Hospital, Douala, Cameroon.

Funding

Wellcome Trust
6 · The paper itself

Abstract

Introduction: Douala General Hospital is a tertiary healthcare facility in Cameroon that serves thousands of patients annually. Despite maintaining extensive patient records with potential for public health research, most data remain paper-based, limiting accessibility, reuse, and interoperability. In departments such as pulmonology, patient information is stored in heterogeneous, non-standardized formats, constraining its use for clinical research, care management, and decision-making. To address these challenges, we implemented a complete Extract, Transform, and Load (ETL) pipeline aligned with the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) Version 5.4. Objective: This study aimed to harmonise and integrate tuberculosis (TB) patient data into the OMOP CDM to improve data quality, interoperability, and reusability for research and clinical monitoring. Methods: A retrospective TB dataset covering 2009-2022 was digitized from paper records and included 2,426 patient records with 82 variables. Data profiling was performed using WhiteRabbit, mapping with Rabbit-in-a-Hat, and vocabulary alignment using Usagi and ATHENA. Transformed data were loaded into a PostgreSQL OMOP CDM database. Data quality was evaluated using Achilles and the Data Quality Dashboard (DQD), while ATLAS supported visualization and analytical exploration. Results: Of 2,374 DQD checks executed, 2,354 passed, and 42 failed, yielding a 99% overall pass rate. Many checks that passed were not applicable to this TB-specific dataset, and all applicable checks demonstrated high data quality after iterative ETL refinement. Most issues were minor and resolved during refinement. Demographically, 55.6% of patients were male, with ages ranging from 15 to 95 years, predominantly between 30 and 40 years. Common conditions included extrapulmonary TB, fever, cough, and chest pain. Most patients contributed one condition and one observation record, reflecting the dataset's cross-sectional nature. Conclusion: Harmonising TB data into the OMOP CDM was feasible and successful, demonstrating that standardized research datasets can be generated in resource-limited settings. This approach offers a scalable model for broader health data standardisation efforts in Cameroon and similar contexts.

Indexed as

data harmonizationETLinteroperabilityOHDSIOMOP CDMtuberculosis

Identifiers

PMID42609725
PMCPMC13479808

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.