Leveraging Epic’s Native ETL Infrastructure for OMOP CDM Implementation: A Collaborative Experience

Presentation Time: 10:09 AM - 10:21 AM

Abstract Keywords: Data Transformation/ETL, Interoperability and Health Information Exchange, Data Sharing, Data Standards
Primary Track: Applications
Programmatic Theme: Clinical Informatics

The University of Texas Southwestern Medical Center (UTSW) and Texas Health Resources (THR) implemented an Observational Medical Outcomes Partnership (OMOP) common data model (CDM) that utilizes the Epic electronic health record’s (EHR) extract, transform, and load (ETL) system to enable collaborative research with other health institutions within the OHDSI network. We mapped EHR data from frequently utilized Epic Models to 25 OMOP CDM tables and transferred the data to a shared OMOP database housed within the Caboodle infrastructure using Epic’s pre-existing ETL system, minimizing the need for customization. ETL processes occur weekly at THR and daily at UTSW. OMOP CDM mapping resulted in data quality assessment values of 97% and 98% for THR and UTSW respectively. Our study established a reproduceable, collaborative pipeline using the OMOP CDM with Epic’s native ETL framework, expanding the OHDSI research network resulting in better quality and more generalizable data sets available for future research.

Speaker(s):
DuWayne Willett, MD
University of Texas Southwestern Medical Center

Author(s):
Lauren Cooper, MS - University of Texas Southwestern Medical Center; AAMIRAH VADSARIYA, RN MSN - UTSW; Mereeja Varghese; Bhavini Nayee, BS - University of Texas Southwestern Medical Center; Jessica Moon, BS - University of Texas Southwestern Medical Center; Chaitanya Katterapalli, MS - Texas Health Resources; Clark Walker, MPH - Texas Health Resources; Chris Gonzalez, LPN - Texas Health Resources; Sonam Sohal, MHSM MBA - Texas Health Resources; Christoph Lehmann, MD, FAAP, FACMI, FIAHSI - UT Southwestern; Ferdinand Velasco, MD - Texas Health Resources; Mujeeb Basit, MD, MMSc - UT Southwestern Medical Center; DuWayne Willett, MD - University of Texas Southwestern Medical Center;