Pharmacy First - Sinusitis 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 sinusitis.

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

PGDs:

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6a.-Sinusitis-fluticasone-nasal-spray-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6b.-Sinusitis-mometasone-nasal-spray-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6c.-Sinusitis-phenoxymethylpenicillin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6d.-Sinusitis-clairthromycin-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6e.-Sinusitis-doxycycline-patient-group-direction-Pharmacy-First.pdf

https://www.england.nhs.uk/wp-content/uploads/2023/11/PRN01010-6f.-Sinusitis-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 ( ingredient = 426409006 -- fluticasone furoate AND ingredient_count = 1 -- ensure not combo product AND strength_num = 27.5 AND formroute LIKE '%.nasal' ) OR ( ingredient = 395802006 -- Mometasone furoate AND ingredient_count = 1 AND formroute LIKE '%.nasal' AND strength_num = 50 ) OR ( 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 ( vtm = 'Doxycycline' AND strength_num IN (50, 100) AND formroute IN ('capsule.oral') ) OR ( vtm = 'Doxycycline' AND strength_num IN (100) AND form = 'Dispersible tablet' ) OR ( ingredient = 372694001 -- use ingredient code for erythromycin base substance here not vtm as a number of different erythromycin salts 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 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)