Notifications
Clear all
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
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
Let me know if any other questions, suggestions, etc...
~JoeG
Posted : January 20, 2015 8:53 am
CPS or EMR?
Posted : January 20, 2015 10:34 am
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
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
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
