*MEDICATION*: Pharmacy First - Urinary Tract Infection treatment

[chrisjwood16]

User requirements

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

Sensitivity versus specificity

Specific to only the strength/formulations included in the PGD.

Relevant definitions or links to important reference sources

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

• Nitrofurantoin 50mg immediate release tablets or capsules
• Nitrofurantoin 100mg modified release capsules

Coding system

dm+d

Existing relevant codelists

N/A

Search terms / synonyms / search strategy

Nitrofurantoin

Inclusion criteria for codes

• Nitrofurantoin 50mg immediate release tablets or capsules (generic or brand)
• Nitrofurantoin 100mg modified release capsules (generic or brand)

Exclusion criteria for codes

Nitrofurantoin 100mg immediate release tablets or capsules
Nitrofurantoin oral solution/liquid

Borderline cases

No response

Final codelist

Published:
BNF code format: https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment/062dd5b0/
dm+d format: https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment-dmd/54cc39d7/

[a-d-brown]

Checked - all correct. @chrisjwood16

[chrisjwood16]

Published:
BNF code format: https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment/062dd5b0/
dm+d format: https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment-dmd/54cc39d7/

[chrisjwood16]

As explained here, due to complexities in the data we need to build this codelist directly in dmd to ensure we include products which don't have a BNF code.

We can use a view which contains required dmd fields and then query this to select products matching our inclusion criteria:

• Nitrofurantoin 50mg immediate release tablets or capsules (generic or brand)
• Nitrofurantoin 100mg modified release capsules (generic or brand)

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

PF_treatment_UTI.csv

[chrisjwood16]

Checked against existing codelist. These are in the new codelist not in previous version:
dmd_type,dmd_id,dmd_name,bnf_code
AMP,37388111000001102,Macrobid 100mg modified-release capsules (CST Pharma 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,42959011000001106,Nitrofurantoin 50mg capsules (Manx Healthcare Ltd),0501130R0AAAAAA
AMP,42566811000001105,Nitrofurantoin 50mg tablets (AAH Hillcross),0501130R0AAADAD
AMP,30210411000001105,Macrodantin 50mg capsules (Waymade Healthcare Plc),
AMP,30272211000001100,Macrobid 100mg modified-release capsules (Waymade Healthcare Plc),
AMP,37541311000001100,Macrobid 100mg modified-release capsules (Mawdsley-Brooks & Company Ltd),

No codes in previous version which aren't in the new version.

[a-d-brown]

Checked, all looks correct.

[chrisjwood16]

Final version:
https://www.opencodelists.org/codelist/opensafely/pharmacy-first-urinary-tract-infection-treatment-full-dmd-codelist/6892f37e/