SQL语句在单病种质量统计中的应用

An Application of SQL Language in the Stat. of Single Kind of Disease

利用广东省统计病案管理系统,对单病种动态监测。根据卫生部《病种质量控制标准》要求,按照ICD10码分类标准,确定疾病统计的取值范围,使用SQL语言进行编译,并取其关键的选择条件部分,应用于系统程序的参数设置中,计算机自动生成单病种动态报表。应用动态报表实行单病种费用、住院日等监测及质量管理,对医院管理具有极其重要的意义。

To use Star. cases managing system of Guangdong province to dynamic inspect single kind of disease. According to the need of Sanitation Department ＂Standard Of Disease Kind Quality Control＂ , according to class standard of ICD10, make sure the value confine, translate and edit in SQL, its key condition part was obtained and to use in parameter setup of the system program, automatic create the dynamic report. It is a significance to use the dynamic report to inspect and to manage the outlay of single kind of disease, day in hospital.