Related Experiment Video
Updated: Feb 13, 2026

Implementation of a Real-Time Psychosis Risk Detection and Alerting System Based on Electronic Health Records using CogStack
Published on: May 15, 2020
A method to enable clinical and translational research teams with custom real-world data from electronic health
Thomas R Campion1,2,3,4, Evan T Sholle1,2, Xiaobo Fuld2
1Department of Population Health Sciences, Weill Cornell Medicine, New York, NY, USA.
Introduction:
Custom transformations of real-world data (RWD) from electronic health record (EHR) systems are necessary to define study variables describing health and disease statuses differently among physicians in multiple specialties and basic scientists from a variety of disciplines . To increase RWD use, we hypothesized that a solution supporting three workflows - discovery, collection, and analysis - using existing rather than novel tools and requiring financial commitment from investigators would scale to meet the needs of clinical and translational research teams and ensure regulatory compliance at an academic medical center.
Materials And Methods:
Weill Cornell Medicine (WCM) implemented custom research data repositories (RDRs) consisting of i2b2 for discovery, REDCap for collection, and Microsoft SQL Server for analysis. WCM subsidized the central information technology (IT) department to manage RDRs and required investigators to commit $50,000 for RDR startup and $7500 for annual maintenance.
Results:
From 2013 through 2025, WCM launched more than 17 custom RDRs for pediatrics, myeloproliferative neoplasms, obstetrics and gynecology, pulmonary and critical care, chronic kidney disease, and ophthalmology among other areas. Custom RDRs enabled academic output (e.g., publications, grants) as well as local quality improvement activities.
Discussion:
Custom RDRs facilitated delivery of fit-for-purpose data sets derived from EHR systems and other RWD sources. Over time, RDRs have evolved from an infrastructure product delivered by central IT to a data partnership between investigators and IT.
Conclusion:
Custom RDRs and data partnerships may help increase the use of RWD from EHR and other sources by clinical and translational research teams.
More Related Videos
Related Concept Videos
Data Reporting and Recording
Interdisciplinary Care: The Health Care Team-I
Physicians
The physician's primary responsibility is to diagnose illness and direct the medical or surgical treatment of the condition. The authority to admit patients to a healthcare agency or institution and practice care within that setting is granted to physicians by the healthcare agency or institution...
Interdisciplinary Care: The Health Care Team-II
Physical Therapist
A physical therapist (PT) aims to restore function or prevent additional impairment in a patient following an injury or disease. Massage, heat, cold, water, sonar waves, exercises, and electrical stimulation are some treatments used by PTs to treat...
Purpose of Health Records I
Here's a breakdown of how health records serve these purposes:
Purpose of Health Records II
Translation
Translation is the process of synthesizing proteins from the genetic information carried by messenger RNA (mRNA). Following transcription, it constitutes the final step in the expression of genes. This process is carried out by ribosomes, complexes of protein and specialized RNA molecules. Ribosomes, transfer RNA (tRNA), and other proteins produce a chain of amino acids—the polypeptide—as the end product of translation.
Translation Produces the Building Blocks of...

