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

Potential Interactions - Where is it stored?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

132 Views

RSS

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

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

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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