Notifications
Clear all
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
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
Topic starter
Thanks!
Posted : April 2, 2014 3:52 am
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
Table - INTERACTIONOVERRIDE
Fields you may want to use
OVREASON
OVCOMMENT
DESCRIPTION1
DESCRIPTION2
CREATEDBY
Posted : April 3, 2014 12:32 am
It worked!!
Thanks for your help, BAJ.
Posted : April 3, 2014 4:58 am
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
The associated problems can be created as a subreport.
Posted : April 3, 2014 5:40 am
Topic starter
Thanks, I will try that
Posted : April 3, 2014 8:22 pm
