create or replace view vw_ys_jbzdzd as
select to_number(z.zdid00) zdid00,z.zdmc00 jbmc00,z.cjr000,cjks00,z.pysm00,
       z.wbsm00,z.yxfw00,z.yxbz00,z.icd100 as icd900,z.bz0000,
--       z.SFBZ00,z.sfcrb0, decode(z.sfcrb0,'0','0','1','$0000FF','2','$0000FF','3','$0000FF','4','$0000FF') colour,z.PXH000,
       z.SFBZ00,z.sfcrb0, decode(z.sfcrb0,'0','0','1','$0000FF','2','$0045FF','3','$FF0000','4','$0000FF') colour,z.PXH000,
       decode(z.sfcrb0,'1','甲类传染病','2','乙类传染病','3','丙类传染病','4','其它传染病',' ') crbmc0  --传染病
from   vw_bm_xyzdbm_eff z where yxbz00='1'
union all
select 0,jbmc00,0,0,pysm00,
       wbsm00,'2','Y',icd900,'',
--       'Y',sfcrb0, decode(i.sfcrb0,'0','0','1','$0000FF','2','$0000FF','3','$0000FF','4','$0000FF') colour,i.pxh000,
       'Y',sfcrb0, decode(i.sfcrb0,'0','0','1','$0000FF','2','$0045FF','3','$FF0000','4','$0000FF') colour,i.pxh000,
       decode(i.sfcrb0,'1','甲类传染病','2','乙类传染病','3','丙类传染病','4','其它传染病',' ') crbmc0  --传染病
from   xt_icd900 i where SYBZ00='1' and icd900 not like 'M%/%'
and substr(icd900,1,1) not in ('V','W','X','Y')