CREATE OR REPLACE VIEW SD_HOSPITAL.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, BKEA96, XZLB00

 )
 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,  --国家医保编码
        BKEA96,   --限制范围类别: Y-范围内 N-范围外
        XZLB00
from VW_BM_YBSFDY2 a
/