Pharmacy First - Impetigo treatment full dmd codelist

PH3644 / 8745

OpenSAFELY

Jan 26, 2026

REGISTERING DOI...

OpenCodelists Phenotype

  1. Overview

    Codelist ID
    opensafely/pharmacy-first-impetigo-treatment-full-dmd-codelist
    Version ID
    20051342
    Coding System
    dm+d codes
    Collections
    OpenCodelistPhenotype Library
    Tags
    No data

  2. Definition

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

    It is specific to only the strength/formulations included in the PGDs for impetigo (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.

  3. Methodology

    PGDs: https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3a.-Impetigo-hydrogen-peroxide-cream-protocol-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3b.-Impetigo-fusidic-acid-cream-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3c.-Impetigo-flucloxacillin-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3d.-Impetigo-clarithromycin-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3e.-Impetigo-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 = 'Hydrogen peroxide'
  AND
  formroute IN ('cream.cutaneous')
  AND
  strength_num = 10 -- 10 here corresponds to 1% cream
)
OR
(
  vtm = 'Fusidic acid'
  AND
  formroute IN ('cream.cutaneous')
  AND
  strength_num = 20 -- 20 here corresponds to 2% cream
)
OR
(
  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)
)
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
)

    Updated 20/10/2025

    Updated PGDs reviewed:

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3a.-impetigo-hydrogen-peroxide-cream-protocol-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3b.-Impetigo-fusidic-acid-cream-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3c.-impetigo-flucloxacillin-patient-group-direction-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3d.-impetigo-clarithromycin-patient-group-direction-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-3e.-impetigo-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.

    Existing SQL query used to capture updated product list

  4. References

    Source Reference

    https://www.opencodelists.org/codelist/opensafely/pharmacy-first-impetigo-treatment-full-dmd-codelist/20051342

    References

  5. Clinical Codelist

  6. API

    To Export Phenotype Details:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3644/version/8745/detail/?format=json
    R Package

    # Download here

    library(ConceptLibraryClient)


    # Connect to API

    client = ConceptLibraryClient::Connection$new(public=TRUE)


    # Get details of Phenotype

    phenotype_details = client$phenotypes$get_detail(
     'PH3644',
     version_id=8745
    )

    Py Package

    # Download here

    from pyconceptlibraryclient import Client


    # Connect to API

    client = Client(public=True)


    # Get details of Phenotype

    phenotype_detail = client.phenotypes.get_detail(
     'PH3644',
     version_id=8745
    )

    To Export Phenotype Code List:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3644/version/8745/export/codes/?format=json
    R Package

    # Download here

    library(ConceptLibraryClient)


    # Connect to API

    client = ConceptLibraryClient::Connection$new(public=TRUE)


    # Get codelist of Phenotype

    phenotype_codelist = client$phenotypes$get_codelist(
     'PH3644',
     version_id=8745
    )

    Py Package

    # Download here

    from pyconceptlibraryclient import Client


    # Connect to API

    client = Client(public=True)


    # Get codelist of Phenotype

    phenotype_codelist = client.phenotypes.get_codelist(
     'PH3644',
     version_id=8745
    )

  7. Version History

    Version IDNameOwnerPublish date
    Pharmacy First - Impetigo treatment full dmd codelist ieuan.scanlon2026-01-26 23:27
    8744 Pharmacy First - Impetigo treatment full dmd codelist ieuan.scanlon2026-01-26 23:27