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

Med Classification

Trading Post

Last Post by Stacey LaGrange 12 years ago

7 Posts

4 Users

0 Reactions

68 Views

RSS

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Does anyone know where the table for med classifications is located? I need to pull meds for the ANALGESICS-OPIOD class. I thought maybe MEDICATE_CHAIN (GPI field) but I don't see any consistencies in the #s.These meds are not done through ERX so I can't use that table.

Stacey LaGrange
Software Developer/Analyst
St. Mary's Health System
[email protected]
(207) 777-8410

Posted : October 17, 2012 4:52 am

baj

(@baj)

Posts: 99

Estimable Member

Not sure if it can be used for your report, but there is a table PRESCRIB that records medication prescribed for a patient.

Posted : November 13, 2012 2:23 am

Mitch Kwiatkowski

(@mitch)

Posts: 111

Estimable Member

Here's a report posted to CHUG a while back, I believe by Lee Cooper. Here is a PDF version of the output. The classification is based on the GPI code and the number of digits matching defined classification categories. There's a legend at the bottom that explains how many digits are used for each level of classification.

Edit: I moved this topic to the Trading Post so others won't miss the report.

Posted : November 13, 2012 5:26 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

These are the GPI ranges for controlled & pain related medications.

//OTC ANALGESICS 64100010000307-64991003300320
//OPIOIDS 65100020102003-65995002200320 43997002280310-43997002722020 43101010000310-43101010001210
//NSAIDS 66100007000610 - 66109902200330
//BENZODIAZEPINE 72100010000305 - 72100030006340 60201010100105 - 60204080100315 57100010000305 - 57100070000310
//MM_RELAXERS 75100010000305 - 75990003200320
//SED_HYP 60100010102110 - 60201005000320 57200050000305 - 57200050000310
//ANTIDEPRESSANTS 58030050000315-58300090107050
//AMPHETAMINE 61100020100305 - 61109902107030
//RITALIN 61400016100320-61400020107040
//PROVIGIL 61400024000310-61400024000320

just test the meds GPI and do a compare to see if it's in one of these ranges. The chronic pain management form that this is from is posted here somewhere.

Posted : November 13, 2012 7:42 am

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Thanks I did end up writing this formula but now I see I missed some for opiates so I will need to redo this. Where did you find this table? I only knew to use 65 for opiates from trial and error.I had asked GE and they couldn't help me find a table.

IF ({MEDICATE.GPI}) startswith ["65"] AND ({MEDICATE.STOPDATE}) > CurrentDate AND ({MEDICATE.XID}) = 99999999999999997000000000000000000 THEN {MEDICATE.DESCRIPTION}

Posted : November 13, 2012 9:44 pm

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

I used MSQUERY to "download" the ML_MEDICATE table to an excel sheet then just went through it by hand. Sort on the GPI column.

It's messy to go through it by hand but not terribly time-consuming; the GPIs are spread a bit due to things like combination meds. I have used similar strategy to identify, eg, beta blockers, ACEs and ARBs, and so on.

This is something that should be done by or verified by a pharmacist and/or an MD.

Posted : November 13, 2012 11:30 pm

Stacey LaGrange

(@slagrang)

Posts: 185

Reputable Member

Topic starter

Good idea, I do really like MSQUERY for reports like this too, thanks

Posted : November 13, 2012 11:36 pm

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