Opiate coding

[richiecroker]

Numerator

bnf_code LIKE '0407020Q0%AI' -- Morph Sulf_Tab 60mg M/R --

OR bnf_code LIKE '0407020Q0%DC' -- Morph Sulf_Gran Sach 60mg M/R --

OR bnf_code LIKE '0407020Q0%EH' -- Morph Sulf_Cap 60mg M/R --

OR bnf_code LIKE '0407020Q0%DU' -- Morph Sulf_Cap 90mg M/R --

OR bnf_code LIKE '0407020Q0%AH' -- Morph Sulf_Tab 100mg M/R --

OR bnf_code LIKE '0407020Q0%DD' -- Morph Sulf_Gran Sach 100mg M/R --

OR bnf_code LIKE '0407020Q0%EB' -- Morph Sulf_Cap 100mg M/R --

OR bnf_code LIKE '0407020Q0%DV' -- Morph Sulf_Cap 120mg M/R --

OR bnf_code LIKE '0407020Q0%DW' -- Morph Sulf_Cap 150mg M/R --

OR bnf_code LIKE '0407020Q0%AG' -- Morph Sulf_Tab 200mg M/R --

OR bnf_code LIKE '0407020Q0%DE' -- Morph Sulf_Gran Sach 200mg M/R --

OR bnf_code LIKE '0407020Q0%EI' -- Morph Sulf_Cap 200mg M/R --

OR bnf_code LIKE '0407020AD%AH' -- Oxycodone HCl_Tab 40mg M/R --

OR bnf_code LIKE '0407020AD%AI' -- Oxycodone HCl_Tab 80mg M/R --

OR bnf_code LIKE '0407020AD%AP' -- Oxycodone HCl_Tab 120mg M/R --

OR bnf_code LIKE '0407020AD%AQ' -- Oxycodone HCl_Tab 60mg M/R --

OR bnf_code LIKE '0407020AD%AR' -- Oxycodone HCl_Tab 30mg M/R --

OR bnf_code LIKE '0407020AF%AD' -- Oxycodone HCl/NaloxoneHCl_Tab 40/20mgM/R --

OR bnf_code LIKE '0407020AG%AE' -- Tapentadol HCl_Tab 150mg M/R --

OR bnf_code LIKE '0407020AG%AF' -- Tapentadol HCl_Tab 200mg M/R --

OR bnf_code LIKE '0407020AG%AG' -- Tapentadol HCl_Tab 250mg M/R --

OR bnf_code LIKE '0407020A0%AF' -- Fentanyl_Transdermal Patch 50mcg/hr --

OR bnf_code LIKE '0407020A0%AG' -- Fentanyl_Transdermal Patch 75mcg/hr --

OR bnf_code LIKE '0407020A0%AH' -- Fentanyl_Transdermal Patch 100mcg/hr --

OR bnf_code LIKE '0407020A0%BW' -- Fentanyl_Transdermal Patch 37.5mcg/hr --

OR bnf_code LIKE '0407020B0%AF' -- Buprenorphine_Patch 52.5mcg/hr (96hr) --

OR bnf_code LIKE '0407020B0%AG' -- Buprenorphine_Patch 70mcg/hr (96hr) --

denominator

OR bnf_code LIKE '0407020Q0%CG' -- Morph Sulf_Tab 5mg M/R --

OR bnf_code LIKE '0407020Q0%AK' -- Morph Sulf_Tab 10mg M/R --

OR bnf_code LIKE '0407020Q0%EF' -- Morph Sulf_Cap 10mg M/R --

OR bnf_code LIKE '0407020Q0%CF' -- Morph Sulf_Tab 15mg M/R --

OR bnf_code LIKE '0407020Q0%FL' -- Morph Sulf_Gran Sach 15mg M/R --

OR bnf_code LIKE '0407020Q0%CV' -- Morph Sulf_Gran Sach 20mg M/R --

OR bnf_code LIKE '0407020Q0%DZ' -- Morph Sulf_Cap 20mg M/R --

OR bnf_code LIKE '0407020Q0%AL' -- Morph Sulf_Tab 30mg M/R --

OR bnf_code LIKE '0407020Q0%CP' -- Morph Sulf_Gran Sach 30mg M/R --

OR bnf_code LIKE '0407020Q0%EG' -- Morph Sulf_Cap 30mg M/R --

OR bnf_code LIKE '0407020Q0%EA' -- Morph Sulf_Cap 50mg M/R --

OR bnf_code LIKE '0407020Q0%AI' -- Morph Sulf_Tab 60mg M/R --

OR bnf_code LIKE '0407020Q0%DC' -- Morph Sulf_Gran Sach 60mg M/R --

OR bnf_code LIKE '0407020Q0%EH' -- Morph Sulf_Cap 60mg M/R --

OR bnf_code LIKE '0407020Q0%DU' -- Morph Sulf_Cap 90mg M/R --

OR bnf_code LIKE '0407020Q0%AH' -- Morph Sulf_Tab 100mg M/R --

OR bnf_code LIKE '0407020Q0%DD' -- Morph Sulf_Gran Sach 100mg M/R --

OR bnf_code LIKE '0407020Q0%EB' -- Morph Sulf_Cap 100mg M/R --

OR bnf_code LIKE '0407020Q0%DV' -- Morph Sulf_Cap 120mg M/R --

OR bnf_code LIKE '0407020Q0%DW' -- Morph Sulf_Cap 150mg M/R --

OR bnf_code LIKE '0407020Q0%AG' -- Morph Sulf_Tab 200mg M/R --

OR bnf_code LIKE '0407020Q0%DE' -- Morph Sulf_Gran Sach 200mg M/R --

OR bnf_code LIKE '0407020Q0%EI' -- Morph Sulf_Cap 200mg M/R --

OR bnf_code LIKE '0407020AD%AF' -- Oxycodone HCl_Tab 10mg M/R --

OR bnf_code LIKE '0407020AD%AG' -- Oxycodone HCl_Tab 20mg M/R --

OR bnf_code LIKE '0407020AD%AH' -- Oxycodone HCl_Tab 40mg M/R --

OR bnf_code LIKE '0407020AD%AI' -- Oxycodone HCl_Tab 80mg M/R --

OR bnf_code LIKE '0407020AD%AK' -- Oxycodone HCl_Tab 5mg M/R --

OR bnf_code LIKE '0407020AD%AP' -- Oxycodone HCl_Tab 120mg M/R --

OR bnf_code LIKE '0407020AD%AQ' -- Oxycodone HCl_Tab 60mg M/R --

OR bnf_code LIKE '0407020AD%AR' -- Oxycodone HCl_Tab 30mg M/R --

OR bnf_code LIKE '0407020AD%AS' -- Oxycodone HCl_Tab 15mg M/R --

OR bnf_code LIKE '0407020AF%AA' -- Oxycodone HCl/Naloxone HCl_Tab 10/5mgM/R --

OR bnf_code LIKE '0407020AF%AB' -- Oxycodone HCl/NaloxoneHCl_Tab 20/10mgM/R --

OR bnf_code LIKE '0407020AF%AC' -- Oxycodone HCl/NaloxoneHCl_Tab 5/2.5mgM/R --

OR bnf_code LIKE '0407020AF%AD' -- Oxycodone HCl/NaloxoneHCl_Tab 40/20mgM/R --

OR bnf_code LIKE '0407020AG%AC' -- Tapentadol HCl_Tab 50mg M/R --

OR bnf_code LIKE '0407020AG%AD' -- Tapentadol HCl_Tab 100mg M/R --

OR bnf_code LIKE '0407020AG%AE' -- Tapentadol HCl_Tab 150mg M/R --

OR bnf_code LIKE '0407020AG%AF' -- Tapentadol HCl_Tab 200mg M/R --

OR bnf_code LIKE '0407020AG%AG' -- Tapentadol HCl_Tab 250mg M/R --

OR bnf_code LIKE '0407020A0%AE' -- Fentanyl_Transdermal Patch 25mcg/hr --

OR bnf_code LIKE '0407020A0%AF' -- Fentanyl_Transdermal Patch 50mcg/hr --

OR bnf_code LIKE '0407020A0%AG' -- Fentanyl_Transdermal Patch 75mcg/hr --

OR bnf_code LIKE '0407020A0%AH' -- Fentanyl_Transdermal Patch 100mcg/hr --

OR bnf_code LIKE '0407020A0%AU' -- Fentanyl_Transdermal Patch 12mcg/hr --

OR bnf_code LIKE '0407020A0%BW' -- Fentanyl_Transdermal Patch 37.5mcg/hr --

OR bnf_code LIKE '0407020B0%AE' -- Buprenorphine_Patch 35mcg/hr (96hr) --

OR bnf_code LIKE '0407020B0%AF' -- Buprenorphine_Patch 52.5mcg/hr (96hr) --

OR bnf_code LIKE '0407020B0%AG' -- Buprenorphine_Patch 70mcg/hr (96hr) --

OR bnf_code LIKE '0407020B0%AH' -- Buprenorphine_Patch 5mcg/hr (7day) --

OR bnf_code LIKE '0407020B0%AI' -- Buprenorphine_Patch 10mcg/hr (7day) --

OR bnf_code LIKE '0407020B0%AJ' -- Buprenorphine_Patch 20mcg/hr (7day) --