Have you had a prescription filled at Safeway lately?
If you have I would like your data.
Here is why. I noticed a pattern on the last two scripts I had filled.
4/28/2017
Hydrocodone RX # 20496**
Amoxicillin RX # 63407**
4/12/2018
Hydrocodone RX # 20536**
Ibuprofen RX # 63720**
First, the opioid is in the 2 million range. The other normal stuff is in the 6 million range. I’m assuming they are using some primary key in the database that increments for each new record.
So what I am trying to figure out is if the RX numbers are for all stores or just per specific branch. I assume it is all in a big company wide database. I doubt my branch does 40K scripts a year.
And also what I am trying to figure out is if they are only using the 2 and 6 million range. Perhaps statins are in their own range? What I want to know is that if only the 2 and 6 million ranges are used I can infer the amount of scripts that are filled that are opiods.
So some data would be helpful. Like the date, RX #, and type of drug. I know this shit is sensitive so feel free to dumb down the data or not reply at all.
Here is why I am curious. I went to the dentist last Thursday for some routine shit. I was given a script for 12 Hydrocodone. I never used them. Ibuprofen did the trick. It is absurd I was given these.
So what I am thinking is that Safeway puts opioids in the 2Mil range for the RX#. And everything else is in the 6 million range. If this is the case they gave out 5K scripts for opioids and 30K for everything else.
Which is fucking absurd. I would like more data.
Observing members:
0
Composing members:
0
7 Answers
Difficult to deciper.
You have no idea how the numbering system works. For all you know, it may have to do with manufacturer, or distribution center, or both.
Yeah dude. That is why I want data.
I have my prescriptions filled by my local pharmacy not Safeway. Here’s my data anyway.
As you might know I recently had a perforated colon so I was prescribed pain killers and antibiotics.
Antibiotic 3/21/18 #72987**
Oxyc 23364**
I recently had a flare up, likely a second blow out, and was prescribed the same meds about a month later.
Antibiotic 4/17/18 #73083**
Oxyc 23375**
I’ll be happy to give you all the data PM if you want it. This is a great question!
@LuckyGuy :: I believe the numbers are specific to Safeway. But thanks..
Hmm. My sister eats tons of pills and I believe she gets them filled at Safeway. Off to text her.
@LuckyGuy There are no Safeways around here. I did a store search an the closest was in NJ over 300 miles away.
I noticed the prescriptions for the opioids were in the 2 million range while the antibiotics were in the 7 million, I will have to start looking more closely at mine.
My first thought about the numbers is that they may be consecutive. So, when you say that it’s absurd that they have filled 5,000 prescriptions for opiates, that number could be since the beginning of that specific pharmacy.
I don’t know if the following will help, but I’m happy to provide data.
From CVS:
Lisinopril (cholesterol drug): 11679XX
Dymista nasal spray: 11805XX
Paroxetine (generic Paxil): 12081XX
Fenofibric acid (cholesterol drug): 12086XX
Januvia (Diabetes drug): 12098XX
The CVS prescriptions are in date order of when they were filled. This makes me think that each branch of CVS numbers each script consecutively. (Refills have the same number each time.)
From Express Scripts:
Lisinopril: 1705 0034 XXXX
Fenofibric acid: 1705 0034 XXXX
From MetroHealth Pharmacies, which is the county-run hospital:
Glumetza (diabetes drug): 931–453XXX
@tedibear :: My scripts for the hydrocodone were pretty much a year apart. And the number increased by 5K. They are clearly using auto-increment in the DB. So the next person in line would get my number +1. Which is a massive security hole.
According to google 4 BILLION prescriptions were filled in the United States last year. So I am wondering a bit about using a 7 digit integer. It is no coincidence that my hydrocodone number went up 5K and the normal stuff went up 30K. They are clearly auto-incrementing.
Answer this question 
This question is in the General Section. Responses must be helpful and on-topic.
Composing members:
0
