Combining structured and unstructured data in EMRs to create clinically-defined EMR-derived cohorts

Abstract

Background There have been few studies describing how production EMR systems can be systematically queried to identify clinically-defined populations and limited studies utilising free-text in this process. The aim of this study is to provide a generalisable methodology for constructing clinically-defined EMR-derived patient cohorts using structured and unstructured data in EMRs. Methods Patients with possible acute coronary syndrome (ACS) were used as an exemplar. Cardiologists defined clinical criteria for patients presenting with possible ACS. These were mapped to data tables within the production EMR system creating seven inclusion criteria comprised of structured data fields (orders and investigations, procedures, scanned electrocardiogram (ECG) images, and diagnostic codes) and unstructured clinical documentation. Data were extracted from two local health districts (LHD) in Sydney, Australia. Outcome measures included examination of the relative contribution of individual inclusion criteria to the identification of eligible encounters, comparisons between inclusion criterion and evaluation of consistency of data extracts across years and LHDs. Results Among 802,742 encounters in a 5 year dataset (1/1/13–30/12/17), the presence of an ECG image (54.8% of encounters) and symptoms and keywords in clinical documentation (41.4–64.0%) were used most often to identify presentations of possible ACS. Orders and investigations (27.3%) and procedures (1.4%), were less often present for identified presentations. Relevant ICD-10/SNOMED CT codes were present for 3.7% of identified encounters. Similar trends were seen when the two LHDs were examined separately, and across years. Conclusions Clinically-defined EMR-derived cohorts combining structured and unstructured data during cohort identification is a necessary prerequisite for critical validation work required for development of real-time clinical decision support and learning health systems.

Objective risk assessment vs standard care for acute coronary syndromes—The Australian GRACE Risk tool Implementation Study (AGRIS): a process evaluation

“…These should be developed with ED/Cardiology workflow in mind [ 43 ]. The groundwork for such technologies is rapidly developing [ 44 , 45 ].…”

Clinical registries: Not yet perfect, but essential for a high‐functioning health system

“…However, the level of health service and system digital maturity varies significantly across Australia, and even among mature systems a majority of clinical data is unstructured. Governance of these datasets is invariably complex, and processes to access, clean, extract and analyse data from these systems for clinical use are usually time‐consuming and costly 15 …”

“…Governance of these datasets is invariably complex, and processes to access, clean, extract and analyse data from these systems for clinical use are usually time-consuming and costly. 15 Perhaps most importantly, clinical registries are established with strong clinician leadership, and have the trust and support of a significant proportions of clinicians. They operate at scale, frequently nationally, and enhance a community of practice and a shared understanding about the processes and outcomes in relation to specific clinical conditions.…”

College Student Retention Risk Analysis from Educational Database Using Multi-Task Multi-Modal Neural Fusion

“…(Wan et al 2014) proposed deep spatial CNN model to extract features from image-text pairs. (Tam et al 2021) presents LSTM-CNN fusion to combine clinical image and electronic health records together for predicting clinical events derived cohorts. (Wu 2021) presents utilized unstructured-structured text fusion model for predicting cognitive engagement.…”