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

doi:10.3969/j.issn.1006-5253.2023.05.007

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

Download: PDF (4527 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS)

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

Key words： SQL public hospital performance appraisal hospital statistics first page of medical records database

Received: 23 May 2023

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Chen Hanjie
	Chen Yun
	Lu Hong
	Xu Chang
	Duan Jun
	Wu Shichao
	Diao Yuhan
	Liu Yan

Cite this article:

Chen Hanjie,Chen Yun,Lu Hong, et al. Statistics and analysis of performance appraisal indicators for tertiary public hospitals based on SQL[J]. journal1, 2023, 30(5): 359-365.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2023.05.007 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2023/V30/I5/359

［1］张明，夏家红，刘波，等．“国考” 绩效推进委属委管医院高质量发展的实践与思考［J］．中国医院管理，2021，41(7)：88-90．DOI: 10.16659/j.cnki.1672-5654.2020.15.079.

［2］高娅，江静，徐萍，等．浅析SQL语言在病案首页质量控制中的应用［J］．中国病案，2018，19(6)：5-7．DOI: 10.3969/j.issn.1672-2566.2018.06.003.

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

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

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

［6］张帧，商建国，肖辉．基于SQL语句的单病种付费管理设计与实现［J］．中国卫生信息管理杂志，2019，16(5)：614-617．DOI: 10.3969/j.issn.1672-5166.2019.05.021.

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

［8］吴晓云，郑银雄，冯笑玲．基于数据库的医院病案信息SQL查询［J］．中国卫生统计，2014，31(1)：144-145．

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

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