利用Oracle触发器实现临床用药目录分级提示

Oracle trigger applied to prompting of graded clinical medication directory

目的:为了避免医保超范围不合理用药,提高临床医生的工作效率,防范医患矛盾,维护医保定点医疗机构的经济效益,利用Oracle触发器实现临床用药目录分级提示。方法:改造军卫数据库"ordadm"、"doctor_orders_insert"触发器,利用Oracle触发器自动执行代码块,校验当前患者费别对应的用药目录,及时提示当前药物医嘱的使用级别,协助临床医师合理用药。结果:该触发器可以对临床用药医嘱进行实时监控,分级提示受限用药,发挥了及时杜绝的功效,使合理用药工作更具科学性、主动性。结论:该触发器自适应性强,适用于任何安装军卫系统的医疗卫生机构,有利于丰富和完善军卫系统的功能。

Objective To apply Oracle trigger to the graded prompting of clinical medication directory to eliminate improper prescription. Methods The “ordadm”, “doctor orders insert” trigger in the database of No.1 Military Medical Project was modified, then Oracle trigger executed the code block automatically to verify the clinical medication directory based on the classification of the patient and to determine the grade of the existing medication. Results The trigger could monitor clinical prescription at real time and prompt the grade of the medication, and thus could facilitate the proper medication.Conclusion The trigger behaves well in self adaptation, and then can be applied in any medicalfacility with No.1 Military Medical Project System.