Notifications
Clear all
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
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
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
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
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
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
