摘要
住院患者出院后非计划再入院属于重返类指标,是医疗质量安全监测的指标之一。利用SQL语句编写统计查询模板能解决该检索问题。SQL模板完成并验证正确后,在病案统计系统用户界面开放4个非计划再入院患者相关查询模板供病案人员直接使用。输入相应的模板开放参数即可输出查询结果。实践结果显示,利用SQL语句查询2019年1月1日-2019年3月31日非计划再入院患者为424例,31天内再入院率为1.93%。相比传统的人工检索或手工登记,既能减少人工检索的失误,也能避免手工登记的繁琐,提高了工作效率和数据质量。
The unplanned readmission of inpatients after discharge is a re-entry indicator,which is one of the indicators of medical quality and safety monitoring.Using SQL statement to write statistical query template can solve the retrieval problem.After the completion and verification of the SQL template,four query templates related to unplanned readmission patients are opened in the user interface of the medical record statistics system for the direct use of the medical record personnel.The template opens the parameters and inputs the corresponding parameters to output the query results.The results show that,from January 1 st to Manch 31 st of 2019,424 cases of unplanned readmission were queried by SQL statement,and the readmission rate within 31 days was 1.93%.Compared with the traditional manual retrieval or manual registration,it can not only reduce the mistakes of manual retrieval,but also avoid the tedious manual registration,and improve the work efficiency and data quality.
作者
陈美玲
温星来
孙小会
梁永晴
Chen Meiling;Wen Xinglai;Sun Xiaohui(Liang Yongqing,Department of Medical Statistics,Qingyuan People’s Hospital,The Sixth Affiliated Hospital of Guangzhou Medical University,Qingyuan 511518,Guangdong Province,China;不详)
出处
《中国病案》
2020年第5期36-38,共3页
Chinese Medical Record
