Fig. 2
From: Combining structured and unstructured data in EMRs to create clinically-defined EMR-derived cohorts
Visual representation of data tables extracted from Cerner Millenium EMR systems. Cerner EMR systems were extracted as data tables which are linked by encounter key. Data tables were linked by encounter key and include information about encounters, diagnoses (ICD-10 and SNOMED CT), pathology, forms (e.g. ED triage assessments, medication forms, discharge letters), notes (e.g. progress notes) and many more. Encounter level information were further linked to person level information by person key and included patient medical history and social history. The size of the raw file associated with each table is shown next to the table name. The data tables are listed in order of file size with the biggest files related to free-text information and scanned ECG images. The figure represents data extracted for a single 3 month time period (1/4/17–30/6/17)