基于SQL的三级公立医院绩效考核手术指标统计

Surgical index statistics based on SQL in performance evaluation of the tertiary public hospitals

目的分析三级公立医院绩效考核手术指标含义,利用数据库查询语句实现指标统计,为从事医院统计工作的同仁提供参考。方法对部分病案首页手术指标进行解释分析,在SQL中完成指标统计,并分析本文统计结果与绩效考核平台结果的差异。结果2种统计方法的指标结果仅Ⅰ类切口感染率存在较小差异,可能由于国家平台的数据清洗、参数校正的因素造成差异。结论医院统计工作者可以将本文的统计方法和SQL语言运用到实际工作中。SQL语言是新时代大数据查询统计的必备工具,值得学习和推广使用。

Objective To analyze the meaning of surgical indicators of performance appraisal workers in tertiary public hospitals,use database query statements to achieve indicator statistics,and provide reference for colleagues engaged in hospital statistics.Methods The operation indexes of the first page of some medical records were explained and analyzed.The index statistics were completed in SQL.The difference was analyzed between the statistical results of this paper and the results of the performance evaluation platform.Results The results of the two statistical methods showed a small difference in the infection rate of Class I incisions,possibly due to factors such as data cleaning and parameter correction on national platforms.Conclusion Hospital statisticians can apply the statistical methods and SQL language in this paper to practical work.SQL language is a necessary artifact for big data query statistics in the new era,which is worth learning and promoting.