Dukyong Yoon1, Eun Kyoung Ahn2, Man Young Park3, Soo Yeon Cho4, Patrick Ryan5, Martijn J Schuemie5, Dahye Shin4, Hojun Park4, Rae Woong Park1. 1. Department of Biomedical Informatics, Ajou University School of Medicine, Suwon, Korea.; Observational Health Data Sciences and Informatics, New York, NY, USA. 2. Observational Health Data Sciences and Informatics, New York, NY, USA.; Department of Nursing Science, Dongyang University, Yeongju, Korea. 3. Observational Health Data Sciences and Informatics, New York, NY, USA.; Mibyeong Research Center, Korea Institute of Oriental Medicine, Daejeon, Korea. 4. Department of Biomedical Informatics, Ajou University School of Medicine, Suwon, Korea. 5. Observational Health Data Sciences and Informatics, New York, NY, USA.; Global Epidemiology, Janssen Research and Development LLC, Titusville, NJ, USA.
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.
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.
Entities:
Keywords:
Clinical Coding; Common Data Model; Electronic Health Records; Epidemiologic Methods; Observational Health Data Sciences and Informatics (OHDSI)
Authors: Lesley H Curtis; Mark G Weiner; Denise M Boudreau; William O Cooper; Gregory W Daniel; Vinit P Nair; Marsha A Raebel; Nicolas U Beaulieu; Robert Rosofsky; Tiffany S Woodworth; Jeffrey S Brown Journal: Pharmacoepidemiol Drug Saf Date: 2012-01 Impact factor: 2.890
Authors: Peter B Lockhart; Ann F Bolger; Panos N Papapanou; Olusegun Osinbowale; Maurizio Trevisan; Matthew E Levison; Kathryn A Taubert; Jane W Newburger; Heather L Gornik; Michael H Gewitz; Walter R Wilson; Sidney C Smith; Larry M Baddour Journal: Circulation Date: 2012-04-18 Impact factor: 29.690
Authors: Preciosa M Coloma; Martijn J Schuemie; Gianluca Trifirò; Rosa Gini; Ron Herings; Julia Hippisley-Cox; Giampiero Mazzaglia; Carlo Giaquinto; Giovanni Corrao; Lars Pedersen; Johan van der Lei; Miriam Sturkenboom Journal: Pharmacoepidemiol Drug Saf Date: 2010-11-08 Impact factor: 2.890
Authors: Richard Platt; Marcus Wilson; K Arnold Chan; Joshua S Benner; Janet Marchibroda; Mark McClellan Journal: N Engl J Med Date: 2009-07-27 Impact factor: 91.245
Authors: David Madigan; Patrick B Ryan; Martijn Schuemie; Paul E Stang; J Marc Overhage; Abraham G Hartzema; Marc A Suchard; William DuMouchel; Jesse A Berlin Journal: Am J Epidemiol Date: 2013-05-05 Impact factor: 4.897
Authors: Richard D Boyce; Patrick B Ryan; G Niklas Norén; Martijn J Schuemie; Christian Reich; Jon Duke; Nicholas P Tatonetti; Gianluca Trifirò; Rave Harpaz; J Marc Overhage; Abraham G Hartzema; Mark Khayter; Erica A Voss; Christophe G Lambert; Vojtech Huser; Michel Dumontier Journal: Drug Saf Date: 2014-08 Impact factor: 5.606
Authors: Kristine E Lynch; Stephen A Deppen; Scott L DuVall; Benjamin Viernes; Aize Cao; Daniel Park; Elizabeth Hanchrow; Kushan Hewa; Peter Greaves; Michael E Matheny Journal: Appl Clin Inform Date: 2019-10-23 Impact factor: 2.342
Authors: Byungkon Kang; Jisang Yoon; Ha Young Kim; Sung Jin Jo; Yourim Lee; Hye Jin Kam Journal: J Am Med Inform Assoc Date: 2021-07-14 Impact factor: 4.497
Authors: C Maier; L Lang; H Storf; P Vormstein; R Bieber; J Bernarding; T Herrmann; C Haverkamp; P Horki; J Laufer; F Berger; G Höning; H W Fritsch; J Schüttler; T Ganslandt; H U Prokosch; M Sedlmayr Journal: Appl Clin Inform Date: 2018-01-24 Impact factor: 2.342