Development of SQL-based reporting tools and its application in radiotherapy workflow quality management

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. 摘要： 目的 有效利用放疗科日常运行中产生的临床数据, 基于科室已有网络资源实现放疗信息无纸化, 提高放疗流 程质控水平。 方法 分析科室放疗流程及所需文档, 运用基于 SQL 数据库的报表工具 Report Builder, 对放疗科已有 网络 Aria 产生的大量数据进行提取和分析, 开发报表实现患者现有放疗文档的电子化;运用 PDCA 的方法分析流程 中存在的薄弱环节, 提出对策并设计相应报表量化指标,从而提高流程质控水平。 结果 自 2020 年全面实施以来, 科 室实施放疗两千余人次, 患者放疗信息一次登记后全部文档实现网络存档和查询。根据实际工作需求制定了 13 个日 常统计报表、5 个季度和 3 个年度统计报表, 通过报表统计使用报表前后 3 个月的放疗前等待时间由 16.2 d 缩短至 14.8 d, 工作人员能够掌握患者治疗进度, 及时发现 12 例中断治疗的患者。 结论 通过报表工具的信息提取能够实现 放疗全流程信息网络化和患者放疗数据电子化, 提高了人员工作效率和沟通效率,科室能够根据报表数据实时优化资 源配置, 提高放疗的效率和质量。该方法具有普适性和实用性。