create or replace view vw_bm_ybsfdy
(sfxmid, sfyp00, fbbh00, ybzxlb, ybxmbh, ybzyfp, ybmzfp, xmje00, zfbl00, sczfje, zfje00, jmbl00, jmje00, sfybxm, ybbrlb, sfsx00, yxbz00, yblb00, bz0000, nblb00, nbzfbl, zyzfbl, ybjsdj, xmdw00, ybjsdj1, xmdw01, mzzybz, bkeh83)
as
select
        SFXMID,
        SFYP00,
        FBBH00,
        YBZXLB,
        YBXMBH,
        YBZYFP,
        YBMZFP,
        XMJE00,
        ZFBL00,
        decode(ZFBL00,1,XMJE00,ZFJE00),
        ZFJE00+(XMJE00-ZFJE00-JMJE00)*ZFBL00,
        JMBL00,
        JMJE00+(XMJE00-ZFJE00-JMJE00)*JMBL00,
        SFYBXM,
        YBBRLB,
        SFSX00,
        YXBZ00,
        YBLB00,
        BZ0000,
        NBLB00,   --农保类别
        NBZFBL,    --农保自付比率
        decode(ZYZFBL,null,zfbl00,zyzfbl) zyzfbl,
        YBJSDJ,
        XMDW00,
        YBJSDJ1,
        XMDW01,
        nvl(MZZYBZ,'2') MZZYBZ,--门诊住院标志  0门诊，1住院，2门诊住院都可用
        BKEH83  --国家医保编码
from VW_BM_YBSFDY2 a;