Pharmacy First - Acute Otitis Media treatment full dmd codelist

PH3636 / 8735

OpenSAFELY

Jan 26, 2026

REGISTERING DOI...

OpenCodelists Phenotype

  1. Overview

    Codelist ID
    opensafely/pharmacy-first-acute-otitis-media-treatment-full-dmd-codelist
    Version ID
    17ff19f3
    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 acute otitis media.

    It is specific to only the strength/formulations included in the PGDs for acute otitis media (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-7a.-Acute-otitis-media-phenazone-lidocaine-ear-drops-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7b.-Acute-otitis-media-amoxicillin-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7c.-Acute-otitis-media-clarithromycin-patient-group-direction-Pharmacy-First.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7d.-Acute-otitis-media-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 = 'Phenazone + Lidocaine'
    AND formroute IN ('solutiondrops.auricular')
  )
  OR
  (
    vtm = 'Amoxicillin'
    AND formroute IN ('capsule.oral')
    AND strength_num IN (250, 500)
  )
  OR
  (
    vtm = 'Amoxicillin'
    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
  )
  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 -- as using ingredient code check it isn't a combo product
    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 -- as using ingredient code check it isn't a combo product
    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-7a.-acute-otitis-media-phenazone-lidocaine-ear-drops-patient-group-direction-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7b.-acute-otitis-media-amoxicillin-patient-group-direction-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7c.-acute-otitis-media-clarithromycin-patient-group-direction-pharmacy-first.pdf

    https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-7d.-acute-otitis-media-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.

    Codelist updated using existing SQL query.

  4. References

    Source Reference

    https://www.opencodelists.org/codelist/opensafely/pharmacy-first-acute-otitis-media-treatment-full-dmd-codelist/17ff19f3

    References

  5. Clinical Codelist

  6. API

    To Export Phenotype Details:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3636/version/8735/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(
     'PH3636',
     version_id=8735
    )

    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(
     'PH3636',
     version_id=8735
    )

    To Export Phenotype Code List:

    FormatAPI
    JSON site_root/api/v1/phenotypes/PH3636/version/8735/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(
     'PH3636',
     version_id=8735
    )

    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(
     'PH3636',
     version_id=8735
    )

  7. Version History

    Version IDNameOwnerPublish date
    8736 Pharmacy First - Acute Otitis Media treatment full dmd codelist ieuan.scanlon2026-01-26 23:27
    Pharmacy First - Acute Otitis Media treatment full dmd codelist ieuan.scanlon2026-01-26 23:27