CREATE OR REPLACE VIEW SD_HOSPITAL.VW_BM_YBSFDY2
 (
 SFXMID, SFYP00, FBBH00, YBZXLB, YBXMBH, YBZYFP, YBMZFP, XMJE00, ZFBL00, 
ZFJE00, JMBL00, JMJE00, SFYBXM, YBBRLB, SFSX00, YXBZ00, YBLB00, BZ0000, 
NBLB00, NBZFBL, YBJSDJ, XMDW00, YBJSDJ1, XMDW01, ZYZFBL, MZZYBZ, BKEH83, 
BKEA96, XZLB00

 )
 AS 
select
        SFXMID,
        SFYP00,
        FBBH00,
        YBZXLB,
        YBXMBH,
        YBZYFP,
        YBMZFP,
        decode(nvl(XMJE00,0),0,YYJE00,decode(sign(YYJE00-XMJE00),1,XMJE00,YYJE00)),
        ZFBL00,
        ZFJE00,
        JMBL00,
        JMJE00,
        SFYBXM,
        YBBRLB,
        SFSX00,
        YXBZ00,
        YBLB00,
        BZ0000,
        NBLB00,    --农保类别
        NBZFBL,    --农保自付比率
        YBJSDJ,
        XMDW00,
        YBJSDJ1,
        XMDW01,
        ZYZFBL,
        nvl(MZZYBZ,'2') MZZYBZ,  --门诊住院标志 0门诊，1住院，2门诊住院都可用
        BKEH83,  --国家医保编码
        BKEA96,--限制范围类别: Y-范围内 N-范围外
        XZLB00   
from VW_BM_YBSFDY1
/