*MEDICATION*: Pharmacy First - Shingles treatment

[chrisjwood16]

User requirements

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

Sensitivity versus specificity

Specific to only the strength/formulations included in the PGDs for shingles.

Relevant definitions or links to important reference sources

PGD: 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

• Aciclovir 200mg tablets/dispersible tablets
• Aciclovir 400mg tablets/dispersible tablets
• Aciclovir 800mg tablets/dispersible tablets
• Valaciclovir 500mg tablets

Coding system

dm+d

Existing relevant codelists

N/A

Search terms / synonyms / search strategy

Aciclovir
Valaciclovir

Inclusion criteria for codes

• Aciclovir 200mg tablets/dispersible tablets
• Aciclovir 400mg tablets/dispersible tablets
• Aciclovir 800mg tablets/dispersible tablets
• Valaciclovir 500mg tablets

Exclusion criteria for codes

Topical formulations
Intravenous formulations
Oral solutions
Strengths/formulations not listed above.

Borderline cases

N/A

Final codelist

Published:
BNF code:
https://www.opencodelists.org/codelist/opensafely/pharmacy-first-shingles-treatment/6d1e627a/
dm+d code:
https://www.opencodelists.org/codelist/opensafely/pharmacy-first-shingles-treatment-dmd/3bbcc6a2/

[a-d-brown]

Checked - all correct. @chrisjwood16

[chrisjwood16]

Published:
BNF code:
https://www.opencodelists.org/codelist/opensafely/pharmacy-first-shingles-treatment/6d1e627a/
dm+d code:
https://www.opencodelists.org/codelist/opensafely/pharmacy-first-shingles-treatment-dmd/3bbcc6a2/

[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:

• Aciclovir 200mg tablets/dispersible tablets
• Aciclovir 400mg tablets/dispersible tablets
• Aciclovir 800mg tablets/dispersible tablets
• Valaciclovir 500mg tablets

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

PF_treatment_shingles.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,14691011000001108,Valtrex 500mg tablets (Sigma Pharmaceuticals Plc),
AMP,14742411000001105,Zovirax 200mg dispersible tablets (Sigma Pharmaceuticals Plc),
AMP,14744811000001101,Zovirax 800mg dispersible tablets (Sigma Pharmaceuticals Plc),
AMP,39656711000001108,Valaciclovir 500mg tablets (Pilsco Ltd),
AMP,39836711000001103,Valaciclovir 500mg tablets (CST Pharma Ltd),
AMP,39880511000001100,Valtrex 500mg tablets (CST Pharma Ltd),
AMP,42889111000001108,Valaciclovir 500mg tablets (Necessity Supplies Ltd),
AMP,43935111000001103,Valaciclovir 500mg tablets (Drugsrus Ltd),
AMP,42484911000001101,Valaciclovir 500mg tablets (Accord-UK Ltd),0503021A0AAAAAA
AMP,5422511000001106,Valaciclovir 500mg tablets (Waymade Healthcare Plc),
AMP,5513011000001105,Valaciclovir 500mg tablets (Dowelhurst Ltd),
AMP,5517511000001107,Aciclovir 200mg tablets (Dowelhurst Ltd),
AMP,5595111000001108,Valtrex 500mg tablets (Dowelhurst Ltd),
AMP,5621711000001106,Zovirax 200mg dispersible tablets (Waymade Healthcare Plc),
AMP,5621911000001108,Zovirax 800mg dispersible tablets (Waymade Healthcare Plc),
AMP,5626611000001109,Zovirax 200mg dispersible tablets (Dowelhurst Ltd),
AMP,13102711000001101,Aciclovir 200mg dispersible tablets (Dowelhurst Ltd),
AMP,13102911000001104,Aciclovir 400mg dispersible tablets (Dowelhurst Ltd),
AMP,13103311000001105,Aciclovir 800mg dispersible tablets (Dowelhurst Ltd),
AMP,14744511000001104,Zovirax 400mg dispersible tablets (Sigma Pharmaceuticals Plc),
AMP,16330111000001107,Valtrex 500mg tablets (Lexon (UK) Ltd),
AMP,16682411000001104,Zovirax 800mg dispersible tablets (Stephar (U.K.) Ltd),
AMP,18176411000001102,Valtrex 500mg tablets (Mawdsley-Brooks & Company Ltd),
AMP,18216611000001105,Zovirax 200mg dispersible tablets (Necessity Supplies Ltd),
AMP,40476611000001102,Valtrex 500mg tablets (DE Pharmaceuticals),

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-shingles-treatment-full-dmd-codelist/01a266b4/