Skip to main content
. 2023 Aug 25;24(10):e14127. doi: 10.1002/acm2.14127

FIGURE 1.

FIGURE 1

Overview of the data pipeline to gather clinical data into the RO‐Clinical Data Warehouse Database (RO‐CDW). As part of this pipeline, we have built HL7/FHIR interfaces between the EHR system and HINGE database to gather pertinent information from the patient's chart. These data are stored in the HINGE database and used to auto‐populate disease sites specific smart templates that depict the clinical workflow from initial consultation to follow‐up care. The providers record their clinical assessments in these templates as part of their routine clinical care. Once the templates are finalized and signed by the providers in HINGE, the data are exported in JSON format and using an ETL process, we can load the data in our RO‐Clinical Data Warehouse relational SQL database. Additionally, we use SQL stored procedures to extract, transform and load data from the Varian Aria data tables and extraction of dosimetry DVH curves to our RO‐CDW.