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

Associated Problem

Trading Post

Last Post by Anonymous 1 second ago

9 Posts

4 Users

0 Reactions

89 Views

RSS

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Does anyone know where the associated problems for medications are stored? I checked MEDICATE, PRESCRIB etc. tables but can't seem to find it

Stacey LaGrange
[email protected]
(207) 777-8410

Posted : April 2, 2014 3:19 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

I think, the medicate table has a field called DXGROUPID, it is linked to a field with the same name in the MEDDX table, there can be multiple rows in the MEDDX table with the same DXGROUPID (if multiple problems are associated with the same medication.

Posted : April 2, 2014 3:44 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thanks!

Posted : April 2, 2014 3:52 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

I m looking for something similar, but looking for the data for the box underneath "Associated Problems" which is "Does and Interaction Override Reasons w/ Comments"? Which table.field would the data be found at?

Thanks in advance for your help.

Posted : April 2, 2014 4:16 am

baj

(@baj)

Posts: 99

Estimable Member

Table - INTERACTIONOVERRIDE

Fields you may want to use

OVREASON

OVCOMMENT

DESCRIPTION1

DESCRIPTION2

CREATEDBY

Posted : April 3, 2014 12:32 am

wsc27

(@sclayton)

Posts: 142

Estimable Member

It worked!!

Thanks for your help, BAJ.

Posted : April 3, 2014 4:58 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

I have the new table added which is great but now am having issues with my formula below (I am using it as a field), it only shows meds if there is a dx attached to them. Does anyone know how I can reword this to list all meds?

if {MEDICATE.STOPDATE} > CurrentDate and {MEDICATE.XID} > 10000000000000000000000000.0 then {MEDICATE.DESCRIPTION} + " " + {MEDICATE.INSTRUCTIONS} + ChrW (13) + "Yes _____ No_____ Refill_____" +
if {MEDDX.DXDESC} <> " " then " Associated DX: " + {MEDDX.DXDESC}

The text looks like this:

CYCLOBENZAPRINE HCL 10 MG TABS 1/2 to 1 tab by mouth 3 times a day

Yes _____ No_____ Refill_____ Associated DX: MUSCLE SPASM

Posted : April 3, 2014 5:33 am

baj

(@baj)

Posts: 99

Estimable Member

The associated problems can be created as a subreport.

Posted : April 3, 2014 5:40 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thanks, I will try that

Posted : April 3, 2014 8:22 pm

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