Pharmacy First - Sore throat treatment full dmd codelist

About

Description

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

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

PGDs:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-5a.-Sore-throat-phenoxymethylpenicillin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-5b.-Sore-throat-clarithromycin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-5c.-Sore-throat-erythromycin-patient-group-direction-Pharmacy-First.pdf

Methodology

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 = 'Phenoxymethylpenicillin' AND formroute IN ('tablet.oral') AND strength_num IN (250) ) OR ( vtm = 'Phenoxymethylpenicillin' 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 )

References

• GitHub issue

Signed off by

• Chris Wood, (Feb. 11, 2025)
• Andrew Brown, (Feb. 11, 2025)