create or replace view vw_ys_brzzsq_mzdzbl as
select ID0000,BRID00,BRXM00,BRXB00,BRDH00,KMH000,ICKH00,BRCSRQ,SFZH00,
       JSYSBH,decode(LB0000,'0',SQYSXM,JSYSXM) JSYSXM,JSKSBH,JSKSMC,
       SQRQ00,SQSJ00,YYRQ00,YYSJ00,SQDH00,LYYY00,YYID00,
       ZT0000,CZRQ00,CZSJ00,LB0000,SCBZ00,MSGID0,GHID00,
       DAH000,BRDZ00,JGID00,JGMC00,decode(LB0000,'0',SQYSDH,JSYSDH) JSYSDH,ZZQZD0,BQZY00,
       DECODE(ZT0000,0,'有效',1,'已就诊',2,'撤销','3','拒绝','') ZT00002,
       DECODE(LB0000,0,'转出',1,'转入','') LB00002,
       FZKSMC,FZBQMC,FZBZ00,
       DECODE(FZBZ00,0,'门诊',1,'住院','未分诊') FZBZMC,
       FZKSBH,FZBQBH,substr(BQZY00,1,120) BQZY01,BZ0000,
       SF_YS_CSRQTONL(BRCSRQ) BRLN00,decode(YNYYID,'14945','224465','53110','224466',YNYYID) YNYYID,YNYYMC,
       FZYSBH,FZYSXM,FZRQ00,FZSJ00
from YS_BRZZSQ;