Related Experiment Video
Updated: Feb 24, 2026

Implementation of a Real-Time Psychosis Risk Detection and Alerting System Based on Electronic Health Records using CogStack
Published on: May 15, 2020
LEVERAGING EPIC'S NATIVE ETL INFRASTRUCTURE FOR OMOP CDM IMPLEMENTATION: A COLLABORATIVE EXPERIENCE
Lauren N Cooper1, Aamirah Vadsariya1, Mereeja Varghese1
1University of Texas Southwestern Medical Center, Dallas, Texas, USA.
Abstract:
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 core Epic reporting tables 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.
Related Concept Videos
Documentation in Long-Term and Home Healthcare Setting
Long-Term Care Facilities
Distribution Reliability and Automation
Methods of Documentation II: POMR
Integrated Healthcare System
Nursing Clinical Information System
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:
Methods of Documentation VII: EMR

