Report to pull pts preferred pharmacies

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

87 Views

RSS

lkeith

(@lkeith)

Posts: 457

Honorable Member

Topic starter

Good afternoon, just wanted to see if anyone might have a report that can pull patients that have certain preferred pharmacies? We had a report to do this when we were on CEMR but of course it doesn't work in CPS because of table changes and I'm having trouble finding what I need to try and recreate it.

Thanks,

Linda

Posted : September 14, 2018 6:28 am

jtlewis

(@jtlewis)

Posts: 35

Eminent Member

This will show all patients who have this pharmacy, but not if it is the preferred or not. I can likely alter it to show the preferred if that is what you are wanting but it will take some digging.

select pp.Last + ', ' + pp.First as Patient, cast(pp.Birthdate as date) as BirthDate, pp.PatientId, p.Name as PharmacyName, p.City as PharmacyCity, p.State as PharmacyState from PatientProfile pp
INNER JOIN PatientRelationship pr on pp.PId = pr.PId
INNER JOIN Pharmacy p on pr.RelatedPartyId = p.PharmacyId
where p.Name like '%Pharmacy%' and p.City = 'Glasgow' and p.State = 'KY'

Should be pretty explanatory but just modify what you want to return in the query. I set up the search based on pharmacy name/city/state to ensure you pull in the proper pharmacy.

Hope this helps!

Posted : September 14, 2018 7:40 am

lkeith

(@lkeith)

Posts: 457

Honorable Member

Topic starter

Thanks Jonathan! This worked great!

Posted : September 18, 2018 2:01 am

24 Forums
9,943 Topics
39.9 K Posts
5 Online
6,472 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Welcome to the NEW Community Healthcare User Group ( the new CHUG)— your ultimate destination for insights and discussions at the intersection of healthcare and technology.

Please scroll to the bottom for “Centricity” related topics from the previous forum.

Report to pull pts preferred pharmacies

This will show all patients who have this pharmacy, but not if it is the preferred or not. I can likely alter it to show the preferred if that is what you are wanting but it will take some digging.

Should be pretty explanatory but just modify what you want to return in the query. I set up the search based on pharmacy name/city/state to ensure you pull in the proper pharmacy. Hope this helps!

Should be pretty explanatory but just modify what you want to return in the query. I set up the search based on pharmacy name/city/state to ensure you pull in the proper pharmacy.

Hope this helps!