Notifications
Clear all
Topic starter
We have a local pharmacy that recently closed. I am looking for a report that I can run to find all patients with that pharmacy so I can remove it from their profile. Does anyone know of a way to run a report based on pharmacy?
Posted : April 18, 2016 5:56 am
Hi Jessica,
We have a crystal report we have used in the past. I am unable to attach it here but I will email it to you.
Posted : April 18, 2016 6:16 am
Posted : April 18, 2016 6:40 am
Hi Jessica,
If you are able to access a SQL Server, you can run the following Script;
select PatientId, pp.Last+', '+First as PatientName, p.ListName, p.Address1, p.Phone1,case when inactive= 0 then 'Active' else 'Inactive' End as Status
from PatientRelationship Pr
join PatientProfile pp on pr.PatientProfileId = pp.PatientProfileId
join Medlists ml on pr.RelationshipTypeMId = ml.MedListsId and ml.description='Pharmacy'
join Pharmacy p on pr.RelatedPartyId = p.PharmacyId
Posted : April 18, 2016 7:11 am
