SQL code

left(der.Spell_Dominant_Procedure,4) in
('C121','C122','C124','C191','C198’) and
left(der.Spell_Primary_Diagnosis,4) in ('H001')

Global cancer exclusion

APC
apcs.der_diagnosis_all not like '%C[0-9][0-9]%' and
apcs.der_diagnosis_all not like '%D0%' and
apcs.der_diagnosis_all not like '%D3[789]%' and
apcs.der_diagnosis_all not like '%D4[012345678]%’

Share