Development of SQL-based reporting tools and its application in radiotherapy workflow quality management
10.13491/j.issn.1004-714X.2021.03.011
- VernacularTitle:基于SQL的报表系统开发及其在放疗流程质控中的应用
- Author:
Jie NI
1
;
Juying ZHOU
1
;
Wei ZHAN
1
;
Jian GUO
1
;
Long CHEN
1
;
Guanghui GAN
1
;
Yueliang XU
1
;
Yiqiu LI
1
Author Information
1. Department of Radiation Oncology, First Affiliated Hospital of Soochow University, Suzhou 215006 China.
- Publication Type:DiagnosisandTreatment/OriginalArticles
- Keywords:
Radiotherapy;
Process Quality Control;
Information Management
- From:
Chinese Journal of Radiological Health
2021;30(3):309-314
- CountryChina
- Language:Chinese
-
Abstract:
Objective To effectively use the clinical data generated in daily operation and to realize information networking based on the existing resources of radiotherapy department. To improve quality management efficiency in radiotherapy process. Methods The radiotherapy process and required documents were analyzed. The reporting tool Microsoft Report Builder, which is based on SQL database, was applied to design the patient documents by extracting and analyzing a large number of data generated by Aria, the existing network of our radiotherapy department. PDCA Tools was used to analyze the weak links in the process. Reports with quantitative indices have been designed according to corresponding countermeasures, so as to improve quality control level of the process. Results More than one thousand patients were treated in our department since 2020. All patient documents of radiotherapy can be archived and inquired online after registration only once. 13 daily statistical reports, 5 quarters and 3 annual reports were scheduled according to practical demands. The waiting time before radiotherapy was shortened from 16.2 days to 14.8 days after operating the reporting system 3 months later. The staff could master the treatment progress of patients easily and patients who interrupted the treatment were found in time. Conclusion The reporting tools can realize patient information extraction and networked management effectively in radiotherapy process. Staff efficiency of personnel work and communication was improved. The resource allocation was optimized according to the report data in real time, improving the efficiency and quality of radiotherapy. This method is generally applicable and practical to radiotherapy department.
