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

Is it possible to pull controlled substances from the med list. (ie using MEDS_AFTER)

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

2 Posts

2 Users

0 Reactions

67 Views

RSS

Adam Daniel

(@adaniel)

Posts: 524

Prominent Member

Topic starter

End goal here is to pull the medications that are controlled substances and display those. Using MEDS_AFTER there doesn't seem to be a field that identifies whether a drug is a controlled substance or not.

I use the following piece frequently to pull meds

{!fn xGrabMeds() {
local temp = getfield(MEDS_AFTER("delimited"), "|", "")
local hold
local rslt =""

for i=1, i<=size(temp),i=i+1 do
hold = getfield(temp[i],"^","")
if hold[1] <> "" then
if rslt <> "" then
rslt = rslt + hret
endif
rslt = rslt + hold[1] + ","
endif
endfor
return rslt
}}

If there is a field that identifies a controlled substance I could put that in for my hold and I think that would do, otherwise I would have to filter out the description field with LISTSUBSET maybe?

Anyway; hoping I missed something or there's another symbol out there for this. Thanks in advance.

Posted : July 10, 2017 3:32 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Index 4 of the MEDS_AFTER array holds the GPI number. The best you could hope for is to create a subroutine that evaluates GPI masks for the target medications. As a general rule, analgesic/narcotic medications fall in the 64-71 range (65 is narcotic specific), but understand that off label uses as well as DEA rules can place other medications within a GPI series in a controlled status, so those would need to be accounted for as well.

A simple cond-case plus a match(GPI Mask,Rx GPI) == 1 (the mask should always start at index 1) statement should get you there and make it easy to expand as needed. You can make you mask as loose (fewer numbers but no less than 2) or as tight (up to the full GPI number) as needed. Using a case statement makes it easy to adjust.

Using the above, you could create masks that would let you define most of the narcotic meds (65) in an effort to get the project off the ground. From there, identify the 'outliers' and add them to the case statement as desired.

Hope this helps.

Posted : July 10, 2017 4:06 am

Share:

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