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

SLMV-Meaningful Use EP Summary

Trading Post

Last Post by Anonymous 12 years ago

5 Posts

3 Users

0 Reactions

53 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Below is a screen shot of a Meaningful Use EP Summary report. This report will be presented during our 'oh yeah prove it' presentation at the Orlando CHUG 2012.

We use this to show physicians how they are doing on each measure with an easy to read 'green check' meaning you met the measure or a red stop sign if not.

This report is generated using the USRINFO table and an excel spreadsheet with extracted MU data for each physician. The spreadsheet is linked to the physician using the NPI number.

MU Master.xls (file renamed to .txt extension to upload)

MU EP Summary.rpt

Posted : October 2, 2012 3:44 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

aimeed,

It looks awesome. Since I wasnt able to go to CHUG, could you explain the reasoning behind the excel sheet? Why not just code it in Crystal? Sorry if these are nonsense questions...

Posted : October 26, 2012 12:01 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

There are two reasons.

The first was we were initially using MQIC data and the extracts from MQIC came in this format. Our administration wanted to see each EP's data by clinic and then by physician. There was not a way when we started this project (and I have not followed up on new reports built by MQIC) to see how a physician is doing across all measures at a glance. So we used the MQIC excel extracts as our data source and then built a crystal report that grouped/sorted the data the way we wanted it allowing analysis to happen at a glance.

However, a second reason is that we have found with many crystal reports that pull a lot of data, especially observation term data, it is difficult to get all the data you want and also group/sort the information the way you want the report's end product to look. So we have found that this two step approach is less frustrating/limiting in the end. One report to extract the data and do your data validation against. The second report uses that 'view' of data and creates a visually appealing report.

Ultimately, if we had a separate reporting database that we could transfer data to and report off of, that would be the ideal solution. That would also give us the ability to do trending; a request we are starting to get more frequently. Since we don't have that, this is the next best thing for us.

I hope that helps.

Posted : October 29, 2012 3:27 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

I was wondering if you could help me with your crystal report. I see that some parameters are hard coded, but there are a few sections that I am not to clear on ( not an expert in crystal). Is there any way we can speak for a few minutes for some guidance? Please email me at [email protected], if you are able to speak.

Posted : October 31, 2012 1:02 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

aimeed,

Could SQL be used instead of .xls to create the "view"?

Posted : December 7, 2012 5:34 am

Share:

24 Forums
9,942 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