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

Query Prescriptions given by Provider and Drug Classification (Narcotics)

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

58 Views

RSS

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

Environment: EMR 9.8, CPS 12

Hi, one of my providers asked if I could list the number/(type of) of narcotic classification prescriptions given to his patients over the past 2 years. I wasn't sure which of the Centricity Tables to query against, or which field specifies the classification.

Drug classifcation/schedules: 1 - Hallucinogens; 2 Narcotics; 3 Stimulantsl; 4 Anabolic Steroids; 5 Depressants

For Narcotics it would be a schedule 2 Drug.

So, what table and field can I be checking for a patients prescriptions by Drug Classification.

Better yet - anyone have a Crystal Report that always does this (or close to this) ?

- Beverly

Posted : January 20, 2015 7:02 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

A while back, we put together this report (for the EMR) to highlight any patients taking a 'high dose' of meds. The selection logic:

{PRESCRIB.CLINICALDATE} >= dateadd("d",-30,currentdate) and
{MEDICATE.LEGEND} = "R" and
{MEDICATE.GPI} startswith "65" and
{PERSON.PSTATUS} = "A" and
{PERSON.ISPATIENT} = "Y" and
not (LowerCase({PERSON.LASTNAME}) like ["test","testing","logician"]) and
{PERSON.SEARCHNAME} <= "ZZZ" and
{@MedToInclude}=1 and
{LOCREG.ABBREVNAME} in ["GMA"]

defined....

clinicdate for last 30 days, adjust to lookback however long you like
to get meds
grouping to select the meds
active patients
records for patients
exclusion, to get rid of any testing patients
legacy code, to allow for a quick change and testing (set to AZZ to see how it works)
Look at the variable, as I wanted to exclude four meds
location code; you can change or delete this

M130 NHP Clinic Dosages

Let me know if any other questions, suggestions, etc...

~JoeG

Posted : January 20, 2015 8:53 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

CPS or EMR?

Posted : January 20, 2015 10:34 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

James, I need the report/query for EMR 9.8.

JoeG, Thank you for the post and CR, I will fiddle around with this.

- Beverly

Posted : January 20, 2015 12:41 pm

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Hi,

I pulled something similar (can someone point me to an explanation on how to attach things to a post?) a while ago. I am not clinical so I assumed there were more schedule II drugs then just narcotics so I googled narcotics and found they were all classified as opioids. I then used a GPI report I had to find out that all opioid GPI's start with 65. I then constructed the report as follows:

person -> medicate -> prescrib -> usrinfo -> locreg

Attaching person.pid to medicate.pid then
medicate.mid to prescrib.mid then
prescib.pvid to usrinfo.pvid then
usrinfo.homelocation to locreg.locid

I filtered the report as usrinfo.loginname = (my doctors login name) and medicate.gpi starts with "65"; I had the patients info and the drug description on the report for my end user consumption. The logic above showed all patients who had a narcotic prescription authorized by my physician.

Thanks,
Mike

Posted : January 26, 2015 7:40 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Topic starter

Michael and Joe,
Thank you for your notes on how you went about this kind of CR.
I have not had time to create my own queries yet (swamped on another project), but am looking forward to trying based on your suggestions.

Sidenote: I was having trouble uploading mel code recently, it kept loosing all formatting. Was told to use the Text Tab, and select "Code" option.

Not sure how to attach a file.

- Beverly

Posted : January 26, 2015 11:12 am

Share:

24 Forums
9,942 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