Hostname: page-component-8448b6f56d-c47g7 Total loading time: 0 Render date: 2024-04-23T19:02:03.260Z Has data issue: false hasContentIssue false

4521 Collecting, Interpreting and Utilizing Retrospective Clinical Data from Data Warehouses

Published online by Cambridge University Press:  29 July 2020

Brandon Joseph Sonn
Affiliation:
University of Colorado at Denver
Andrew Monte
Affiliation:
University of Colorado at Denver
Rights & Permissions [Opens in a new window]

Abstract

Core share and HTML view are not available for this content. However, as you have access to this content, a full PDF is available via the ‘Save PDF’ action button.

OBJECTIVES/GOALS: Utilizing clinical electronic health record (eHR) data pulled en masse from data warehouses provides unique challenges when applying it to retrospective studies. Use of this data in conjunction with metabolomic and genomic results to predict response to lisinopril or ondansetron has been completed. METHODS/STUDY POPULATION: Study population consists of >2000 subjects recruited from the Emergency Medicine Specimen Bank at University of Colorado Denver (UCD). All patients presenting to the emergency department are approached to participate which significantly increases demographic diversity of our study populations. Clinical data is pulled from Health Data Compass (data warehouse at UCD that collects all electronic health record (EHR) data to be able to deliver de-identified). Effectiveness of lisinopril and ondansetron were investigated using metabolomic data collected via ultra-high performance liquid chromatography mass spectrometry and genomic data from Illumina chip technology to find relevant correlations. RESULTS/ANTICIPATED RESULTS: Obtaining retrospective clinical data from data warehouses comes with significant challenges to be addressed. Verifying all clinical variables from patient EHRs is a crucial step that requires extensive quality control steps. As well, ensuring data validity, appropriateness of data points pulled as relate to the study criteria and identifying alternate EHR data points is needed. Chart review is a critical step necessary to surmount these challenges. Additionally, use of retrospective EHR data often necessitates the development of novel definitions of clinical effectiveness that can be abstracted from the EHR– such as how to determine decrease in nausea without a visual analogue scale. DISCUSSION/SIGNIFICANCE OF IMPACT: Utilizing data warehouses to deliver EHR data provides a valuable tool for completing retrospective precision medicine projects. The validation of definitions for clinical outcomes identifiable retrospectively are necessary and provide novel guidance for future studies.

Type
Data Science/Biostatistics/Informatics
Creative Commons
Creative Common License - CCCreative Common License - BY
This is an Open Access article, distributed under the terms of the Creative Commons Attribution licence (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted re-use, distribution, and reproduction in any medium, provided the original work is properly cited.
Copyright
© The Association for Clinical and Translational Science 2020