Long acting opioids less than 50mg per day OME
Codelist metadata
- Coding system
- Pseudo BNF
- Coding system release
- 86 (2024-01-01)
- Organisation
- OpenSAFELY
- Codelist ID
- opensafely/long-acting-opioids-less-than-50mg-per-day-ome
- Version ID
- 0a6dfcc4
About
Description
User requirements
A codelist is needed of all long acting opioids with an oral morphine equivalence (OME) of <50mg per day - used for analgesia (any route) excluding cough suppression, motility, general anaesthesia, opiate use disorder - this is for a project looking at opioid prescribing for patients on hospital waiting lists.
Sensitivity versus specificity
Any opioid as a modified release formulation or transdermal patch with daily OME < 50mg based on standard dosing.
Relevant definitions or links to important reference sources
Opioid equivalence - https://fpm.ac.uk/opioids-aware-structured-approach-opioid-prescribing/dose-equivalents-and-changing-opioids
Existing relevant codelists
Nil found
Methodology
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) /* 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) /* MXL (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) /* 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) /* Oxycodone MR oral preps [only Onexila as 24hr] (ing code) */
OR (vpi.ing IN (441757005, 442699004,40755011000001109) AND route.descr LIKE '%modified-release.oral' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <63) /* 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) /* 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) /* 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) /* 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) /* Dihydrocodeine (ing code) */
OR (vpi.ing = (387173000) AND route.descr LIKE 'patch.transdermal' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <=20) /* Buprenorphine patches (ing code) */
OR (vpi.ing = 373492002 AND route.descr = 'patch.transdermal' AND strnt_nmrtr_val/(COALESCE(strnt_dnmtr_val,1)) <=12)) /* Fentanyl patches (ing code) */
GROUP BY code, term
Inclusion criteria for codes
Any modified release or transdermal opioid with daily OME <50mg/day (based on licensed dosing).
Exclusion criteria for codes
N/A
Borderline cases
N/A
References
Signed off by
- Chris Wood, (Feb. 6, 2024)
- Vicky Speed, (Feb. 6, 2024)
Codelists are developed by a broad community of users for individual study purposes, which may or may not meet the needs of other studies. They should not be thought of as universal definitions of a particular condition.
We don't offer any guarantees about what they do or don't identify. Users should carefully check that any codelist meets their needs, and seek clinical input where appropriate.
Codes not in the full codelist are in faint grey.
Chapter 04: Central Nervous System
0407020ADBMABAF
)0407020ADBMACAS
)0407020ADBMAAAK
)040702040BRAAAC
)040702040BRABAD
)040702040BRACAE
)0407020AGBCAAAI
)0407020AGBCABAC
)040702040BWAAAC
)040702040BWABAE
)0407020B0BEABAI
)0407020B0BEADAK
)0407020B0BEACAJ
)0407020B0BEAAAH
)0407020B0BUABAI
)0407020B0BUACAJ
)0407020B0BUAAAH
)0407020B0BQABAI
)0407020B0BQACAJ
)0407020B0BQAAAH
)0407020B0AAAIAI
)0407020B0AAAKAK
)0407020B0AAAJAJ
)0407020B0AAAHAH
)0407020B0BRABAI
)0407020B0BRACAJ
)0407020B0BRAAAH
)0407020B0BHABAI
)0407020B0BHADAK
)0407020B0BHACAJ
)0407020B0BHAAAH
)0407020ADBGAAAF
)0407020ADBGACAK
)0407020ADBDABAF
)0407020ADBDAAAK
)0407020G0BBACAF
)0407020G0BBAAAD
)0407020G0BBABAE
)0407020G0AAAFAF
)0407020G0AAADAD
)0407020G0AAAEAE
)0407020ADBIADAF
)0407020ADBIACAK
)040702040BEABAC
)040702040BEACAD
)040702040BEADAE
)040702040BEAAAP
)040702040BEAEAD
)040702040BEAFAE
)040702040BEAGAM
)040702040BEAHAN
)0407020A0BBAMAU
)0407020A0BQAAAU
)0407020A0AAAUAU
)0407020Q0BMAAAK
)040702050AAAFAF
)040702050AAAGAG
)040702040BTAAAC
)040702040BTABAD
)040702040BTACAE
)0407020ADBTABAF
)0407020ADBTACAS
)0407020ADBTAAAK
)040702040BGAAAC
)040702040BGABAD
)040702040BGACAE
)0407020ADBPABAF
)0407020ADBPAAAK
)0407020ADBEABAF
)0407020ADBEAGAS
)0407020ADBEAAAK
)0407020Q0BBAAAK
)0407020Q0BBALCF
)0407020Q0BBAKCG
)0407020Q0BBAFCV
)0407020Q0BIAAEG
)040702040BHAAAC
)040702040BHADAC
)040702040BHABAD
)040702040BHAEAD
)040702040BHACAE
)040702040BHAFAE
)040702040BUAAAC
)040702040BUABAD
)040702040BUACAE
)040702040BNAAAC
)040702040BNAFAC
)040702040BNABAD
)040702040BNAEAD
)040702040BNACAE
)040702040BNADAE
)0407020A0BEAAAU
)040702040BPABAH
)040702040BPACAI
)040702040BPADAJ
)040702040BPAAAG
)0407020A0BFAAAU
)0407020Q0BJAADZ
)0407020Q0BNAAAK
)0407020Q0AAEFEF
)0407020Q0AAAKAK
)0407020Q0AACFCF
)0407020Q0AADZDZ
)0407020Q0AACVCV
)0407020Q0AACGCG
)0407020A0BUAAAU
)0407020AFBCAAAA
)0407020AFBCADAC
)040702040BMAAAC
)040702040BQAAAC
)040702040BQABAD
)040702040BQACAE
)0407020ADBQAAAF
)0407020ADBQABAG
)0407020A0BRAAAU
)0407020A0BRAFAU
)0407020A0BRAKAU
)0407020A0BLAEAU
)0407020ADBLAFAF
)0407020ADBLAGAS
)0407020ADBLAAAK
)0407020ADBCAAAF
)0407020ADBCAIAS
)0407020ADBCAEAK
)0407020AFBDABAA
)0407020AFBDAAAC
)0407020AFAAAAAA
)0407020ADAAAFAF
)0407020ADAAASAS
)0407020AFAAACAC
)0407020ADAAAKAK
)0407020ADBFAGAF
)0407020ADBFABAF
)0407020ADBFAFAK
)0407020ADBFAAAK
)0407020ADBSABAF
)0407020ADBSACAS
)0407020ADBSAAAK
)0407020AGBBACAC
)040702050BBACAF
)040702050BBADAG
)0407020B0BLABAI
)0407020B0BLACAJ
)0407020B0BLAAAH
)0407020B0BVABAI
)0407020B0BVACAJ
)0407020B0BVAAAH
)0407020B0BKABAI
)0407020B0BKACAK
)0407020B0BKADAJ
)0407020B0BKAAAH
)0407020ADBKABAF
)0407020ADBKAFAS
)0407020ADBKAAAK
)0407020ADBRABAF
)0407020ADBRACAS
)0407020ADBRAAAK
)0407020Q0BPAAAK
)0407020B0BMABAI
)0407020B0BMADAK
)0407020B0BMACAJ
)0407020B0BMAAAH
)0407020AGAAAIAI
)0407020AHAAAAAA
)0407020AGAAACAC
)0407020AHBBAAAA
)0407020AFBBAAAA
)0407020AFBBACAC
)040702040BSAAAC
)040702040BSABAD
)040702040BSACAE
)040702040BIAAAC
)040702040BIABAE
)040702040BIACAM
)040702040AAAHAH
)040702040AAACAC
)040702040AAAIAI
)040702040AAADAD
)040702040AAAJAJ
)040702040AAAEAE
)040702040AAAGAG
)040702040AAAYAY
)040702040AAAPAP
)040702040BJABAH
)040702040BJACAI
)040702040BJADAJ
)040702040BJAAAG
)040702040BKAAAC
)040702040BKABAD
)040702040BKACAE
)0407020A0BMAEAU
)0407020A0BVAAAU
)040702040BDAHAD
)040702040BDAIAE
)040702040BDAJAM
)040702040BDAKAN
)040702040BDACAH
)040702040BDADAI
)040702040BDAEAJ
)040702040BDABAG
)040702040BLAAAC
)040702040BLABAD
)040702040BLACAE
)0407020ADBNADAF
)0407020ADBNACAK
)0407020Q0BKAAEF
)040702040BBACAC
)040702040BBADAD
)040702040BBAEAE
)040702040BBAKAY
)040702040BBAGAD
)040702040BBAHAE
)040702040BBAIAM
)040702040BBAJAN
)040702040BVACAC
)040702040BVAAAD
)040702040BVADAE
)040702040BVABAP
)