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

custom report needed

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

5 Posts

3 Users

0 Reactions

62 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Does anyone have a report that pulls all of the following information?

The report is for: MNCM

Items Needed:

Patient Demographics (First & Last Name, DOB, Sex, Full Address, Phone# &

Language)

Appointment Physician

Physicians NPI

Physicians Speciality

Physicians Title

We have tried to create a report in Analytics; however, we could pull all but Physicians NPI & Patients Language. If anyone has anything that might help I would grately appriciated.

Thanks!!! Mary

Posted : July 16, 2012 11:55 pm

acantu

(@acantu)

Posts: 722

Prominent Member

you will have to use Crystal to build this report, does Analytics give you access to the database?

Posted : July 19, 2012 12:53 am

aballard

(@aballard)

Posts: 43

Trusted Member

Hi Mary,

Were you trying to accomplish this in Analytics using the OLAP Cube or a View as the datasource?

If you are using an Analytics View, it is possible to modify the sql to pull in the additional desired fields from the Centricity Database into Excel. I don't have time to provide you with code/instructions right now, but if you want to go this route let me know.

Unfortunately you cannot modify the "compiled" Analytics OLAP Cube to bring in additional fields.

Of course you can always use Crystal Reports as Arnold mentioned.

Thanks,

Allen

Posted : July 19, 2012 3:23 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Thank you Arnold!

Allen- We are viewing as the datasource, and would love any information you have regarding this. I will be in the office tomorrow and all next week from 8:00am to 5:00pm CST. (218) 625-2718. If you would have an opportunity to call me. We are a GE hosted client, so i do not have access to our servers, would you solution require this?

Posted : July 19, 2012 5:44 am

aballard

(@aballard)

Posts: 43

Trusted Member

hmm, I'm not that familiar with the hosted environment other than I know it's very "locked down". It might be worth a try, though. I'm guessing it would depend on a number of things including whether your Analytics database resides on the same server as your Centricity database and if your sql server is configured to allow queries to linked servers etc. etc..

Can you email ([email protected]) me the name of your Centricity database and the name of the View(s) you are wanting to enhance to include the new fields. I can test it including those fields on my end.

Posted : July 19, 2012 6:05 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
3 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