Journal of Clinical and Translational Science (Apr 2024)

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

  • Ernest K. Amankwah,
  • Bradley Taylor

DOI
https://doi.org/10.1017/cts.2024.90
Journal volume & issue
Vol. 8
pp. 24 – 25

Abstract

Read online

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.