Notifications
Clear all
Topic starter
We have 2 tests for mono, one is a service we used to do in-house and one is a test we send out to the lab to do. I want to delete the "service" mono test so the providers can not search for it and accidentally choose it. I have tried to delete it/make it obsolete, but I can not find it in Codes and Categories anywhere. Any ideas? We have a lot of duplicate labs in our codes and categories that we can not delete.
Posted : May 23, 2014 1:21 am
Here is a sql query (Oracle/EMR 9.5) that you can run to find it
select q.qpicktype,q.description,o.ordcodeid,o.ordertype,o.code,o.description from ml.customorders o, ml.qpicks q where o.gid = q.qpid and upper(o.description) like '%MONO%' order by q.qpicktype,q.description,o.ordertype
Posted : May 27, 2014 12:10 am
