{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,8,3]],"date-time":"2026-08-03T15:53:54Z","timestamp":1785772434924,"version":"3.56.0"},"reference-count":26,"publisher":"Frontiers Media SA","license":[{"start":{"date-parts":[[2026,8,3]],"date-time":"2026-08-03T00:00:00Z","timestamp":1785715200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["frontiersin.org"],"crossmark-restriction":true},"short-container-title":["Front. Digit. Health"],"abstract":"<jats:sec>\n                    <jats:title>Introduction<\/jats:title>\n                    <jats:p>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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Objective<\/jats:title>\n                    <jats:p>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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Methods<\/jats:title>\n                    <jats:p>A retrospective TB dataset covering 2009\u20132022 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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Results<\/jats:title>\n                    <jats:p>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.<\/jats:p>\n                  <\/jats:sec>\n                  <jats:sec>\n                    <jats:title>Conclusion<\/jats:title>\n                    <jats:p>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.<\/jats:p>\n                  <\/jats:sec>","DOI":"10.3389\/fdgth.2026.1828475","type":"journal-article","created":{"date-parts":[[2026,8,3]],"date-time":"2026-08-03T15:01:51Z","timestamp":1785769311000},"update-policy":"https:\/\/doi.org\/10.3389\/crossmark-policy","source":"Crossref","is-referenced-by-count":0,"title":["Harmonizing patient health data into the OMOP common data model: a case study using tuberculosis data from Douala General Hospital, Cameroon"],"prefix":"10.3389","volume":"8","author":[{"given":"Brenda","family":"Mbouamba Yankam","sequence":"first","affiliation":[{"name":"Data Science Without Borders Project, Douala General Hospital","place":["Douala, Cameroon"]},{"name":"Faculty of Mathematics, University of Bochum","place":["Bochum, Germany"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Fankoua Tchaptchet","family":"Luc Baudoin","sequence":"additional","affiliation":[{"name":"Data Science Without Borders Project, Douala General Hospital","place":["Douala, Cameroon"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Fran\u00e7ois Anicet","family":"Onana Akoa","sequence":"additional","affiliation":[{"name":"Data Science Without Borders Project, Douala General Hospital","place":["Douala, Cameroon"]},{"name":"School of Health Sciences, Catholic University of Central Africa","place":["Yaounde, Cameroon"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Pauline","family":"Andeso","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Steve Bicko","family":"Cygu","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Samuel","family":"Iddi","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]},{"name":"Department of Statistics, University of Ghana","place":["Accra, Ghana"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Michael","family":"Ochola","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tathagata","family":"Bhattacharjee","sequence":"additional","affiliation":[{"name":"Department of Population Health, Faculty of Epidemiology and Population Health, London School of Hygiene and Tropical Medicine, University of London","place":["London, United Kingdom"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mbele Onana","family":"Charles Lebon","sequence":"additional","affiliation":[{"name":"Internal Medicine Department, Douala General Hospital","place":["Douala, Cameroon"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Miranda","family":"Barasa","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Agnes","family":"Kiragga","sequence":"additional","affiliation":[{"name":"African Population and Health Research Center (APHRC)","place":["Nairobi, Kenya"]},{"name":"Infectious Diseases Institute, College of Health Sciences, Makerere University","place":["Kampala, Uganda"]}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Bertrand Hugo","family":"Mbatchou Ngahane","sequence":"additional","affiliation":[{"name":"Data Science Without Borders Project, Douala General Hospital","place":["Douala, Cameroon"]},{"name":"Faculty of Medicine and Pharmaceutical Sciences, University of Douala","place":["Douala, Cameroon"]}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1965","published-online":{"date-parts":[[2026,8,3]]},"reference":[{"key":"B1","doi-asserted-by":"publisher","first-page":"46","DOI":"10.1016\/j.ijid.2014.12.039","article-title":"Tackling the Tuberculosis epidemic in sub-saharan Africa\u2014unique opportunities arising from the second European developing countries clinical trials partnership (EDCTP) programme 2015\u20132024","volume":"32","author":"Zumla","year":"2015","journal-title":"Int J Infect Dis"},{"key":"B2","doi-asserted-by":"publisher","first-page":"1","DOI":"10.3389\/fmicb.2025.1695592\/full","article-title":"The burden of tuberculosis and drug resistance in 22 sub-saharan African countries, 1990\u20132021: a GBD 2021 analysis and progress towards WHO 2035 targets with projections to 2050","volume":"16","author":"Li","year":"2025","journal-title":"Front Microbiol"},{"key":"B3","doi-asserted-by":"publisher","first-page":"65","DOI":"10.4103\/ijmy.ijmy_219_23","article-title":"Analysis of the outcomes of Tuberculosis treatment and factors associated with successful treatment at the bamenda regional hospital: a 10-year retrospective study","volume":"13","author":"Chethkwo","year":"2024","journal-title":"Int J Mycobacteriol"},{"key":"B4","doi-asserted-by":"publisher","first-page":"171","DOI":"10.3390\/tropicalmed6040171","article-title":"Patient-Pathway analysis of Tuberculosis services in Cameroon","volume":"6","author":"Titahong","year":"2021","journal-title":"Trop Med Infect Dis"},{"key":"B5","doi-asserted-by":"publisher","first-page":"349","DOI":"10.2989\/16085906.2012.754835","article-title":"HIV-seroprevalence among pulmonary tuberculosis patients in a tertiary care hospital in douala, Cameroon","volume":"11","author":"Ngahane","year":"2012","journal-title":"Afr J AIDS Res"},{"key":"B6","doi-asserted-by":"publisher","first-page":"1","DOI":"10.3389\/jpps.2024.12302","article-title":"Real-world data: a comprehensive literature review on the barriers, challenges, and opportunities associated with their inclusion in the health technology assessment process","volume":"27","author":"Zisis","year":"2024","journal-title":"J Pharm Pharm Sci"},{"key":"B7","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1038\/s41598-023-49560-w","article-title":"Implementation of inclusion and exclusion criteria in clinical studies in OHDSI ATLAS software","volume":"13","author":"Blasini","year":"2023","journal-title":"Sci Rep"},{"key":"B8","first-page":"574","article-title":"Observational health data sciences and informatics (OHDSI): opportunities for observational researchers HHS public access","volume":"216","author":"Hripcsak","year":"2015","journal-title":"Stud Health Technol Inform"},{"key":"B9","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1038\/s41746-025-01581-7","article-title":"A scoping review of OMOP CDM adoption for cancer research using real world data","volume":"8","author":"Wang","year":"2025","journal-title":"NPJ Digit Med"},{"key":"B10","author":"Wang","year":""},{"key":"B11","first-page":"1","article-title":"2024 IEEE EMBS international conference on biomedical and health informatics (BHI)","author":"Marteau","year":""},{"key":"B12","doi-asserted-by":"publisher","first-page":"e0279641","DOI":"10.1371\/journal.pone.0279641","article-title":"Exploring the potential of OMOP common data model for process mining in healthcare","volume":"18","author":"Park","year":"2023","journal-title":"PLoS One"},{"key":"B13","doi-asserted-by":"publisher","first-page":"1423621","DOI":"10.3389\/fdgth.2025.1423621","article-title":"Harmonizing population health data into OMOP common data model: a demonstration using COVID-19 sero-surveillance data from Nairobi urban health and demographic surveillance system","volume":"7","author":"Ochola","year":"2025","journal-title":"Front Digit Health"},{"key":"B14","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1186\/s12874-021-01434-3","article-title":"Standardizing registry data to the OMOP common data model: experience from three pulmonary hypertension databases","volume":"21","author":"Biedermann","year":"2021","journal-title":"BMC Med Res Methodol"},{"key":"B15","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1093\/jamiaopen\/ooab001","article-title":"Transforming and evaluating electronic health record disease phenotyping algorithms using the OMOP common data model: a case study in heart failure","volume":"4","author":"Papez","year":"2021","journal-title":"JAMIA Open"},{"key":"B16","doi-asserted-by":"publisher","first-page":"298","DOI":"10.1186\/s13023-024-03312-9","article-title":"How to customize common data models for rare diseases: an OMOP-based implementation and lessons learned","volume":"19","author":"Ahmadi","year":"2024","journal-title":"Orphanet J Rare Dis"},{"key":"B17","doi-asserted-by":"publisher","first-page":"18","DOI":"10.13063\/2327-9214.1244","article-title":"A harmonized data quality assessment terminology and framework for the secondary use of electronic health record data","volume":"4","author":"Kahn","year":"2016","journal-title":"eGEMs"},{"key":"B18","doi-asserted-by":"publisher","first-page":"11920","DOI":"10.3390\/app112411920","article-title":"Using the data quality dashboard to improve the ehden network","volume":"11","author":"Blacketer","year":"2021","journal-title":"Appl Sci"},{"key":"B19","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1101\/2021.04.08.21255178","article-title":"Extract, transform, load framework for the conversion of health databases to OMOP","volume":"17","author":"Quiroz","year":"2021","journal-title":"PLoS One"},{"key":"B20","doi-asserted-by":"publisher","first-page":"209","DOI":"10.1093\/jamia\/ocad214","article-title":"European Health data & evidence network\u2014learnings from building out a standardized international health data network","volume":"31","author":"Voss","year":"2023","journal-title":"J Am Med Inform Assoc"},{"key":"B21","doi-asserted-by":"publisher","first-page":"1329630","DOI":"10.3389\/fdgth.2024.1329630","article-title":"INSPIRE Datahub: a pan-African integrated suite of services for harmonising longitudinal population health data using OHDSI tools","volume":"6","author":"Bhattacharjee","year":"2024","journal-title":"Front Digit Health"},{"key":"B22","doi-asserted-by":"publisher","first-page":"1116682","DOI":"10.3389\/fpubh.2023.1116682","article-title":"Enabling data sharing and utilization for African population health data using OHDSI tools with an OMOP-common data model","volume":"11","author":"Kiwuwa-Muyingo","year":"2023","journal-title":"Front Public Health"},{"key":"B23","doi-asserted-by":"publisher","first-page":"104505","DOI":"10.1016\/j.jbi.2023.104505","article-title":"Evaluation of OMOP CDM, i2b2 and ICGC ARGO for supporting data harmonization in a breast cancer use case of a multicentric European AI project","volume":"147","author":"Frid","year":"2023","journal-title":"J Biomed Inform"},{"key":"B24","doi-asserted-by":"publisher","first-page":"54","DOI":"10.1055\/s-0037-1617452","article-title":"Towards implementation of OMOP in a German university hospital consortium","volume":"9","author":"Maier","year":"2018","journal-title":"Appl Clin Inform"},{"key":"B25","doi-asserted-by":"publisher","first-page":"757","DOI":"10.1055\/s-0041-1732301","article-title":"Transformation of electronic health records and questionnaire data to OMOP CDM: a feasibility study using SG_T2DM dataset","volume":"12","author":"Sathappan","year":"2021","journal-title":"Appl Clin Inform"},{"key":"B26","year":"2023"}],"container-title":["Frontiers in Digital Health"],"original-title":[],"link":[{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdgth.2026.1828475\/full","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,8,3]],"date-time":"2026-08-03T15:01:51Z","timestamp":1785769311000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.frontiersin.org\/articles\/10.3389\/fdgth.2026.1828475\/full"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,8,3]]},"references-count":26,"alternative-id":["10.3389\/fdgth.2026.1828475"],"URL":"https:\/\/doi.org\/10.3389\/fdgth.2026.1828475","relation":{},"ISSN":["2673-253X"],"issn-type":[{"value":"2673-253X","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,8,3]]},"article-number":"1828475"}}