Incrementally Transforming Electronic Medical Records into the Observational Medical Outcomes Partnership Common Data Model: A Multidimensional Quality Assurance Approach
- 16 October 2019
- journal article
- research article
- Published by Georg Thieme Verlag KG in Applied Clinical Informatics
- Vol. 10 (05) , 794-803
Abstract
Background The development and adoption of health care common data models (CDMs) has addressed some of the logistical challenges of performing research on data generated from disparate health care systems by standardizing data representations and leveraging standardized terminology to express clinical information consistently. However, transforming a data system into a CDM is not a trivial task, and maintaining an operational, enterprise capable CDM that is incrementally updated within a data warehouse is challenging. Objectives To develop a quality assurance (QA) process and code base to accompany our incremental transformation of the Department of Veterans Affairs Corporate Data Warehouse health care database into the Observational Medical Outcomes Partnership (OMOP) CDM to prevent incremental load errors. Methods We designed and implemented a multistage QA) approach centered on completeness, value conformance, and relational conformance data-quality elements. For each element we describe key incremental load challenges, our extract, transform, and load (ETL) solution of data to overcome those challenges, and potential impacts of incremental load failure. Results Completeness and value conformance data-quality elements are most affected by incremental changes to the CDW, while updates to source identifiers impact relational conformance. ETL failures surrounding these elements lead to incomplete and inaccurate capture of clinical concepts as well as data fragmentation across patients, providers, and locations. Conclusion Development of robust QA processes supporting accurate transformation of OMOP and other CDMs from source data is still in evolution, and opportunities exist to extend the existing QA framework and tools used for incremental ETL QA processes.Keywords
This publication has 16 references indexed in Scilit:
- Data model harmonization for the All Of Us Research Program: Transforming i2b2 data into the OMOP common data modelPLOS ONE, 2019
- Towards Implementation of OMOP in a German University Hospital ConsortiumApplied Clinical Informatics, 2018
- A Data Quality Assessment Guideline for Electronic Health Record Data ReuseeGEMs (Generating Evidence & Methods to improve patient outcomes), 2017
- A Harmonized Data Quality Assessment Terminology and Framework for the Secondary Use of Electronic Health Record DataeGEMs (Generating Evidence & Methods to improve patient outcomes), 2016
- Conversion and Data Quality Assessment of Electronic Health Record Data at a Korean Tertiary Teaching Hospital to a Common Data Model for Distributed Network ResearchHealthcare Informatics Research, 2016
- Transparent Reporting of Data Quality in Distributed Data NetworkseGEMs (Generating Evidence & Methods to improve patient outcomes), 2015
- Feasibility and utility of applications of the common data model to multiple, disparate observational health databasesJournal of the American Medical Informatics Association, 2015
- Creating a Common Data Model for Comparative Effectiveness with the Observational Medical Outcomes PartnershipApplied Clinical Informatics, 2015
- Transforming the Premier Perspective® hospital database to the OMOP Common Data ModeleGEMs (Generating Evidence & Methods to improve patient outcomes), 2014
- Fidelity Assessment of a Clinical Practice Research Datalink Conversion to the OMOP Common Data ModelDrug Safety, 2014