Abstract:Background Observational research has shown its potential to complement experimental research and clinical trials by secondary use of treatment data from hospital care processes. It can also be applied to better understand pediatric drug utilization for establishing safer drug therapy. Clinical documentation processes often limit data quality in pediatric medical records requiring data curation steps, which are mostly underestimated. Objectives The objectives of this study were to transform and curate data from a departmental electronic medical record into an observational research database. We particularly aim at identifying data quality problems, illustrating reasons for such problems and describing the systematic data curation process established to create high-quality data for observational research. Methods Data were extracted from an electronic medical record used by four wards of a German university children's hospital from April 2012 to June 2020. A four-step data preparation, mapping, and curation process was established. Data quality of the generated dataset was firstly assessed following an established 3 × 3 Data Quality Assessment guideline and secondly by comparing a sample subset of the database with an existing gold standard. Results The generated dataset consists of 770,158 medication dispensations associated with 89,955 different drug exposures from 21,285 clinical encounters. A total of 6,840 different narrative drug therapy descriptions were mapped to 1,139 standard terms for drug exposures. Regarding the quality criterion correctness, the database was consistent and had overall a high agreement with our gold standard. Conclusion Despite large amounts of freetext descriptions and contextual knowledge implicitly included in the electronic medical record, we were able to identify relevant data quality issues and to establish a semi-automated data curation process leading to a high-quality observational research database. Because of inconsistent dosage information in the original documentation this database is limited to a drug utilization database without detailed dosage information. A positive ethics vote exists for the study (Application No 561_20 BC, ethics commission of the Friedrich-Alexander-Universität chaired by Prof. Dr. med. Renke Maas). The [Supplementary Material 1] (available in online version only) is a detailed description of the thorough intra-database quality assessment. The [Supplementary Material 2] (available in online version only) is a detailed description of the thorough extra-database quality assessment. The data that support the findings of this study are available from the senior author S.E. (Sonja.eberl@uk-erlangen.de), upon reasonable request. Received: 26 April 2023 Accepted: 28 August 2023 Article published online: 07 February 2024 © 2024. The Author(s). This is an open access article published by Thieme under the terms of the Creative Commons Attribution-NonDerivative-NonCommercial License, permitting copying and reproduction so long as the original work is given appropriate credit. Contents may not be used for commercial purposes, or adapted, remixed, transformed or built upon. (https://creativecommons.org/licenses/by-nc-nd/4.0/) Georg Thieme Verlag KG Rüdigerstraße 14, 70469 Stuttgart, Germany

Creating a Medication Therapy Observational Research Database from an Electronic Medical Record: Challenges and Data Curation

A Computational Method to Quantitatively Measure Pediatric Drug Safety Using Electronic Medical Records

Feasibility analysis of conducting observational studies with the electronic health record

Development of the Swiss Database for dosing medicinal products in pediatrics

A Clinical Outcomes Data Archive for a Comprehensive Fetal Diagnosis and Treatment Center

Europe's Largest Research Infrastructure for Curated Medical Data Models with Semantic Annotations

Data Extraction and Management in Networks of Observational Health Care Databases for Scientific Research: A Comparison of EU-ADR, OMOP, Mini-Sentinel and MATRICE Strategies

Table 0; documenting the steps to go from clinical database to research dataset

Proposal for a new study design and endpoint in research on medication history taking

Participatory Design of a Medication Module in an Electronic Medical Record for Paediatric Palliative Care: A Think-Aloud Approach with Nurses and Physicians

Transforming Primary Care Data Into the Observational Medical Outcomes Partnership Common Data Model: Development and Usability Study

Next-generation study databases require FAIR, EHR-integrated, and scalable Electronic Data Capture for medical documentation and decision support

The OMOP common data model in Australian primary care data: Building a quality research ready harmonised dataset

A prospective three-step intervention study to prevent medication errors in drug handling in paediatric care

Secondary use of patient data within decentralized studies using the example of rare diseases in Germany: A data scientist's exploration of process and lessons learned

Evaluation of the quality of clinical data collection for a pan-Canadian cohort of children affected by inherited metabolic diseases: lessons learned from the Canadian Inherited Metabolic Diseases Research Network

Simplifying Multimodal Clinical Research Data Management: Introducing an Integrated and User-Friendly Database Concept

Evaluation of medication safety resources in pediatric hospitals

An Open-Source, Standard-Compliant, and Mobile Electronic Data Capture System for Medical Research (OpenEDC): Design and Evaluation Study

Automated Electronic Health Record to Electronic Data Capture Transfer in Clinical Studies in the German Health Care System: Feasibility Study and Gap Analysis

The Implementation of an Electronic Medical Record in a German Hospital and the Change in Completeness of Documentation: Longitudinal Document Analysis