Hostname: page-component-586b7cd67f-vdxz6 Total loading time: 0 Render date: 2024-11-28T05:04:12.230Z Has data issue: false hasContentIssue false

92 Honest Broker Tool to Automate Data Extraction from Clinical Research Data Warehouse

Published online by Cambridge University Press:  03 April 2024

Ernest K. Amankwah
Affiliation:
The Medical College of Wisconsin
Bradley Taylor
Affiliation:
The Medical College of Wisconsin
Rights & Permissions [Opens in a new window]

Abstract

Core share and HTML view are not available for this content. However, as you have access to this content, a full PDF is available via the ‘Save PDF’ action button.

OBJECTIVES/GOALS: To describe an Honest Broker (HB) tool and workflow integrated with the Institutional Review Board (IRB) to automate requests, approvals and delivery of both de-identified and identified data extractions from a clinical research data warehouse (CRDW). METHODS/STUDY POPULATION: The HB tool has predefined domain tables and is closely integrated IRB for quick and easy review and approval. Investigators can access patient data using query tools, barcodes from biospecimens or build a query in TriNetX and provide the patient list as an input for the HB tool. For de-identified data extraction, the required data domain tables and date ranges can be selected and submitted in the HB tool. For identified data extractions, investigators with an approved IRB protocol can enter the protocol number and the approved date range in the HB tool. This request is automatically forwarded to the IRB for review. RESULTS/ANTICIPATED RESULTS: For de-identified data extraction, an email alert is automatically sent to the investigator once the data extract is completed. For identified data extraction, if IRB approves the request, an HB is immediately notified to release the data. Data release triggers two emails to the investigator: (1) a link to an encrypted zipped file with the requested data, and (2) a password to unlock the encrypted file. If the request is denied, the IRB sends an email to the investigator with the reason for denial and options for remediation. The entire HB workflow is accomplished in a secure environment with an audit trail from the initial data request to data download by the investigator. Since the launch of the HB tool, the time from data request to delivery is approximately an hour for deidentified data and 24 hrs for identified data. DISCUSSION/SIGNIFICANCE: The HB tool has increased successful data delivery in support of publications, grant submissions, and clinical trial recruitment. Optimization of data extraction from the CRDW through automation and integration with the IRB can minimize interaction with data analysts and IRB staff, thus accelerating the conduct of clinical research.

Type
Contemporary Research Challenges
Creative Commons
Creative Common License - CCCreative Common License - BYCreative Common License - NCCreative Common License - ND
This is an Open Access article, distributed under the terms of the Creative Commons Attribution-NonCommercial-NoDerivatives licence (https://creativecommons.org/licenses/by-nc-nd/4.0/), which permits non-commercial re-use, distribution, and reproduction in any medium, provided the original work is unaltered and is properly cited. The written permission of Cambridge University Press must be obtained for commercial re-use or in order to create a derivative work.
Copyright
© The Author(s), 2024. The Association for Clinical and Translational Science