Pharmacy First - Urinary Tract Infection treatment full dmd codelist

Codelist metadata

Coding system

Dictionary of Medicines and Devices

Coding system release

2025 2.1.0

Organisation

OpenSAFELY

Codelist ID

opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist

Version ID

6892f37e

Versions

About

Description

This codelist is used to identify supply of any medication included in the Pharmacy First Patient Group Directions for treatment of urinary tract infection.

It is specific to only the strength/formulations included in the PGDs for urinary tract infection (including both brands and generics).

PGDs:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-1a.-Urinary-tract-infection-nitrofurantoin-patient-group-direction-Pharmacy-First.pdf

Methodology

The following SQL code was used to build the codelist natively in dmd to ensure products without a corresponding BNF code were also included.

SELECT DISTINCT dmd_type, dmd_id, dmd_name, bnf_code FROM `chris.union_amp_vmp` WHERE (vtm = 'Nitrofurantoin' AND ( (formroute IN ('capsule.oral', 'tablet.oral') AND strength_num=50) OR (formroute IN ('capsulemodified-release.oral') AND strength_num=100) ) )

References

Signed off by

  • Chris Wood, (Feb. 11, 2025)
  • Andrew Brown, (Feb. 11, 2025)

Codelists are developed by a broad community of users for individual study purposes, which may or may not meet the needs of other studies. They should not be thought of as universal definitions of a particular condition.

We don't offer any guarantees about what they do or don't identify. Users should carefully check that any codelist meets their needs, and seek clinical input where appropriate.

* dm+d codelists can be downloaded with codes mapped to changed VMPs included - this is the default for an OpenSAFELY project. See the documentation on keeping codelists up to date for more details.

dmd_type dmd_id dmd_name bnf_code
VMP 41953111000001108 Nitrofurantoin 50mg capsules 0501130R0AAAAAA
VMP 41953211000001102 Nitrofurantoin 50mg tablets 0501130R0AAADAD
VMP 39108511000001108 Nitrofurantoin 100mg modified-release capsules 0501130R0AAAGAG
AMP 24209111000001106 Nitrofurantoin 50mg capsules (Advanz Pharma) 0501130R0AAAAAA
AMP 30210411000001105 Macrodantin 50mg capsules (Waymade Healthcare Plc)
AMP 30272211000001100 Macrobid 100mg modified-release capsules (Waymade Healthcare Plc)
AMP 37388111000001102 Macrobid 100mg modified-release capsules (CST Pharma Ltd)
AMP 37541311000001100 Macrobid 100mg modified-release capsules (Mawdsley-Brooks & Company Ltd)
AMP 42856711000001105 Macrobid 100mg modified-release capsules (Necessity Supplies Ltd)
AMP 42864611000001101 Nitrofurantoin 50mg capsules (Necessity Supplies Ltd)
AMP 44125511000001105 Nitrofurantoin 100mg modified-release capsules (CNX Therapeutics Ltd)
AMP 44225811000001106 Nitrofurantoin 100mg modified-release capsules (A A H Pharmaceuticals Ltd)
AMP 623211000001101 Macrodantin 50mg capsules (Advanz Pharma) 0501130R0BCAAAA
AMP 24421611000001107 Nitrofurantoin 50mg capsules (Alliance Healthcare (Distribution) Ltd) 0501130R0AAAAAA
AMP 24549911000001107 Nitrofurantoin 50mg capsules (A A H Pharmaceuticals Ltd) 0501130R0AAAAAA
AMP 35952811000001109 Nitrofurantoin 50mg capsules (Morningside Healthcare Ltd) 0501130R0AAAAAA
AMP 36774211000001109 Nitrofurantoin 50mg capsules (Tillomed Laboratories Ltd) 0501130R0AAAAAA
AMP 37460411000001104 Nitrofurantoin 50mg capsules (DE Pharmaceuticals) 0501130R0AAAAAA
AMP 37556911000001106 Nitrofurantoin 50mg capsules (Accord-UK Ltd) 0501130R0AAAAAA
AMP 39237911000001109 Nitrofurantoin 50mg capsules (Medihealth (Northern) Ltd) 0501130R0AAAAAA
AMP 39498111000001101 Nitrofurantoin 50mg capsules (Zentiva Pharma UK Ltd) 0501130R0AAAAAA
AMP 40291611000001103 Nitrofurantoin 50mg capsules (Viatris UK Healthcare Ltd) 0501130R0AAAAAA
AMP 40622211000001101 Nitrofurantoin 50mg capsules (Bristol Laboratories Ltd) 0501130R0AAAAAA
AMP 40633711000001103 Nitrofurantoin 50mg capsules (Genesis Pharmaceuticals Ltd) 0501130R0AAAAAA
AMP 41479711000001108 Nitrofurantoin 50mg capsules (Medreich Plc) 0501130R0AAAAAA
AMP 41507511000001107 Nitrofurantoin 50mg capsules (Glenmark Pharmaceuticals Europe Ltd) 0501130R0AAAAAA
AMP 41961011000001102 Nitrofurantoin 50mg capsules (Milpharm Ltd) 0501130R0AAAAAA
AMP 42326211000001102 Nitrofurantoin 50mg capsules (Key Pharmaceuticals Ltd) 0501130R0AAAAAA
AMP 42959011000001106 Nitrofurantoin 50mg capsules (Manx Healthcare Ltd) 0501130R0AAAAAA
AMP 180911000001108 Nitrofurantoin 50mg tablets (A A H Pharmaceuticals Ltd) 0501130R0AAADAD
AMP 884111000001105 Nitrofurantoin 50mg tablets (Actavis UK Ltd) 0501130R0AAADAD
AMP 58211000001101 Furadantin 50mg tablets (Advanz Pharma) 0501130R0BBAAAD
AMP 537011000001109 Nitrofurantoin 50mg tablets (Kent Pharma (UK) Ltd) 0501130R0AAADAD
AMP 461311000001101 Urantoin 50mg tablets (Dr Reddy's Laboratories (UK) Ltd) 0501130R0BDAAAD
AMP 497811000001101 Nitrofurantoin 50mg tablets (Alliance Healthcare (Distribution) Ltd) 0501130R0AAADAD
AMP 4209111000001108 Nitrofurantoin 50mg tablets (Teva UK Ltd) 0501130R0AAADAD
AMP 9555111000001106 Nitrofurantoin 50mg tablets (Viatris UK Healthcare Ltd) 0501130R0AAADAD
AMP 11016111000001104 Nitrofurantoin 50mg tablets (Dr Reddy's Laboratories (UK) Ltd) 0501130R0AAADAD
AMP 17946711000001100 Nitrofurantoin 50mg tablets (Phoenix Healthcare Distribution Ltd) 0501130R0AAADAD
AMP 20327411000001106 Nitrofurantoin 50mg tablets (Genesis Pharmaceuticals Ltd) 0501130R0AAADAD
AMP 21820711000001109 Nitrofurantoin 50mg tablets (Waymade Healthcare Plc) 0501130R0AAADAD
AMP 29929911000001104 Nitrofurantoin 50mg tablets (Sigma Pharmaceuticals Plc) 0501130R0AAADAD
AMP 30763811000001109 Nitrofurantoin 50mg tablets (Almus Pharmaceuticals Ltd) 0501130R0AAADAD
AMP 30851211000001100 Nitrofurantoin 50mg tablets (Mawdsley-Brooks & Company Ltd) 0501130R0AAADAD
AMP 32746911000001108 Genfura 50mg tablets (Genesis Pharmaceuticals Ltd) 0501130R0BHABAD
AMP 37460811000001102 Nitrofurantoin 50mg tablets (DE Pharmaceuticals) 0501130R0AAADAD
AMP 39058411000001105 Nitrofurantoin 50mg tablets (Medihealth (Northern) Ltd) 0501130R0AAADAD
AMP 40466111000001101 Nitrofurantoin 50mg tablets (NorthStar Healthcare Unlimited Company) 0501130R0AAADAD
AMP 41511011000001106 Nitrofurantoin 50mg tablets (Glenmark Pharmaceuticals Europe Ltd) 0501130R0AAADAD
AMP 42566811000001105 Nitrofurantoin 50mg tablets (AAH Hillcross) 0501130R0AAADAD
AMP 517311000001102 Macrobid 100mg modified-release capsules (Advanz Pharma) 0501130R0BGAAAG
AMP 41334211000001109 Nitrofurantoin 100mg modified-release capsules (Advanz Pharma) 0501130R0AAAGAG

* Note that this is the full list of explicitly included dm+d codes for this codelist. An OpenSAFELY project will by default also include previous or subsequent codes for any included VMPs that may have changed code. See the documentation on keeping codelists up to date for more details.