Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

How to get a List of all PCP's and Referring Providers

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

95 Views

RSS

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

How do I get a list of all the Primary Care Providers and Referring Providers ?
I need their Fax numbers, so we can send out a fax to each of them.
These are the people who are listed as a patients CONTACTs - only their PCP and Ref Provider.

We are on CPS 12 (for registration/billing) and EMR 9.8 for charting.
Do I need to query against CPS 12 (sql server)
or can I go against EMR 9.8 (oracle) ?

Since they are registered in CPS, probably need to query against the Sql Server database.
How would I do that, what would the query be ?

What tables and fields do I need to go against ?

Does anyone have a report that already does this?

- Beverly

Posted : April 9, 2015 1:57 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

If you have Crystal Reports, I can send you a report to give you this information. Alternatively, I can send you the report which you can import into Centricity. You can contact me at [email protected].

Posted : April 9, 2015 2:20 pm

wsc27

(@sclayton)

Posts: 142

Estimable Member

If you are doing this via Crystal Reports, you can use the USER and/or USRINFO tables. Let me know if I can be at further assistance.

Posted : April 10, 2015 1:23 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

These queries will show you all PCP/Referring MDs associated with at least 1 patient record.

SELECT DISTINCT PCP.First, PCP.Last, PCP.Address1, PCP.Address2, PCP.City, PCP.State, PCP.Zip FROM PatientProfile P INNER JOIN DoctorFacility PCP ON P.PrimaryCareDoctorId = PCP.DoctorFacilityId

SELECT DISTINCT REF.First, REF.Last, REF.Address1, REF.Address2, REF.City, REF.State, REF.Zip FROM PatientProfile P INNER JOIN DoctorFacility REF ON P.RefDoctorId = REF.DoctorFacilityId

Posted : April 10, 2015 2:57 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

My environment is CPS 12 (sql server) and EMR 9.8 (Oracle)

Is there an equivalent query against the EMR 9.8 Oracle database?
I am looking for the EMR registration contacts fax numbers,
contacts filtered by Relationship of "Primary Care Physician", "Referring Physician".
It would be good to not list duplicates, and ordered by lastname, firstname.

What tables in the ORACLE database do I need in this query ?

I will also try the queries above, against the SQL Server database (CPS).
I will let you know if it works 🙂

- Beverly

Posted : April 16, 2015 7:53 am

alsmith-ph

(@alsmith-ph)

Posts: 3

Active Member

I would be interested in getting the code for both Crystal Reports and the report to import into Centricity.

Thank You

Posted : December 7, 2015 8:11 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

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

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

Powered by wpForo Powered by wpForo version 2.4.0