create or replace view sd_hospital.vw_zs_icd100_dzbl as
select 0 ZDID00,JBMC00,0 CJR000 ,0 CJKS00,PYSM00,
       WBSM00,'2' YXFW00,'Y' YXBZ00,ICD100 AS ICD900 ,'' BZ0000,
       'Y' SFBZ00,SFCRB0, DECODE(I.SFCRB0,'0','0','1','$0000FF') COLOUR,
       SFYX00,XTBZ00,SFMXB0,
       decode(i.SFCRB0,'1','甲类传染病','2','乙类传染病','3','丙类传染病',' ') CRBMC0  --传染病
from   XT_ICD100 I where  SFYX00 = '1' and icd900 not like 'M%/%'
and substr(icd900,1,1) not in ('V','W','X','Y')