Pharmacy First - Shingles 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 shingles.

It is specific to only the strength/formulations included in the PGDs for shingles (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-2a.-Shingles-aciclovir-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-2b.-Shingles-valaciclovir-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 = 'Aciclovir' AND 
  (
    (
      form IN ('Oral tablet', 'Dispersible tablet') 
      AND 
      strength_num IN (200, 400, 800)
    )
  )
) 
OR
(vtm = 'Valaciclovir' AND 
  (
    (
      formroute IN ('tablet.oral') 
      AND 
      strength_num IN (500)
    )
  )
) 

*** Reviewed and updated 20/10/2025 ***

Updated PGDs Sept 2025:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-2a.-shingles-aciclovir-patient-group-direction-pharmacy-first.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-2b.-shingles-valaciclovir-patient-group-direction-pharmacy-first.pdf

Valaciclovir 1g tablets now included.

SELECT DISTINCT
dmd_type, dmd_id, dmd_name, bnf_code
FROM
`chris.union_amp_vmp`
WHERE
(vtm = 'Aciclovir' AND 
  (
    (
      form IN ('Oral tablet', 'Dispersible tablet') 
      AND 
      strength_num IN (200, 400, 800)
    )
  )
) 
OR
(vtm = 'Valaciclovir' AND 
  (
    (
      formroute IN ('tablet.oral') 
      AND 
      strength_num IN (500, 1)
    )
  )
)