Search terms / synonyms / search strategy
BigQuery used to identify relevant products from BNF data. dm+d data used to filter for modified release/patch versions as appropriate. Faculty of Pain Medicine OME conversions used to calculate daily OME - usual licensed dosing used to determine OME (for example morphine sulphate MR products licensed for twice a day administration (with exception of MXL) - so if prescribed 60mg tablet assume taking twice a day (120mg / day total) - or for MXL assume taking once a day so would be prescribed 120mg tablet to meet 120mg/day total.
SELECT DISTINCT presentation_code as code, presentation as term
FROM hscic.bnf p
INNER JOIN dmd.vmp vmp ON CONCAT(SUBSTR(p.presentation_code,0,9),'AA', SUBSTR(p.presentation_code,-2), SUBSTR(p.presentation_code,-2)) = vmp.bnf_code
INNER JOIN dmd.vpi AS vpi ON vmp.id = vpi.vmp
INNER JOIN dmd.ont AS ont ON vmp.id = ont.vmp
INNER JOIN dmd.ontformroute AS route ON ont.form = route.cd
WHERE
((vpi.ing = (60886004) AND route.descr LIKE '%modified-release.oral' AND p.presentation NOT LIKE '%MXL%' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=25 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <60) /* Morphine Sulfate MR oral preps [excluding MXL as 24hr] (ing code) */
OR (vpi.ing = (60886004) AND route.descr LIKE '%modified-release.oral' AND p.presentation LIKE '%MXL%' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=50 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <120) /* MXL (24hr release) (ing code) */
OR (vpi.ing = 387024006 AND route.descr LIKE '%modified-release.oral' AND p.presentation NOT LIKE '%Onexila%' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=17 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <40) /* Oxycodone MR oral preps [excluding Onexila as 24hr] (ing code) */
OR (vpi.ing = 387024006 AND route.descr LIKE '%modified-release.oral' AND p.presentation LIKE '%Onexila%' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=33 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <80) /* Onexila MR (24hr release) (ing code) */
OR (vpi.ing IN (442699004,441757005,40755011000001109) AND route.descr LIKE '%modified-release.oral' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=63 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <150) /* Tapentadol HCl/Phosphate MR oral preps (ing code) */
OR (vpi.ing IN (386858008, 108505002) AND route.descr LIKE '%modified-release.oral' AND (p.presentation NOT LIKE '%Tradorec XL%' AND p.presentation NOT LIKE '%Zamadol 24hr%' AND p.presentation NOT LIKE '%Zydol XL%' AND p.presentation NOT LIKE '%Dromadol XL%') AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=250 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <600) /* Tramadol HCl/ Tramadol MR 12 hour oral preps (ing code) */
OR (vpi.ing IN (386858008, 108505002) AND route.descr LIKE '%modified-release.oral' AND (p.presentation LIKE '%Tradorec XL%' OR p.presentation LIKE '%Zamadol 24hr%' OR p.presentation LIKE '%Zydol XL%' OR p.presentation LIKE '%Dromadol XL%') AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=500 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <1200) /* Tramadol HCl/ Tramadol MR 24 hour oral preps (ing code) */
OR (vpi.ing IN (44508008, 387485001) AND route.descr LIKE '%modified-release.oral' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=5 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <12) /* Hydromorphone (ing code) */
OR (vpi.ing IN (322538006, 387322000) AND route.descr LIKE '%modified-release.oral' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=250 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <600) /* Dihydrocodeine (ing code) */
OR (vpi.ing = (387173000) AND route.descr LIKE 'patch.transdermal' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >20 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <52) /* Buprenorphine patches (ing code) */
OR (vpi.ing = 373492002 AND route.descr = 'patch.transdermal' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) >=25 AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <50)) /* Fentanyl patches (ing code) */
GROUP BY code, term
Inclusion criteria for codes
Any modified release or transdermal opioid with daily OME 50-119mg (based on licensed dosing).
Exclusion criteria for codes
NA
Borderline cases
NA