Dataset Information

Conversion and Data Quality Assessment of Electronic Health Record Data at a Korean Tertiary Teaching Hospital to a Common Data Model for Distributed Network Research.

ABSTRACT:

Objectives

A distributed research network (DRN) has the advantages of improved statistical power, and it can reveal more significant relationships by increasing sample size. However, differences in data structure constitute a major barrier to integrating data among DRN partners. We describe our experience converting Electronic Health Records (EHR) to the Observational Health Data Sciences and Informatics (OHDSI) Common Data Model (CDM).

Methods

We transformed the EHR of a hospital into Observational Medical Outcomes Partnership (OMOP) CDM ver. 4.0 used in OHDSI. All EHR codes were mapped and converted into the standard vocabulary of the CDM. All data required by the CDM were extracted, transformed, and loaded (ETL) into the CDM structure. To validate and improve the quality of the transformed dataset, the open-source data characterization program ACHILLES was run on the converted data.

Results

Patient, drug, condition, procedure, and visit data from 2.07 million patients who visited the subject hospital from July 1994 to November 2014 were transformed into the CDM. The transformed dataset was named the AUSOM. ACHILLES revealed 36 errors and 13 warnings in the AUSOM. We reviewed and corrected 28 errors. The summarized results of the AUSOM processed with ACHILLES are available at http://ami.ajou.ac.kr:8080/.

Conclusions

We successfully converted our EHRs to a CDM and were able to participate as a data partner in an international DRN. Converting local records in this manner will provide various opportunities for researchers and data holders.

SUBMITTER: Yoon D

PROVIDER: S-EPMC4756059 | biostudies-literature | 2016 Jan

REPOSITORIES: biostudies-literature

ACCESS DATA

Publications

Conversion and Data Quality Assessment of Electronic Health Record Data at a Korean Tertiary Teaching Hospital to a Common Data Model for Distributed Network Research.

Yoon Dukyong D Ahn Eun Kyoung EK Park Man Young MY Cho Soo Yeon SY Ryan Patrick P Schuemie Martijn J MJ Shin Dahye D Park Hojun H Park Rae Woong RW

Healthcare informatics research 20160131 1

<h4>Objectives</h4>A distributed research network (DRN) has the advantages of improved statistical power, and it can reveal more significant relationships by increasing sample size. However, differences in data structure constitute a major barrier to integrating data among DRN partners. We describe our experience converting Electronic Health Records (EHR) to the Observational Health Data Sciences and Informatics (OHDSI) Common Data Model (CDM).<h4>Methods</h4>We transformed the EHR of a hospital ...[more]

PMID: 26893951

Similar Datasets

Project description:Background and aims: Medication usage varies according to prescribing behavior, professional recommendations, and the introduction of new drugs. Local surveillance of medication usage may be useful for understanding and comparing prescribing practices by healthcare providers, particularly in countries such as Australia that are in the process of enhancing nationwide data linkage programs. We sought to investigate the utility of electronic hospital admission data to investigate local trends in medication use, to determine similarities and differences with other Australian studies, and to identify areas for targeted interventions. Methods: We performed a retrospective longitudinal analysis using combined data from a hospital admissions administrative dataset from a large tertiary teaching hospital in Adelaide, South Australia and a hospital administrative database documenting medication usage matched for the same set of patients. All adult admissions over a 12-year period, between 1 January 2007 and 31st December 2018, were included in the study population. Medications were categorized into 21 pre-defined drug classes of interest according to the ATC code list 2021. Results: Of the 692,522 total admissions, 300,498 (43.4%) had at least one recorded medication. The overall mean number of medications for patients that were medicated increased steadily from a mean (SD) of 5.93 (4.04) in 2007 to 7.21 (4.98) in 2018. Results varied considerably between age groups, with the older groups increasing more rapidly. Increased medication usage was partly due to increased case-complexity with the mean (SD) Charlson comorbidity index increasing from 0.97 (1.66) in 2007-to-2012 to 1.17 (1.72) in 2013-to-2018 for medicated patients. Of the 21 medication classes, 15 increased (p < 0.005), including antithrombotic agents; OR = 1.18 [1.16-1.21], proton pump inhibitors; OR = 1.14 [1.12-1.17], statins; OR = 1.12; [1.09-1.14], and renin-angiotensin system agents; OR = 1.06 [1.04-1.08], whilst 3 decreased (p < 0.005) including anti-inflammatory drugs (OR = 0.55; 99.5% CI = 0.53-0.58), cardiac glycosides (OR = 0.81; 99.5% CI = 0.78-0.86) and opioids (OR = 0.82; 99.5% CI = 0.79-0.83). The mean number of medications for all admissions increased between 2007 and 2011 and then declined until 2018 for each age group, except for the 18-to-35-year-olds. Conclusion: Increased medication use occurred in most age groups between 2007 and 2011 before declining slightly even after accounting for increased comorbidity burden. The use of electronic hospital admission data can assist with monitoring local medication trends and the effects of initiatives to enhance the quality use of medicines in Australia.

Project description:Electronic health records (EHRs) have been successfully used in data science and machine learning projects. However, most of these data are collected for clinical use rather than for retrospective analysis. This means that researchers typically face many different issues when attempting to access and prepare the data for secondary use. We aimed to investigate how raw EHRs can be accessed and prepared in retrospective data science projects in a disciplined, effective, and efficient way. We report our experience and findings from a large-scale data science project analyzing routinely acquired retrospective data from the Kepler University Hospital in Linz, Austria. The project involved data collection from more than 150,000 patients over a period of 10 years. It included diverse data modalities, such as static demographic data, irregularly acquired laboratory test results, regularly sampled vital signs, and high-frequency physiological waveform signals. Raw medical data can be corrupted in many unexpected ways that demand thorough manual inspection and highly individualized data cleaning solutions. We present a general data preparation workflow, which was shaped in the course of our project and consists of the following 7 steps: obtain a rough overview of the available EHR data, define clinically meaningful labels for supervised learning, extract relevant data from the hospital's data warehouses, match data extracted from different sources, deidentify them, detect errors and inconsistencies therein through a careful exploratory analysis, and implement a suitable data processing pipeline in actual code. Only few of the data preparation issues encountered in our project were addressed by generic medical data preprocessing tools that have been proposed recently. Instead, highly individualized solutions for the specific data used in one's own research seem inevitable. We believe that the proposed workflow can serve as a guidance for practitioners, helping them to identify and address potential problems early and avoid some common pitfalls.

Project description:BackgroundPrescribing error represent a significant source of preventable harm to patients. Prescribing errors at discharge, including omission of pre-admission medications (PAM), are particularly harmful as they frequently propagate following discharge. This study assesses the impact of an educational intervention and introduction of an electronic patient record (EPR) in the same centre on omission of PAM at discharge using a pragmatic design. A survey of newly qualified doctors is used to contextualise findings.MethodsDischarge prescriptions and discharge summaries were reviewed at discharge, and compared to admission medicine lists, using a paper-based chart system. Discrepancies were noted, using Health Information and Quality Authority guidelines for discharge prescribing. An educational intervention was conducted. Further review of discharge prescriptions and discharge summaries took place. Following introduction of an EPR, review of discharge summaries and discharge prescriptions was repeated. A survey was administered to recently qualified doctors (interns), and analysed using descriptive statistics and thematic analysis.ResultsOmission of PAM as prescribed or discontinued items at discharge occurs frequently. An educational intervention did not significantly change prescribing error rates (U = 1255.5, p = 0.206). EPR introduction did significantly reduce omission of PAM on discharge prescribing (U = 694, p < 0.001), however there was also a reduction in the rate of deliberate discontinuation of PAM at discharge (U = 1237.5, p = 0.007). Survey results demonstrated that multiple sources are required to develop a discharge prescription. Time pressure, access to documentation and lack of admission medicine reconciliation are frequently cited causes of discharge prescribing error.ConclusionThis study verified passive educational interventions alone do not improve discharge prescribing. Introduction of EPR improved discharge prescribing, but negatively impacted deliberate discontinuation of PAM at discharge. This is attributable to reduced access to key sources of information used in formulating discharge prescriptions, and separation of the discontinuation function from the prescribing function on the EPR discharge application.

Project description:BackgroundThe anonymization of Common Data Model (CDM)-converted EHR data is essential to ensure the data privacy in the use of harmonized health care data. However, applying data anonymization techniques can significantly affect many properties of the resulting data sets and thus biases research results. Few studies have reviewed these applications with a reflection of approaches to manage data utility and quality concerns in the context of CDM-formatted health care data.ObjectiveOur intended scoping review aims to identify and describe (1) how formal anonymization methods are carried out with CDM-converted health care data, (2) how data quality and utility concerns are considered, and (3) how the various CDMs differ in terms of their suitability for recording anonymized data.MethodsThe planned scoping review is based on the framework of Arksey and O'Malley. By using this, only articles published in English will be included. The retrieval of literature items should be based on a literature search string combining keywords related to data anonymization, CDM standards, and data quality assessment. The proposed literature search query should be validated by a librarian, accompanied by manual searches to include further informal sources. Eligible articles will first undergo a deduplication step, followed by the screening of titles. Second, a full-text reading will allow the 2 reviewers involved to reach the final decision about article selection, while a domain expert will support the resolution of citation selection conflicts. Additionally, key information will be extracted, categorized, summarized, and analyzed by using a proposed template into an iterative process. Tabular and graphical analyses should be addressed in alignment with the PRISMA-ScR (Preferred Reporting Items for Systematic Reviews and Meta-Analyses Extension for Scoping Reviews) checklist. We also performed some tentative searches on Web of Science for estimating the feasibility of reaching eligible articles.ResultsTentative searches on Web of Science resulted in 507 nonduplicated matches, suggesting the availability of (potential) relevant articles. Further analysis and selection steps will allow us to derive a final literature set. Furthermore, the completion of this scoping review study is expected by the end of the fourth quarter of 2023.ConclusionsOutlining the approaches of applying formal anonymization methods on CDM-formatted health care data while taking into account data quality and utility concerns should provide useful insights to understand the existing approaches and future research direction based on identified gaps. This protocol describes a schedule to perform a scoping review, which should support the conduction of follow-up investigations.International registered report identifier (irrid)PRR1-10.2196/46471.

Dataset Information

Conversion and Data Quality Assessment of Electronic Health Record Data at a Korean Tertiary Teaching Hospital to a Common Data Model for Distributed Network Research.

Objectives

Methods

Results

Conclusions

Publications

Conversion and Data Quality Assessment of Electronic Health Record Data at a Korean Tertiary Teaching Hospital to a Common Data Model for Distributed Network Research.

Similar Datasets

OmicsDI is part of the ELIXIR infrastructure

Tweets