Notifications
Clear all
Topic starter
Hi All,
To start I am on CEMR 9.8.10.
I've tasked myself with creating a report that would show me all of the patients in our system that have a medication(s) on their chart which either has an interaction with another medication or an allergy (also on their chart). I don't care so much about those that have already been addressed (that information is stored in the INTERACTIONOVERRIDE table). The furthest I've been able to get is to pull the KDC number from the MEDINFO table but this doesn't help me define the criticality (not a word?)/Severity etc that would really help me make this report useful.
Does anyone know where this information is stored? The KDC looks like a key of some sort that would link over to a table that contains this information (much like the DDID in MEDICATE links over to MEDINFO) but I can't find this other table. Unfortunately the data dictionary for 9.8 isn't as good (with the key listings) as 9.5s version was.
Any guidance would be much appreciated.
Thanks
Mike
Posted : January 5, 2016 5:48 am
In CPS they are the tables that start with dbo.MS_ (MS for Medispan I believe). Two tables dbo.MS_M01_DELTA and dbo.MS_02_DELTA have med interaction details with a severity. I don't know the exact details you are looking for but that's where I would start. They are not documented in the data dictionary.
Posted : January 5, 2016 6:16 am
Topic starter
More unpublished tables! I found them with the ML user so I'll have to grant access to my reporting user. Thank you very much, this should give me a better starting position to explore.
Mike
Posted : January 5, 2016 7:39 am
