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

Need a report to show all Active Meds

Trading Post

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

85 Views

RSS

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I am currently running a report that shows ALL meds, but I need a report that shows only "Active" meds if possible. I am using MEDICATE.Description field table in my report. Thanks!

Posted : April 19, 2013 3:47 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

There is a column in MEDICATE called CHANGE. You want all the rows with CHANGE = 2.

Posted : April 19, 2013 4:29 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I can apply this to patients based on certain obs as well. It will only show patients that have a certain med in the active list and not all list?

Posted : April 19, 2013 4:50 am

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

As longs as the MEDICATE table is filtered where MEDICATE.CHANGE = 2, only active medications will show. If you can, show me the query you are using for this report, and I can probably see if there would be any issues.

Posted : April 19, 2013 4:59 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

Topic starter

I tried it and it seems to work like it should. Thanks for your help!!

Posted : April 19, 2013 5:08 am

Mitch Kwiatkowski

(@mitch)

Posts: 111

Estimable Member

You also want STOPDATE > CurrentDate. Using only Change = 2 will still show inactive meds with all stop dates including those prior to today.

Posted : April 19, 2013 5:43 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