Notifications
Clear all
Topic starter
Hi, I am looking to see if anyone knows if there is a way to get a report on a list of pharmacies that have been REMOVED from CEMR? I have a report that shows when the pharmacy info has been changed/updated.
Thanks!
Posted : June 1, 2016 3:59 am
Just out of curiosity, are you looking for this because you have a bunch of patients who appear to be tied to a pharmacy that does not exist? I ask because we're tracking down a bug that has this effect...
Posted : June 2, 2016 4:57 am
Topic starter
No, just a list of pharmacies that have been removed from CEMR in general whether or not its tied to the patient or not. Are you aware of a way to do this?
Posted : June 2, 2016 5:58 am
This will show you the inactive ones:
SELECT *
FROM [dbo].[Pharmacy]
Where [inactive]=1
If they've been deleted from the table you might be out of luck.
Posted : June 3, 2016 12:28 pm
