Please use this identifier to cite or link to this item: https://observatorio.fm.usp.br/handle/OPI/38961
Title: Transforming Two Decades of ePR Data to OMOP CDM for Clinical Research
Authors: LIMA, Daniel M.RODRIGUES-JR, Jose F.TRAINA, Agma J. M.PIRES, Fabio A.GUTIERREZ, Marco A.
Citation: MEDINFO 2019: HEALTH AND WELLBEING E-NETWORKS FOR ALL, v.264, p.233-237, 2019
Abstract: This paper presents the extract-transform-and-load (ETL) process from the Electronic Patient Records (ePR) at the Heart Institute (InCor) to the OMOP Common Data Model (CDM) format. We describe the initial database characterization, relational source mappings, selection filters, data transformations and patient de-identification using the open-source OHDSI tools and SQL scripts. We evaluate the resulting InCor-CDM database by recreating the same patient cohort from a previous reference study (over the original data source) and comparing the cohorts' descriptive statistics and inclusion reports. The results exhibit that up to 91% of the reference patients were retrieved by our method from the ePR through InCor-CDM, with AUC=0.938. The results indicate that the method that we employed was able to produce a new database that was both consistent with the original data and in accordance to the OMOP CDM standard.
Appears in Collections:

Comunicações em Eventos - HC/InCor
Instituto do Coração - HC/InCor

Comunicações em Eventos - LIM/65
LIM/65 - Laboratório de Investigação Médica em Bioengenharia


Files in This Item:
File Description SizeFormat 
art_LIMA_Transforming_Two_Decades_of_ePR_Data_to_OMOP_2019.PDF
  Restricted Access
publishedVersion (English)228.54 kBAdobe PDFView/Open Request a copy

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.