Notifications
Clear all
Topic starter
If any of you experienced the rename of uncoded meds to FORTAZ (IV) after applying the October KB update and then ran the GE script to roll them back you need to be aware the results may be incomplete. We found that between the time we applied the KB update and GE produced the script, some physicians removed the FORTAZ (IV) entries thinking they were in error. This marked the medication inactive. When the GE script is run, it does not change the name and mark it active so you have the potential of having VALID medications marked as inactive. We had 44 such medications. This could be bad if the once VALID medication now marked INACTIVE conflicts with future treatment.
I wrote the following script to show you the original meds that were removed by staff thinking that FORTAZ (IV) was an error. You will need to notify your staff to review the medications and add back anything important. We reported this to GE on 11/6/2017. They claim to be working on an active report but I have not seen anything yet.
--List patients and original med replaced by FORTAZ (IV) which was removed.
select pp.patientid, pp.searchname, df.listname, dr.listname, m1.DESCRIPTION, m1.INSTRUCTIONS, m1.STARTDATE from medicate as m1
join medicate as m2 on m1.xid=m2.mid
join patientprofile as pp on m1.pid=pp.pid
join DoctorFacility as df on pp.facilityid=df.doctorfacilityid
join DoctorFacility as dr on pp.DoctorId=dr.DoctorFacilityId
where m2.description = 'FORTAZ (IV)'
Posted : November 16, 2017 7:36 am
