Statistics and analysis of performance appraisal indicators for tertiary public hospitals based on SQL
Chen Hanjie1,2,Chen Yun2, Lu Hong2, Xu Chang2, Duan Jun1,2,Wu Shichao2,Diao Yuhan1, Liu Yan1,2
1 Medical Records & Statistics Office, Peking University Shenzhen Hospital, Shenzhen 518036, China;
2 Intelligent Hospital Research Academy, Peking University Shenzhen Hospital, Shenzhen 518036, China
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.