Rx Review


Find my other Apps, eBooks and an AppleTV app at https://www.pharmpk.com/MyeBooks.html
Submitted v1.0.1 to the Apple App Store on 20 Sep 2016. Changes include:
Submitted v1.0 to the Apple App Store on 13 Sep 2016. Accepted on 15 Sep 2016. Find it on the App Store Download from the App Store
Localized for Arizona, California, Colorado and US Federal as default.
Practice prescription reading. Look for bad dose, drug, dates etc. Some prescriptions are correct. Other will have the incorrect dose, past expiry dates or other errors.

Content and suggestions from David Thompson, Connie Valdez and Gina Moore. Thank you.


Start Screen Prescription Screen DEA Screen

Valid DEA Numbers

This section is my interpretation of available references. Any and all corrections, suggestions, or advice is welcome. David Bourne.

Determination of valid DEA numbers is described in Pharmacy Law - Examination and Board Review by William J Feinberg (ISBN-13: 978-0071747516), pharmacy-tech-test.com and on Wikipedia. Appendix D of the DEA's Pharmacist's Manual doesn't appear to offer much guidance.

My best effort - so far

A valid DEA number (for physicians) appears to include two letters and seven numbers. The first letter designates the registrant category. For physicians this may be 'A', 'B' or 'F'. Other (mid-level practitioners) may have the letter 'M'. Numbers were initially started 'A' and then 'B' (hospital/clinic) and now 'F' (distributor) or 'G' (researcher). It appears that A, B, F or G could be valid.

The second letter is meant to represent the first letter of the physicians last name but with a change of last name a previous initial may be valid. Thus, there appears to be no particular check for this second letter other than prior knowledge of a practitioners DEA number.

The remaining seven digits, numbers, consist of six random digits (0-9) and a checksum digit. This checksum digit is calculated as left digit of the sum of the first, third and fifth digits plus twice the sum of the second, fourth and sixth digit. For example:
For the DEA number AB123456x the checksum is calculated from (1 + 3 + 5) + 2 x (2 + 4 + 6) = 33 so the checksum x = 3 for this number to be valid.


The Current Data Set
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm 4 mg patch
Tab No 30
 Apply 1 patch to back every 24 hours for hypogonadism
Refill 3 times
Yes x No _
AE6259318
Edwards
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm 4 mg patch
Tab No 30
 Apply 1 patch to back every 24 hours
Needs indication
Refill 3 times
Yes x No _
AE6259318
Edwards
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm 4 mg patch
Tab No 30
 Apply 1 patch to back every 24 hours
Needs indication
Refill 14 times
Invalid number of refills
Yes x No _
AE6259318
Edwards
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm 4 mg patch
Tab No 30
 Apply 1 patch to back every 24 hours for hypogonadism
Refill 3 times
Yes x No _
AE6259318
Edwards
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm 4 mg patch
Tab No 30
 Apply 1 patch to back every 24 hours for hypogonadism
Refill 14 times
Invalid number of refills
Yes x No _
AE6259318
Edwards
Michael Edwards MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Androderm patch
Missing Strength
Tab No 30
 Apply 1 patch to back every 24 hours for hypogonadism
Refill 3 times
Yes x No _
AE6259318
Edwards
John M Brown MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Lipitor 20 mg
Tab No 30
 i q d
Refill 11 times
Yes x No _
AB1523679

Missing Doctor signature
John M Brown MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Lipitor 20 mg
Tab No 30
 i q d
Refill 11 times
Yes x No _
AB1523679
John M Brown
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
John M Brown MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Lipitor 20 mg
Tab No 30
 i q d
Refill 11 times
Yes x No _
AB1523679
John M Brown
John M Brown MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Lipitor 20 mg
Tab No 30
 i q d
Refill 11 times
Yes x No _
AB1523679

Missing Doctor signature
John M Brown MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Lipitor 20 mg
Tab No 30
 i q d
prn refills
Yes x No _
AB1523679
John M Brown
John M Brown MD

Bill Jones
 

Lipitor 20 mg
Tab No 30
 i q d
Refill 11 times
Yes x No _

John M Brown
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 40
 i q 6 hours prn pain
No Refills
Yes x No _
AM7231436
Kenneth G McDonald
II
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 40
 i q 6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
AM7231436
Kenneth G McDonald
II
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 2̶0̶ 40
Red Flag: Quantity should not be changed on C2's
 i q 6 hours prn pain
No Refills
Yes x No _
AM7231434
Wrong DEA Number AM7231436
Kenneth G McDonald
II
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 40
 i q 6 hours prn pain
No Refills
Yes x No _
AM7231436

Missing Doctor signature
II
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 40
 i q 6 hours prn pain
No Refills
Yes x No _

No DEA
Kenneth G McDonald
II
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Percocet 5/325
Tab No 40
 i q 6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _

No DEA
Kenneth G McDonald
II
Kenneth G McDonald MD

Missing Doctors Address
Tom Jones
 

Missing Patients Address
Percocet 5/325
Tab No 400
Invalid Quantity (Max 90 days supply)
 i q 6 hours prn pain
No Refills
Yes x No _

No DEA
Kenneth G McDonald
II
Kenneth G McDonald MD
100 Main St Aurora CO 80045
Tom Jones
 

Missing Patients Address
Percocet 5/325
Tab No 400
Invalid Quantity (Max 90 days supply)
 i q 6 hours prn pain
No Refills
Yes x No _

No DEA
Kenneth G McDonald
II
Kenneth G McDonald MD

Missing Doctors Address
Tom Jones
 
200 Main St Aurora CO 80045
Percocet 5/325
Tab No 400
Invalid Quantity (Max 90 days supply)
 i q 6 hours prn pain
No Refills
Yes x No _

No DEA
Kenneth G McDonald
II
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone
Tab No 30
 i tid
Refill 6 times
Yes x No _
AG2576835
Glenda A Green
III
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone
Tab No 30
 i q d
Refill 6 times
Yes x No _
AG2576835
Glenda A Green
III
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone

Invalid Quantity
 i q d
Refill 6 times
Yes x No _
AG2576835

Invalid Doctor Signature
III
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone
Tab No 30
 i tid
Refill 3 times
Yes x No _
XG2576835
Glenda A Green
III
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone
Tab No 30
 i q d
Refill 6 times
Yes x No _
XJ2576835
DEA must be AJ2576835
Bill Jones
Invalid Doctor Signature
III
Glenda A Green MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Suboxone SL
No 30
 i q d
Refill 6 times
Yes x No _
XJ2576835
Wrong DEA Number - AJ2576835
Bill Jones
Invalid Doctor Signature
III
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 30
 i TID prn pain
Refill 5 times
Yes _ No x
FS3728916
William Smith
IV
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 30
 i TID prn pain
Refill 6 times
5 refills in 6 months
Yes _ No x
FS3728916
William Smith
IV
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
Expired
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 30
 i TID prn pain
Refill 6 times
5 refills in 6 months
Yes _ No x
FS3728916
William Smith
IV
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
Expired
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 30
 i TID prn pain
Refill 5 times
Yes _ No x
FS3728916
William Smith
IV
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 30
 i TID prn pain
Refill 3 times
Yes _ No x
FS3728916
William Smith
IV
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
William M Smith MD
100 Main St Aurora CO 80045
Tom Jones
 
300 Main St Aurora CO 80045
Tramadol 50 mg
Tab No 3̶0̶ 40
 i TID prn pain
Refill 5 times
Yes _ No x
FS3728916
William Smith
IV
William C Black MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Vicodin 5/325
No 120
 i q 4-6 hours prn pain
No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Vicodin 5/325
Cap No 120
 i q 4-6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD

Missing Doctors Address
Bill Jones
 
200 Main St Aurora CO 80045
Vicodin 5/325
Cap No 120
 i q 4-6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD

Missing Doctors Address
Bill Jones
 
200 Main St Aurora CO 80045
Vicodin 5/325
Tab No 120
 i q 4-6 hours prn pain
No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD

Missing Doctors Address
Bill Jones
 

Missing Patients Address
Vicodin 5/325
Cap No 120
 i q 4-6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD
100 Main St Aurora CO 80045
Bill Jones
 

Missing Patients Address
Vicodin 5/325
Cap No 120
 i q 4-6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
BB3216226
Bill Black
II
William C Black MD

Missing Doctors Address
Bill Jones
 
300 Main St Aurora CO 80045
Vicodin 5/325
Cap No 120
 i q 4-6 hours prn pain
1 Refill
Schedule 2 - No Refills
Yes x No _
BB3216226
Bill Black
II
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
William C Black MD
100 Main St Aurora CO 80045
Bill Jones
 
200 Main St Aurora CO 80045
Vicodin 5/500
Invalid strength
No 120
 i q 4-6 hours prn pain
No Refills
Yes x No _
BB3216226
Bill Black
II

Current List of Requirements
US Prescription Requirements for Scheduled Drugs
Extracted from: http://accesspharmacy.mhmedical.com/book.aspx?bookid=1354
Requirements / StateUS FederalArizonaCaliforniaColorado
Schedule 2 Refills0000
Schedule 3 Refills5555
Schedule 4 Refills5555
Schedule 5 Refills5555
Schedule 2 Expiry12 months90d6 months12 months
Schedule 3 Expiry6 months6 months6 months6 months
Schedule 4 Expiry6 months6 months6 months6 months
Schedule 5 Expiry6 months1 year6 months6 months
Schedule 2 Quantity Change - Flag?NoNoNoNo
Schedule 2-5 GeneralDrug name, strength, dosage form, quantity, directions, refills authorizedDrug name, strength, dosage form, quantity, directions, refills authorizedDrug name, strength, dosage form, quantity, directions, refills authorizedDrug name, strength, dosage form, quantity, directions, refills authorized
NotesCII: One drug per prescription
From FederalAdditional CI-V items

Contact: David Bourne david.bourne@ucdenver.edu for more information, suggestions and corrections.