Original file(1,367 × 1,311 pixels, file size: 303 KB, MIME type: image/jpeg)

Summary

Description

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.

Source

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. 

Date

2023

Author

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

Permission
(Reusing this file)

Creative Commons Attribution 4.0 International

Other versions


Licensing

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current22:56, 9 May 2024Thumbnail for version as of 22:56, 9 May 20241,367 × 1,311 (303 KB)Shawndouglas (talk | contribs)