Pharmacy First - Infected insect bites treatment full dmd codelist

This codelist was taken from OpenCodelists, created by OpenSAFELY. We recommend viewing this Phenotype on the OpenCodelist website to view the most recent version.

This codelist is used to identify supply of any medication included in the Pharmacy First Patient Group Directions for treatment of infected insect bites.

It is specific to only the strength/formulations included in the PGDs for infected insect bites (including both brands and generics).

© University of Oxford for the Bennett Institute for Applied Data Science 2025. This work may be copied freely for non-commercial research and study.

PGDs:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4a.-Infected-insect-bites-flucloxacillin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4b.-Infected-insect-bites-clarithromycin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4c.-Infected-insect-bites-erythromycin-patient-group-direction-Pharmacy-First.pdf

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 = 'Flucloxacillin'
  AND formroute IN ('capsule.oral') 
  AND strength_num IN (250, 500) 
)
OR
(
  vtm = 'Flucloxacillin'
  AND formroute IN ('solution.oral', 'suspension.oral')
  AND (((5/strength_den)*strength_num) IN (125, 250)) -- strength is often expressed as mg/ml - this calculation converts to dose per 5ml as expressed in inclusion criteria
)
OR
(
  vtm = 'Clarithromycin'
  AND formroute IN ('tablet.oral')
  AND strength_num IN (250, 500)
)
OR
(
  vtm = 'Clarithromycin' 
  AND formroute IN ('solution.oral', 'suspension.oral')
  AND (((5/strength_den)*strength_num) IN (125, 250)) -- strength is often expressed as mg/ml - this calculation converts to dose per 5ml as expressed in inclusion criteria
)
OR
(
  ingredient = 372694001 -- use ingredient code for erythromycin base substance here not vtm as a number of different erythromycin salts
  AND
  ingredient_count = 1
  AND
  formroute IN ('tablet.oral', 'tabletgastro-resistant.oral')
  AND
  strength_num IN (250, 500)
)
OR
(
  ingredient = 372694001 -- use ingredient code for erythromycin base substance here not vtm as a number of different erythromycin salts
  AND
  ingredient_count = 1
  AND
  formroute IN ('solution.oral', 'suspension.oral')
  AND 
  (((5/strength_den)*strength_num) IN (125, 250, 500)) -- strength is often expressed as mg/ml - this calculation converts to dose per 5ml as expressed in inclusion criteria
)

Reviewed and updated 20/10/2025 Updated PGDs reviewed:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4a.-infected-insect-bites-flucloxacillin-patient-group-direction-pharmacy-first.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4b.-infected-insect-bites-clarithromycin-patient-group-direction-pharmacy-first.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-4c.-infected-insect-bites-erythromycin-patient-group-direction-pharmacy-first.pdf

These products have been removed from latest PGDs:

Erythromycin 500mg/5mL oral suspension (or oral solution)

Erythromycin 500mg/5mL sugar free oral suspension (or oral solution)

Decision made to keep them in the codelist to capture any use prior to PGD update.