Notifications
Clear all
Topic starter
Does anyone have a report that can extract the following info from CPSv12
Patient Name
Patient Address
Patient Phone Number
Patient email
Posted : February 22, 2017 7:04 am
I have provided the general query logic you would need to generate a report at the bottom of this response. All of this information is contained in the Patient Profile table. There are three different phone numbers, so I am just pulling the first (assume it is primary). You could use the query below in Crystal Reports or use a tool like Microsoft Access to connect to your database (read only mode) and build a report in that tool. I don't have a canned Crystal Report you can use but it should be relatively easy to do this. What are your intentions with this report? The answer to that question would dictate the preferred solution as there are many ways of getting this information. Setting up custom reports inside of Centricity can be really confusing so I generally prototype the report in Access.
SELECT PatientId, First, Last, Phone1, Phone1Type, Address1, Address2, City, State, Zip, EMailAddress FROM PatientProfile
Posted : February 22, 2017 7:44 am
