File:Fig1 Kapoor JofAppCliMedPhys2023 24-10.jpg

Figure 1. Overview of the data pipeline to gather clinical data into the radiation oncology clinical data warehouse (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-site-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-CDW's 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.

Kapoor, Rishabh; Sleeman IV, William C.; Ghosh, Preetam; Palta, Jatinder (2023). "Infrastructure tools to support an effective radiation oncology learning health system". Journal of Applied Clinical Medical Physics 24 (10): e14127. doi:10.1002/acm2.14127. 

2023

Kapoor, Rishabh; Sleeman IV, William C.; Ghosh, Preetam; Palta, Jatinder

Creative Commons Attribution 4.0 International