create or replace view vw_mr_brzyxx as
select
LSH000,BAH000,ZYCS00,ZYH000,BRXM00,nvl(BRXB00,'男') BRXB00,BRCSRQ,BRNL00,HYZK00,ZY0000,
BRLY00,CSSF00,CSXS00,MZ0000,GJ0000,SFZH00,GZDW00,GZDH00,GZYB00,JTDZ00,
JTDH00,JTYB00,LXRXM0,LXRDZ0,LXRDH0,LXRGX0,ZDFS00,RYQK00,RYRQ00,RYSJ00,
RYKB00,RYKBMC,RYBF00,ZKKB00,ZKKBMC,CYRQ00,CYSJ00,CYKB00,CYKBMC,CYBF00,
decode(to_date(cyrq00,'yyyyMMdd')-to_date(ryrq00,'yyyyMMdd'),0,1,to_date(cyrq00,'yyyyMMdd')-to_date(ryrq00,'yyyyMMdd'))  ZYTS00,
 QZRQ00,BLZD00,GMYW00,HBSAG0,HCVAB0,HIVAB0,MZCYFH,RYCYFH,SQSHFH,
LCBLFH,FSBLFH,QJCS00,CGCS00,BAZL00,decode(SFSJ00,'是','1','否','0','0') SFSJ00,DYBL00,SFSZ00,SZQX00,SJBL00,
XX0000,trim(RH0000) RH0000,SXFY00,HXB000,XXB000,XJ0000,QX0000,SXQT00,ZKRQ00,BAZT00,
SRRK00,LRRY00,LRRQ00,
decode(JFFS00,'1','城镇职工基本医疗保险','2','城镇居民基本医疗保险','3','新型农村合作医疗','4','贫困救助','5','商业医疗保险','6','全公费',
'7','全自费','8','其他社会保险','9','其他',JFFS00) JFFS00,
decode(trim(ZJE000),'-',0,'',0,ZJE000) ZJE000,
ZYLSH0,CARDNO,BZ0000,JKDAH0,CSDS00,decode(YECSTZ,'-',null,decode(instr(YECSTZ,'/'),0,YECSTZ,substr(YECSTZ,1,instr(YECSTZ,'/')-1))) YECSTZ,
decode(trim(YERYTZ),'-',null,trim(YERYTZ)) YERYTZ,
XZZ000,XZZDH0,XZZYB0,BLZDBM,BLH000,decode(trim(SFYWGM),'1','无','2','有','无')  SFYWGM,
decode(LYFS00,'1','医嘱离院','2','医嘱转院','3','医嘱转社区卫生服务机构','4','非医嘱离院','5','死亡','9','其他',LYFS00) LYFS00,ZYYLJG,
decode(ZZYJH0,'1','无','2','有',ZZYJH0) ZZYJH0,ZZYMD0,
decode(trim(HMRYQD),'-',0,HMRYQD) HMRYQD,decode(trim(HMRYQH),'-',0,HMRYQH) HMRYQH,decode(trim(HMRYQM),'-',0,HMRYQM) HMRYQM,
decode(trim(HMRYHD),'-',0,HMRYHD) HMRYHD,decode(trim(HMRYHH),'-',0,HMRYHH) HMRYHH,decode(trim(HMRYHM),'-',0,HMRYHM) HMRYHM,
'' LRRYMC,'1' SHBZ00,
JGSF00,JGDS00 JGXS00,
--decode(RYTJ00,'急诊','1','门诊','2','其他医疗机构转入','3','其他','9','9')
 RYTJ00,
SSZDYY SSZDWY,SSZDBM,'' LCLJ01,nvl(BRNLY0,0) BRNLMM,--BRNLR0 BRNLDD,
--decode(nvl(BRNL00,0),0,to_date(RYRQ00,'yyyyMMdd')-to_date(brcsrq,'yyyyMMdd'),null) BRNLDD,
--decode(instr(brnl00,'/'),0,'0',substr(brnl00,1,instr(brnl00,'/')-1))  BRNLDD,
decode(nvl(BRNL00,0),0,decode(yenl00,'-',to_date(RYRQ00,'yyyyMMdd')-to_date(brcsrq,'yyyyMMdd'),substr(yenl00,1,instr(yenl00,'/')-1))) BRNLDD,
xgrq00,xgsj00,'' zlsb00,'' zljs00,'' bzsh00
from view_ba_brzyxx@BA  A