Rx Review

David Bourne david@boomer.org
Find my other Apps, eBooks and an AppleTV app at https://www.pharmpk.com/MyeBooks.html
Submitted v1.2 to the Apple App Store on 29 Mar 2019. Accepted on 30 Mar 2019. Download from the App Store
Changes include:
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.
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. DEA's Pharmacist's Manual.

My best effort - so far

A valid DEA number (for physicians) includes two letters and seven numbers. The first letter designates the registrant category. For physicians this may be 'A' (issued before October 1, 1985), 'B' or 'F'. Other (mid-level practitioners) may have the letter 'M'.

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
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
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
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

Missing Doctors Address
Bill Jones
 
200 Main St, Aurora CO 80045
Androderm patch
Missing Strength
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
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
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
 1 daily
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
 1 daily
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
 1 daily
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
 1 daily
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
 1 daily
prn refills
Yes x No _
AB1523679
John M Brown
John M Brown, MD

Bill Jones
 

Lipitor 20 mg
Tab No 30
 1 daily
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
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
Dr NameDr AddressPt NameExpiredPt AddressDrug NameNumber
 SigRefillsGenericDEASignatureClassUS
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
Incorrect Number
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
 1 daily
Refill 6 times
Yes x No _
AG2576835
Incorrect Number
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
 1 daily
Refill 6 times
Yes x No _
AG2576835
Incorrect Number

Invalid Doctor Signature
III
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
 1 daily
Refill 6 times
Yes x No _
XJ2576835
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
 1 daily
Refill 6 times
Yes x No _
XJ2576835
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
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
60
Invalid Quantity (Max 7 days supply)
 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
30
 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
30
 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
30
 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
30
 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
60
Invalid Quantity (Max 7 days supply)
 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
30
 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
30
 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.