Dataset Information

Transformation of Electronic Health Records and Questionnaire Data to OMOP CDM: A Feasibility Study Using SG_T2DM Dataset.

ABSTRACT:

Background

Diabetes mellitus (DM) is an important public health concern in Singapore and places a massive burden on health care spending. Tackling chronic diseases such as DM requires innovative strategies to integrate patients' data from diverse sources and use scientific discovery to inform clinical practice that can help better manage the disease. The Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) was chosen as the framework for integrating data with disparate formats.

Objective

The study aimed to evaluate the feasibility of converting Singapore based data source, comprising of electronic health records (EHR), cognitive and depression assessment questionnaire data to OMOP CDM standard. Additionally, we also validate whether our OMOP CDM instance is fit for the purpose of research by executing a simple treatment pathways study using Atlas, a graphical user interface tool to conduct analysis on OMOP CDM data as a proof of concept.

Methods

We used de-identified EHR, cognitive, and depression assessment questionnaires data from a tertiary care hospital in Singapore to convert it to version 5.3.1 of OMOP CDM standard. We evaluate the OMOP CDM conversion by (1) assessing the mapping coverage (that is the percentage of source terms mapped to OMOP CDM standard); (2) local raw dataset versus CDM dataset analysis; and (3) Implementing Harmonized Intrinsic Data Quality Framework using an open-source R package called Data Quality Dashboard.

Results

The content coverage of OMOP CDM vocabularies is more than 90% for clinical data, but only around 11% for questionnaire data. The comparison of characteristics between source and target data returned consistent results and our transformed data did not pass 38 (1.4%) out of 2,622 quality checks.

Conclusion

Adoption of OMOP CDM at our site demonstrated that EHR data are feasible for standardization with minimal information loss, whereas challenges remain for standardizing cognitive and depression assessment questionnaire data that requires further work.

SUBMITTER: Sathappan SMK

PROVIDER: S-EPMC8357458 | biostudies-literature |

REPOSITORIES: biostudies-literature

ACCESS DATA

Similar Datasets

Project description:The current generation of sequencing technologies has led to significant advances in identifying novel disease-associated mutations and generated large amounts of data in a high-throughput manner. Such data in conjunction with clinical routine data are proven to be highly useful in deriving population-level and patient-level predictions, especially in the field of cancer precision medicine. However, data harmonization across multiple national and international clinical sites is an essential step for the assessment of events and outcomes associated with patients, which is currently not adequately addressed. The Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) is an internationally established research data repository introduced by the Observational Health Data Science and Informatics (OHDSI) community to overcome this issue. To address the needs of cancer research, the genomic vocabulary extension was introduced in 2020 to support the standardization of subsequent data analysis. In this review, we evaluate the current potential of the OMOP CDM to be applicable in cancer prediction and how comprehensively the genomic vocabulary extension of the OMOP can serve current needs of AI-based predictions. For this, we systematically screened the literature for articles that use the OMOP CDM in predictive analyses in cancer and investigated the underlying predictive models/tools. Interestingly, we found 248 articles, of which most use the OMOP for harmonizing their data, but only 5 make use of predictive algorithms on OMOP-based data and fulfill our criteria. The studies present multicentric investigations, in which the OMOP played an essential role in discovering and optimizing machine learning (ML)-based models. Ultimately, the use of the OMOP CDM leads to standardized data-driven studies for multiple clinical sites and enables a more solid basis utilizing, e.g., ML models that can be reused and combined in early prediction, diagnosis, and improvement of personalized cancer care and biomarker discovery.

Project description:ObjectiveThe large-scale collection of observational data and digital technologies could help curb the COVID-19 pandemic. However, the coexistence of multiple Common Data Models (CDMs) and the lack of data extract, transform, and load (ETL) tool between different CDMs causes potential interoperability issue between different data systems. The objective of this study is to design, develop, and evaluate an ETL tool that transforms the PCORnet CDM format data into the OMOP CDM.MethodsWe developed an open-source ETL tool to facilitate the data conversion from the PCORnet CDM and the OMOP CDM. The ETL tool was evaluated using a dataset with 1000 patients randomly selected from the PCORnet CDM at Mayo Clinic. Information loss, data mapping accuracy, and gap analysis approaches were conducted to assess the performance of the ETL tool. We designed an experiment to conduct a real-world COVID-19 surveillance task to assess the feasibility of the ETL tool. We also assessed the capacity of the ETL tool for the COVID-19 data surveillance using data collection criteria of the MN EHR Consortium COVID-19 project.ResultsAfter the ETL process, all the records of 1000 patients from 18 PCORnet CDM tables were successfully transformed into 12 OMOP CDM tables. The information loss for all the concept mapping was less than 0.61%. The string mapping process for the unit concepts lost 2.84% records. Almost all the fields in the manual mapping process achieved 0% information loss, except the specialty concept mapping. Moreover, the mapping accuracy for all the fields were 100%. The COVID-19 surveillance task collected almost the same set of cases (99.3% overlaps) from the original PCORnet CDM and target OMOP CDM separately. Finally, all the data elements for MN EHR Consortium COVID-19 project could be captured from both the PCORnet CDM and the OMOP CDM.ConclusionWe demonstrated that our ETL tool could satisfy the data conversion requirements between the PCORnet CDM and the OMOP CDM. The outcome of the work would facilitate the data retrieval, communication, sharing, and analysis between different institutions for not only COVID-19 related project, but also other real-world evidence-based observational studies.

Project description:Between 2012 and 2017, N = 2814 youth between the ages of 4 and 20 were in child protective services (CPS) custody in Hamilton County, Ohio, and placed in out-of-home care. Child welfare administrative records were extracted and linked to electronic health records for all encounters at Cincinnati Children's Hospital Medical Center, with n = 2787 (99.1%) of records successfully linked prior to de-identifying the data for research purposes. Child welfare administrative data fields in the dataset include demographics, dates of entry into and exit from protective custody and out-of-home care, reasons for entry into custody, dates of placement changes, reasons for placement changes, and types of placement (e.g., foster home, kinship home, group home, residential treatment, independent living). Electronic health records (EHR) data fields include demographics, all inpatient and outpatient encounters with medications, diagnoses, screening results, laboratory test results, flowsheet data, and problem list entries. Data have been coded to capture broader categories of health needs and encounter details, medications, and other health concerns. Due to the high representation of children in CPS custody and out-of-home care who are also represented in the EHR data, this dataset provides a comprehensive view of the medical needs and health concerns for school-aged children in CPS custody in an entire county. As a result, these data can be useful for understanding the emergence of global and specific health concerns, frequency of healthcare use, and placement stability for all youth in CPS custody in this community, accounting for variation due to other health and child welfare factors. These data are likely generalizable to other mid-sized urban communities where academic medical centers provide healthcare for children in CPS custody. De-identified data may be made available to other researchers with approved data transfer agreements between academic institutions in place.

Project description:BackgroundCommon data models (CDMs) enable data to be standardized, and facilitate data exchange, sharing, and storage, particularly when the data have been collected via distinct, heterogeneous systems. Moreover, CDMs provide tools for data quality assessment, integration into models, visualization, and analysis. The observational medical outcome partnership (OMOP) provides a CDM for organizing and standardizing databases. Common data models not only facilitate data integration but also (and especially for the OMOP model) extends the range of available statistical analyses.ObjectiveThis study aimed to evaluate the feasibility of implementing French national electronic health records in the OMOP CDM.MethodsThe OMOP's specifications were used to audit the source data, specify the transformation into the OMOP CDM, implement an extract-transform-load process to feed data from the French health care system into the OMOP CDM, and evaluate the final database.ResultsSeventeen vocabularies corresponding to the French context were added to the OMOP CDM's concepts. Three French terminologies were automatically mapped to standardized vocabularies. We loaded nine tables from the OMOP CDM's "standardized clinical data" section, and three tables from the "standardized health system data" section. Outpatient and inpatient data from 38,730 individuals were integrated. The median (interquartile range) number of outpatient and inpatient stays per patient was 160 (19-364).ConclusionOur results demonstrated that data from the French national health care system can be integrated into the OMOP CDM. One of the main challenges was the use of international OMOP concepts to annotate data recorded in a French context. The use of local terminologies was an obstacle to conceptual mapping; with the exception of an adaptation of the International Classification of Diseases 10th Revision, the French health care system does not use international terminologies. It would be interesting to extend our present findings to the 65 million people registered in the French health care system.

Project description:BackgroundHospital antimicrobial stewardship (AMS) programmes are multidisciplinary initiatives to optimize antimicrobial use. Most hospitals depend on time-consuming manual audits to monitor clinicians' prescribing. But much of the information needed could be sourced from electronic health records (EHRs).ObjectivesTo develop an informatics methodology to analyse characteristics of hospital AMS practice using routine electronic prescribing and laboratory records.MethodsFeasibility study using electronic prescribing, laboratory and clinical coding records from adult patients admitted to six specialities at Queen Elizabeth Hospital, Birmingham, UK (September 2017-August 2018). The study involved: (i) a review of AMS standards of care; (ii) their translation into concepts measurable from commonly available EHRs; and (iii) a pilot application in an EHR cohort study (n = 61679 admissions).ResultsWe developed data modelling methods to characterize antimicrobial use (antimicrobial therapy episode linkage methods, therapy table, therapy changes). Prescriptions were linked into antimicrobial therapy episodes (mean 2.4 prescriptions/episode; mean length of therapy 5.8 days), enabling several actionable findings. For example, 22% of therapy episodes for low-severity community-acquired pneumonia were congruent with prescribing guidelines, with a tendency to use broader-spectrum antibiotics. Analysis of therapy changes revealed IV to oral therapy switching was delayed by an average 3.6 days (95% CI: 3.4-3.7). Microbial cultures were performed prior to treatment initiation in just 22% of antibacterial prescriptions. The proposed methods enabled fine-grained monitoring of AMS practice down to specialities, wards and individual clinical teams by case mix, enabling more meaningful peer comparison.ConclusionsIt is feasible to use hospital EHRs to construct rapid, meaningful measures of prescribing quality with potential to support quality improvement interventions (audit/feedback to prescribers), engagement with front-line clinicians on optimizing prescribing, and AMS impact evaluation studies.