利用PowerBuilder弥补“军卫一号”医院信息系统中统计模块的设计缺陷

Remedy of the Design Defects of Statistics Module in “No.1 Military Medical Project” Hospital Information System Using Power Builder

目的:解决现行"军卫一号"医院信息系统(HIS)中统计模块的缺陷,为合理制订采购计划提供依据。方法:基于医院"军卫一号"HIS数据库,采用PowerBuilder工具,编写SQL语句,结合Excel计算函数并进行统计。结果:本方法可一次性快速查询所有品种设定时间段内的用量情况,弥补了"军卫一号"HIS药品库存管理程序中单品种流水账功能设计缺陷的问题,在库药品的匹配准确度达到90%以上。结论:利用本方法可弥补"军卫一号"HIS药品库存管理程序中出库数据不能导出和查询的缺陷,大大提高工作效率和药品采购的准确性。

OBJECTIVE： To solve the design defects of statistics module of drug stock management in ＂No.1 Military Medical Project＂ hospital information system （HIS）, and to provide reference for the formulation of drug purchase plan reasonably. METH- ODS： Based on the database of ＂No.1 Military Medical Project＂, SQL program was compiled with PowerBuilder, then results were calculated with Excel. RESULTS： The method can quickly check the amount of all varieties over a specified period of time. CON- CLUSIONS： This method can remedy the statistical function design defects that the data can not be exported or consulted in drug storage management program with match accuracy of above 90 %, and can greatly improve work efficiency and procurement accuracy.