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

doi:10.3969/j.issn.1006-5253.2023.04.001

Abstract
Figure/Table
References (0)
Related Citation (15)

Download: PDF (4131 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS) Supporting Info

Abstract 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.

Key words： SQL language performance evaluation surgical index public hospital national clinical version 2.0

Received: 03 February 2023

PACS:

Fund:

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Tang Zaili
	Zhou Wangyan
	Li Jun

Cite this article:

Tang Zaili,Zhou Wangyan,Li Jun. Surgical index statistics based on SQL in performance evaluation of the tertiary public hospitals[J]. journal1, 2023, 30(4): 241-247.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2023.04.001 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2023/V30/I4/241

［1］国家卫生健康委员会.中国卫生健康统计年鉴:2019［M］.北京:中国协和医科大学出版社,2019.

［2］OECD,WHO. Paying for Performance in Health Care: Implications for Health System Performance and Accountability［M］. Buckingham: Open University Press, 2014. DOI: 10.1787/9789264224568-en.

［3］中共中央国务院. 关于深化医药卫生体制改革的意见［A/OL］.(2009-04-30)［2022-04-15］.http://www.mof.gov.cn/zhuantihuigu/shenhuayiyaoweishengtizhigaige/zhengcefabuyiyaogaige/200904/t20090407_130316.htm.

［4］关于公立医院改革试点的指导意见［M］.北京:中国法制出版社,2010.

［5］国务院办公厅. 关于城市公立医院综合改革试点的指导意见:国办发〔2015〕38号［A/OL］. (2015-05-18)［2022-04-15］.http://www.mof.gov.cn/zhengwuxinxi/zhengcefabu/201505/t20150518_1232823.htm.

［6］国务院办公厅. 国务院办公厅关于建立现代医院管理制度的指导意见:国办发〔2017〕67号［A/OL］. (2017-07-25)［2022-04-15］.http://www.gov.cn/zhengce/content/2017-07/25/content_5213256.htm.

［7］卞城,王珩,李念念,等.国外医院绩效评价对我国的启示［J］.安徽医学,2015,36(6):755-758.DOI: 10.3969/j.issn.1000-0399.2015.06.039.

［8］国务院办公厅.国务院办公厅关于加强三级公立医院绩效考核工作的意见:国办发〔2019〕4 号［A/OL］.(2019-01-16)［2022-04-15］.http://www.gov.cn/zhengce/content/2019-01/30/content_5362266.htm.

［9］国家卫生健康委办公厅. 关于启动2019年全国三级公立医院绩效考核有关工作的通知:国卫办医函〔2019〕371号［A/OL］.(2019-04-17)［2022-04-15］.http://www.gov.cn/zhengce/zhengceku/2019-09/16/content_5430153.htm.

［10］国家卫生健康委办公厅. 国家卫生健康委办公厅关于印发国家三级公立医院绩效考核操作手册(2019版)的通知:国卫办医函〔2019〕492号［A/OL］.(2019-05-22)［2022-06-01］.http://www.nhc.gov.cn/yzygj/s3593g/201905/63feeb5dae7c4125a06d31f3600c-0bc8.shtml.

［11］国家卫生健康委办公厅.国家卫生健康委办公厅关于印发国家三级公立医院绩效考核操作手册(2022版)的通知:国卫办医函〔2022〕92号［A/OL］.(2022-04-02)［2022-04-15］.http://www.nhc.gov.cn/yzygj/ylyxjg/202204/d61b7201a-56643d1a876e103340-e5897.shtml.

［12］潘惊萍,段占祺,陈文,等.四川省病案首页管理系统应用的现状调查［J］.中国病案,2015,16(1):8-10.DOI: 10.3969/j.issn.1672-2566.2015.01.003.

［13］宋慧,赵曼,周静,等.基于大数据的三级综合医院统计人员能力现状及相关因素分析［J］.中国病案,2021,22(4):20-23.DOI: 10.3969/j.issn.1672-2566.2021.04.008.

［14］蒋素玲,孙渤星,邓志宇,等.大数据背景下四川省医院统计工作现状调查［J］.中国医院统计,2020,27(5):455-459.DOI: 10.3969/j.issn.1006-5253.2020.05.017.

［15］陈美玲,温星来,冯素花,等.SQL语言在医院统计工作中的应用［J］.中国病案,2022,23(1):24-26.DOI: 10.3969/j.issn.1672-2566.2022.01.010.

［16］周哲颖,史佳敏,黄锐.SQL查询在妇产科医院统计工作中的应用［J］.中国医院统计,2021,28(6):546-550.DOI: 10.3969/j.issn.1006-5253.2021.06.014.

［17］王翔,陆琴.基于SQL语句的医院临时性数据统计［J］.中国医院统计,2021,28(3):282-285.DOI: 10.3969/j.issn.1006-5253.2021.03.020.

［18］马赫,葛丽,刘颖.复杂检索需求下SQL在医院统计中的应用思路［J］.中国卫生统计,2020,37(1):136-140.DOI: 10.3969/j.issn.1006-1959.2015.13.003.

［19］吕国友,郑美莲.SQL语句在病案统计中的应用［J］.中国医院统计,2018,25(4):315-317.DOI: 10.3969/j.issn.1006-5253.2018.04.026.

［20］刘冬生,欧阳菊香,王尔笑,等.基于SQL的重点疾病和重点手术查询统计［J］.中国卫生统计,2015,32(5):863-864.DOI: 10.3969/j.issn.1009-3044.2012.03.009.

［21］陈晔,董四平.我国三级公立医院绩效考核指标体系解读与评析［J］.中国卫生政策研究,2020,13(2):19-25.DOI: 10.3969/j.issn.1674-2982.2020.02.003.

［22］卫生部办公厅. 卫生部办公厅关于印发《三级综合医院医疗质量管理与控制指标(2011年版)》的通知:卫办医政函〔2011〕54号［A/OL］.(2011-04-27)［2022-04-15］.http://www.gov.cn/gzdt/2011-01/27/content_1793358.htm.

［23］国家卫生健康委. 国家卫生健康委关于印发《三级医院评审标准(2022年版)》及其实施细则的通知:国卫医政发〔2022〕31号［A/OL］.(2022-12-16)［2023-01-08］.http://www.gov.cn/zhengce/zhengceku/2022-12/18/content_5732583.htm.

［24］杨芳洁,凌瑞,郭丝锦.西京医院乳腺癌全身麻醉日间手术全程管理规范［J］.华西医学,2020,35(2):202-206.DOI: 10.7507/1002-0179.201908129.

［25］宋文洁,文黎敏,王军,等.日间手术绩效管理体系的探索与实践［J］.华西医学,2020,35(2):141-145.DOI: 10.7507/1002-0179.201911141.

［26］李艺萌,章建明,钟力炜,等.多维度看法国日间手术发展［J］.华西医学,2020,35(2):146-151.DOI: 10.7507/1002-0179.201910061.

［27］赵之玥,李卫红.三四级手术量及其占比作为出国培训效果评价指标的研究［J］.中国病案,2018,19(8):92-95.DOI: 10.3969/j.issn.1672-2566.2018.08.033.

［28］刘丽媛,龚剑红.优质护理模式用于剖宫产围术期的价值评价［J］.基层医学论坛,2019,23(36):5215-5216.DOI: 10.19435/j.1672-1721.2019.36.024.

［29］黄仁建,曹静,刘朝霞,等.Ⅰ类切口手术部位感染的影响因素分析和护理对策［J］.当代护士(下旬刊),2017(6):39-41.DOI: 10.3969/j.issn.1671-4695.2010.09.007.

［30］胡承浩,罗清钦,彭民金,等.某三甲教学医院Ⅰ类切口手术部位感染危险因素分析［J］.医学动物防制,2018,34(10):919-921.DOI: 10.7629/yxdwfz201810001.

［31］宋晓超,赵丽娜,乔美珍,等.神经外科Ⅰ类切口手术部位感染的影响因素分析［J］.中华医院感染学杂志,2019,29(12):1838-1841.DOI: 10.11816/cn.ni.2019-190860.

［32］陈贻品,贾蓓,和晓军.SQL从入门到精通:微课视频版［M］.北京:中国水利水电出版社,2020.

［33］杨业春.基于SQL的医院病种和手术统计监测应用实例分析［J］.中国医院统计,2019,26(2):111-114.DOI: 10.3969/j.issn.1006-5253.2019.02.009.