基于SQL的三级公立医院绩效考核指标统计与分析  

Statistics and analysis of performance appraisal indicators for tertiary public hospitals based on SQL

作　　者：陈寒杰 陈芸[2] 卢红[2] 许昌 段俊 吴世超 刁予涵 刘颜[1,2] Chen Hanjie;Chen Yun;Lu Hong;Xu Chang;Duan Jun;Wu Shichao;Diao Yuhan;Liu Yan(Medical Records&Statistics Office,Peking University Shenzhen Hospital,Shenzhen 518036,China;Intelligent Hospital Research Academy,Peking University Shenzhen Hospital,Shenzhen 518036,China)

机构地区：[1]北京大学深圳医院病案统计室,广东深圳518036 [2]北京大学深圳医院智慧研究院,广东深圳518036

出　　处：《中国医院统计》2023年第5期359-365,共7页Chinese Journal of Hospital Statistics

基　　金：深圳市“三名工程”资助项目(SZSM201812088)。

摘　　要：目的 为三级公立医院绩效考核中与病案首页相关的部分指标提供多维度、高效、高质的统计分析方法。方法 利用Microsoft SQL Server查询分析器与病案统计管理系统后台数据库进行连接,通过编写结构化查询语言(SQL)对数据进行统计分析。结果 通过执行编写好的SQL语句可快速地查询所需数据,所生成的统计结果直观、准确,操作使用简便,满足多样化的统计需求,有效地提升了数据质量,为医院的管理决策起到了重要作用。结论 应用SQL语言可有效解决医院统计工作中的难题,相较于传统的统计方法提升了工作效率和工作质量。新时代的医院统计工作者应提高工作技能、创新工作方法,更好地为医院管理提供服务。Objective To provide a multi-dimensional,efficient,and high-quality statistical analysis method for some indicators related to the first page of medical records in the performance appraisal of tertiary public hospitals.Methods Microsoft SQL Server query analyzer was used to connect with the back-end database of the medical record statistics management system,and the data could be statistically analyzed by writing structured query language(SQL).Results By executing the prepared SQL statements,the required data could be queried quickly.The generated statistical results could be intuitive,accurate,and easy to operate.It met diversified statistical needs and effectively improved the data quality,which played an essential role for hospitals to make management decisions.Conclusion The application of SQL statements can effectively solve the difficulties during statistical work in hospitals,and improve the work efficiency and work quality compared with traditional statistical methods.Hospital statisticians in the new era should improve their working skills,innovate their working methods,and provide better services for hospital management.

关 键 词：SQL 公立医院绩效考核 医院统计 病案首页 数据库 

分 类 号：R197.3[医药卫生—卫生事业管理]