Appl Clin Inform 2019; 10(01): 060-065
DOI: 10.1055/s-0038-1677043
Research Article
Georg Thieme Verlag KG Stuttgart · New York

Automated Generation of CONSORT Diagrams Using Relational Database Software

Teresa O'Leary
1  Department of Emergency Medicine, Yale School of Medicine, New Haven, Connecticut
2  Yale Center for Implementation Science, Yale School of Medicine, New Haven, Connecticut
,
June Weiss
1  Department of Emergency Medicine, Yale School of Medicine, New Haven, Connecticut
2  Yale Center for Implementation Science, Yale School of Medicine, New Haven, Connecticut
,
Benjamin Toll
3  Department of Public Health Sciences, Medical University of South Carolina, Charleston, South Carolina
,
Cynthia Brandt
1  Department of Emergency Medicine, Yale School of Medicine, New Haven, Connecticut
2  Yale Center for Implementation Science, Yale School of Medicine, New Haven, Connecticut
4  Department of Anesthesiology, Yale School of Medicine, New Haven, Connecticut
,
Steven L. Bernstein
1  Department of Emergency Medicine, Yale School of Medicine, New Haven, Connecticut
2  Yale Center for Implementation Science, Yale School of Medicine, New Haven, Connecticut
5  Yale Comprehensive Cancer Center, Yale School of Medicine, New Haven, Connecticut
› Author Affiliations
Funding This work was supported by National Institutes of Health and National Heart, Lung, and Blood Institute grant R18HL108788.
Further Information

Publication History

27 February 2018

28 November 2018

Publication Date:
23 January 2019 (online)

Abstract

Background Investigators conducting prospective clinical trials must report patient flow using the Consolidated Standards of Reporting Trials (CONSORT) statement. Depending on how data are collected, this can be a laborious, time-intensive process. However, because many trials enter data electronically, CONSORT diagrams may be generated in an automated fashion.

Objective Our objective was to use an off-the-shelf software to develop a technique to generate CONSORT diagrams automatically.

Methods During a recent trial, data were entered into FileMaker Pro, a commercially available software, at enrollment and three waves of follow-up. Patient-level data were coded to automatically generate CONSORT diagrams for use by the study team.

Results From August 2012 to July 2014, 1,044 participants were enrolled. CONSORT diagrams were generated weekly for study team meetings to track follow-ups at 1, 6, and 12 months, for 960 (92%), 921 (90%), and 871 (88%) participants who were contacted or deceased, respectively. Reasons for loss to follow-up were captured at each follow-up.

Conclusion CONSORT diagrams can be generated using a standard software for any trial and can facilitate data collection, project management, and reporting.

Protection of Human and Animal Subjects

This study did not involve human or animal subjects. The parent trial from which this study was conducted was performed in compliance with the World Medical Association Declaration of Helsinki on Ethical Principles for Medical Research Involving Human Subjects and was reviewed by the Human Investigation Committee of Yale University.