CREATE OR REPLACE VIEW SD_HOSPITAL.VW_ZY_GJYBJSQDZX ( YBJKID, ZYID00, JZDH00, CZRQ00, CZSJ00, AKC190, AAE072, SETL_ID, SETL_LIST_SN, PSN_NO, MDTRT_ID, FIXMEDINS_NAME, FIXMEDINS_CODE, HI_SETL_LV, MEDCASNO, DCLA_TIME, PSN_NAME, GEND, BRDY, AGE, NWB_AGE, NTLY, NATY, PATN_CERT_TYPE, CERTNO, PRFS, CURR_ADDR, EMP_NAME, EMP_ADDR, EMP_TEL, POSCODE, CONER_NAME, PATN_RLTS, PATN_RLTS_MC, CONER_ADDR, CONER_TEL, INSUTYPE, SP_PSN_TYPE, INSU_ADMDVS, NWB_ADM_TYPE, NWBBIRWT, NWBADMWT, MUL_NWB_BIR_WT, MUL_NWB_ADM_WT, OPSP_DIAG_CATY, OPSP_MDTRT_DATE, IPT_MED_TYPE, ADM_WAY, TRT_TYPE, ADM_TIME, DSCG_TIME, ADM_CATY, REFLDEPT_DEPT, DSCG_CATY, ACT_IPT_DAYS, OTP_WM_DISE, WM_DISE_CODE, OTP_TCM_DISE, TCM_DISE_CODE, DIAG_CODE_CNT, OPRN_OPRT_CODE_CNT, VENT_USED_DAYS, VENT_USED_H_CNT, VENT_USED_M_CNT, BFADM_COMA_DAYS, BFADM_COMA_H_CNT, BFADM_COMA_M_CNT, AFADM_COMA_DAYS, AFADM_COMA_H_CNT, AFADM_COMA_M_CNT, BLD_CAT, BLD_AMT, BLD_UNT, SPGA_NURSCARE_DAYS, LV1_NURSCARE_DAYS, SCD_NURSCARE_DAYS, LV3_NURSCARE_DAYS, DSCG_WAY, ACP_MEDINS_NAME, ACP_OPTINS_CODE, DAYS_RINP_FLAG_31, DAYS_RINP_PUP_31, CHFPDR_NAME, CHFPDR_CODE, BIZ_SN, BILL_CODE, BILL_NO, SETL_BEGN_DATE, SETL_END_DATE, PSN_SELFPAY, PSN_OWNPAY, ACCT_PAY, PSN_CASHPAY, HI_PAYMTD, MEDINS_FILL_DEPT, MEDINS_FILL_PSN, VALI_FLAG, RID, UPDT_TIME, CRTER_ID, CRTER_NAME, CRTE_TIME, CRTE_OPTINS_NO, OPTER_ID, OPTER_NAME, OPT_TIME, OPTINS_NO, POOLAREA, HI_NO, HI_TYPE, OPSP_DISE_NAME, OPSP_DISE_CODE, DSCG_DIAG, RESP_NURS_NAME, RESP_NURS_CODE, HSORG_OPTER_CODE, STAS_TYPE, HSORG_OPTER, HSORG_NAME, HSORG_CODE, CHK_CONT, BAKXML, HI_SETL_LV_MC, NTLY_MC, NATY_MC, PRFS_MC, PATN_CERT_TYPE_MC, INSUTYPE_MC, INSU_ADMDVS_MC, ADM_CATY_MC, REFLDEPT_DEPT_MC, DSCG_CATY_MC, YBTCJJZF, BCYLBXZF_ZGDEBZ, BCYLBXZF_JMDBBX, BCYLBXZF_GWYYLBZ, YLJZZF, QTZF_CZBZ, QTZF_FPBZ, QTZF_SYBX, QTZF_QYBC, QTZF_QTZF, QTZF_JZFP01, QTZF_JZFP02, QTZF_SZHJZ, QTZF_CJGMBZ, GRFD_ONEPAY, GRFD_ONEPOCKET, GRZF_GRZHZF, GRZF_GRXJZF, TITLENAME, PAYINFONUM, OPSPDISEINFONUM, DISEINFONUM, ITEMINFONUM, OPRNINFONUM, ICUINFONUM, BLDINFONUM, HI_TYPE_MC, BRDY_YEARS, BRDY_MONTH, BRDY_DAY, DCLA_TIME_YEARS, DCLA_TIME_MONTH, DCLA_TIME_DAY, ADM_TIME_YEARS, ADM_TIME_MONTH, ADM_TIME_DAY, ADM_TIME_HH, DSCG_TIME_YEARS, DSCG_TIME_MONTH, DSCG_TIME_DAY, DSCG_TIME_HH, SETL_BEGN_DATE_YEARS, SETL_BEGN_DATE_MONTH, SETL_BEGN_DATE_DAY, SETL_END_DATE_YEARS, SETL_END_DATE_MONTH, SETL_END_DATE_DAY, DBZ_BZBMMC, DBZ_DEBZMC, DBZ_CBCWFMC, DBZ_CWHCFMC, TOTAL_AMT, TOTAL_CLAA_SUMFEE, TOTAL_CLAB_AMT, TOTAL_FULAMT_OWNPAY_AMT, TOTAL_OTH_AMT, DBZBM0, DBZMC0, DBZMCBM, AAZ149, QDSCXZMC, QDJKJHMC, QDLXBM, DBZ_AMT, DBZ_CLAA_SUMFEE, DBZ_CLAB_AMT, DBZ_FULAMT_OWNPAY_AMT, DBZ_OTH_AMT ) AS select A.YBJKID ,--医保接口id=ZY_YBJKRZ.YBJKID A.ZYID00 ,--ZYID00=ZY_BRXXB0.ZYID00 A.JZDH00 ,--结账单号=ZY_JZB000.JZDH00 A.CZRQ00 ,--操作日期 A.CZSJ00 ,--操作时间 A.AKC190 ,--医保收费单据号=ZY_JZB000.YBZHY0 A.AAE072 ,--医保结算单号=ZY_JZB000.YBDJH0 A.SETL_ID ,--setl_id:结算ID A.SETL_LIST_SN ,--setl_list_sn:结算清单流水号 A.PSN_NO ,--psn_no:人员编号 A.MDTRT_ID ,--mdtrt_id:就诊ID A.FIXMEDINS_NAME ,--fixmedins_name:定点医药机构名称 A.FIXMEDINS_CODE ,--fixmedins_code:定点医药机构编号 A.HI_SETL_LV ,--hi_setl_lv:医保结算等级 A.MEDCASNO ,--medcasno:病案号 A.DCLA_TIME ,--dcla_time:申报时间 A.PSN_NAME ,--psn_name:人员姓名 A.GEND ,--gend:性别 A.BRDY ,--brdy:出生日期 A.AGE ,--age:年龄 A.NWB_AGE ,--nwb_age:（年龄不足1周岁）年龄 A.NTLY ,--ntly:国籍 A.NATY ,--naty:民族 A.PATN_CERT_TYPE ,--patn_cert_type:患者证件类别 A.CERTNO ,--certno:证件号码 A.PRFS ,--prfs:职业 A.CURR_ADDR ,--curr_addr:现住址 A.EMP_NAME ,--emp_name:单位名称 A.EMP_ADDR ,--emp_addr:单位地址 A.EMP_TEL ,--emp_tel:单位电话 A.POSCODE ,--poscode:邮编 A.CONER_NAME ,--coner_name:联系人姓名 A.PATN_RLTS ,--patn_rlts:与患者关系 (select nvl(max(VALUE0),trim(B.BRLXGX)) from XT_ZD0000 where ZDMC00='关系' and ZDBM00='LXRGX0' and jkbh00=A.PATN_RLTS) as PATN_RLTS_mc ,--patn_rlts_mc:与患者关系(名称) A.CONER_ADDR ,--coner_addr:联系人地址 A.CONER_TEL ,--coner_tel:联系人电话 A.INSUTYPE ,--insutype:险种类型 A.SP_PSN_TYPE ,--sp_psn_type:特殊人员类型 A.INSU_ADMDVS ,--insu_admdvs:参保所属医保区划 A.NWB_ADM_TYPE ,--nwb_adm_type:新生儿入院类型 A.NWBBIRWT ,--nwbbirwt:新生儿出生体重 A.NWBADMWT ,--nwbadmwt:新生儿入院体重 A.MUL_NWB_BIR_WT ,--mul_nwb_bir_wt:多新生儿出生体重 A.MUL_NWB_ADM_WT ,--mul_nwb_adm_wt:多新生儿入院体重 A.OPSP_DIAG_CATY ,--opsp_diag_caty:门诊慢特病诊断科别 A.OPSP_MDTRT_DATE ,--opsp_mdtrt_date:门诊慢特病就诊日期 A.IPT_MED_TYPE ,--ipt_med_type:住院医疗类型 nvl(A.ADM_WAY,'9') as adm_way,--adm_way:入院途径 A.TRT_TYPE ,--trt_type:治疗类别 A.ADM_TIME ,--adm_time:入院时间 A.DSCG_TIME ,--dscg_time:出院时间 A.ADM_CATY ,--adm_caty:入院科别 A.REFLDEPT_DEPT ,--refldept_dept:转科科别 A.DSCG_CATY ,--dscg_caty:出院科别 nvl(A.ACT_IPT_DAYS,to_date(nvl(C.CYDJRQ,to_char(sysdate,'YYYYMMDD')),'YYYYMMDD')-to_date(C.RYRQ00,'YYYYMMDD')+1) as ACT_IPT_DAYS ,--act_ipt_days:实际住院天数 A.OTP_WM_DISE ,--otp_wm_dise:门（急）诊西医诊断 A.WM_DISE_CODE ,--wm_dise_code:西医诊断疾病代码 A.OTP_TCM_DISE ,--otp_tcm_dise:门（急）诊中医诊断 A.TCM_DISE_CODE ,--tcm_dise_code:中医诊断代码 A.DIAG_CODE_CNT ,--diag_code_cnt:诊断代码计数 A.OPRN_OPRT_CODE_CNT ,--oprn_oprt_code_cnt:手术操作代码计数 A.VENT_USED_DAYS ,--vent_used_days:呼吸机使用天数 A.VENT_USED_H_CNT ,--vent_used_h_cnt:呼吸机使用小时数 A.VENT_USED_M_CNT ,--vent_used_m_cnt:呼吸机使用分钟数 A.BFADM_COMA_DAYS ,--bfadm_coma_days:入院前颅脑损伤患者昏迷天数 A.BFADM_COMA_H_CNT ,--bfadm_coma_h_cnt:入院前颅脑损伤患者昏迷小时数 A.BFADM_COMA_M_CNT ,--bfadm_coma_m_cnt:入院前颅脑损伤患者昏迷分钟数 A.AFADM_COMA_DAYS ,--afadm_coma_days:入院后颅脑损伤患者昏迷天数 A.AFADM_COMA_H_CNT ,--afadm_coma_h_cnt:入院后颅脑损伤患者昏迷小时数 A.AFADM_COMA_M_CNT ,--afadm_coma_m_cnt:入院后颅脑损伤患者昏迷分钟数 A.BLD_CAT ,--bld_cat:输血品种 A.BLD_AMT ,--bld_amt:输血量 A.BLD_UNT ,--bld_unt:输血计量单位 decode(A.SPGA_NURSCARE_DAYS,0,'',A.SPGA_NURSCARE_DAYS) as SPGA_NURSCARE_DAYS ,--spga_nurscare_days:特级护理天数 decode(A.LV1_NURSCARE_DAYS,0,'',A.LV1_NURSCARE_DAYS) as LV1_NURSCARE_DAYS ,--lv1_nurscare_days:一级护理天数 decode(A.SCD_NURSCARE_DAYS,0,'',A.SCD_NURSCARE_DAYS) as SCD_NURSCARE_DAYS ,--scd_nurscare_days:二级护理天数 decode(A.LV3_NURSCARE_DAYS,0,'',A.LV3_NURSCARE_DAYS) as LV3_NURSCARE_DAYS ,--lv3_nurscare_days:三级护理天数 A.DSCG_WAY ,--dscg_way:离院方式 A.ACP_MEDINS_NAME ,--acp_medins_name:拟接收机构名称 A.ACP_OPTINS_CODE ,--acp_optins_code:拟接收机构代码 A.DAYS_RINP_FLAG_31 ,--days_rinp_flag_31:出院31天内再住院计划标志 A.DAYS_RINP_PUP_31 ,--days_rinp_pup_31:出院31天内再住院目的 A.CHFPDR_NAME ,--chfpdr_name:主诊医师姓名 A.CHFPDR_CODE ,--chfpdr_code:主诊医师代码 A.BIZ_SN ,--biz_sn:业务流水号 A.BILL_CODE ,--bill_code:票据代码 A.BILL_NO ,--bill_no:票据号码 A.SETL_BEGN_DATE ,--setl_begn_date:结算开始日期 A.SETL_END_DATE ,--setl_end_date:结算结束日期 A.PSN_SELFPAY ,--psn_selfpay:个人自付 A.PSN_OWNPAY ,--psn_ownpay:个人自费 A.ACCT_PAY ,--acct_pay:个人账户支出 A.PSN_CASHPAY ,--psn_cashpay:个人现金支付 A.HI_PAYMTD ,--hi_paymtd:医保支付方式 1.按项目 2.单病种 3.按病种分值 4.疾病诊断相关分组(DRG) 5.按床日 6.按人头 9.其他 A.MEDINS_FILL_DEPT ,--medins_fill_dept:医疗机构填报部门 A.MEDINS_FILL_PSN ,--medins_fill_psn:医疗机构填报人 A.VALI_FLAG ,--vali_flag:有效标志 A.RID ,--rid:唯一记录号 A.UPDT_TIME ,--updt_time:更新时间 A.CRTER_ID ,--crter_id:创建人 A.CRTER_NAME ,--crter_name:创建人姓名 A.CRTE_TIME ,--crte_time:创建时间 A.CRTE_OPTINS_NO ,--crte_optins_no:创建机构 A.OPTER_ID ,--opter_id:经办人ID A.OPTER_NAME ,--opter_name:经办人姓名 A.OPT_TIME ,--opt_time:经办时间 A.OPTINS_NO ,--optins_no:经办机构 A.POOLAREA ,--poolarea:统筹区编码 A.HI_NO ,--hi_no:医保编号 A.HI_TYPE ,--hi_type:医保类型 A.OPSP_DISE_NAME ,--opsp_dise_name:门慢门特病种名称 A.OPSP_DISE_CODE ,--opsp_dise_code:门慢门特病种目录代码 A.DSCG_DIAG ,--dscg_diag:出院诊断 A.RESP_NURS_NAME ,--resp_nurs_name: 责任护士姓名 A.RESP_NURS_CODE ,--resp_nurs_code: 责任护士代码 A.HSORG_OPTER_CODE ,--hsorg_opter_code:医保机构经办人代码 A.STAS_TYPE ,--stas_type:状态分类 A.HSORG_OPTER ,--hsorg_opter:医保机构经办人 A.HSORG_NAME ,--hsorg_name:医保机构 A.HSORG_CODE ,--hsorg_code:医保机构代码 A.CHK_CONT ,--chk_cont:审核内容 A.BAKXML ,--bakxml:备用字段 decode(A.HI_SETL_LV,'1','一级','2','二级','3','三级',A.HI_SETL_LV) as hi_setl_lv_mc ,--hi_setl_lv_mc:医保结算等级(名称) nvl(b.BRGJ00,decode(A.NTLY,'CHN','中国','中国')) as NTLY_mc ,--ntly_mc:国籍(名称) nvl(b.BRMZ00,decode(A.NATY,'1','汉族',A.NATY)) as NATY_mc ,--naty_mc:民族(名称) nvl(b.BRZY00,nvl((select aa.SXSM00 from bm_ybsxzd aa where aa.JKBM00=2 and aa.sxbm00='prfs' and aa.VALUE0=A.PRFS and rownum=1),A.PRFS)) as PRFS_mc ,--prfs_mc:职业(名称) nvl(b.BRZJLX,decode(A.PATN_CERT_TYPE,'1','身份证','2','户口簿','3','护照','其他身份证件')) as PATN_CERT_TYPE_MC ,--patn_cert_type_mc:患者证件类别(名称) '' as INSUTYPE_MC ,--insutype_mc:险种类型(名称) E.YBMC00 as INSU_ADMDVS_MC ,--insu_admdvs_mc:参保所属医保区划(名称) nvl((select aa.SXSM00 from BM_YBSXZD aa where aa.JKBM00=2 and aa.SXBM00='dept' and aa.VALUE0=A.adm_caty and rownum=1),(select aa.BMMC00 from BM_BMBM00 aa where aa.BMBH00=C.DQKS00 )) as ADM_CATY_MC ,--adm_caty_mc:入院科别(名称) A.REFLDEPT_DEPT_MC as REFLDEPT_DEPT_MC ,--refldept_dept_mc:转科科别(名称) nvl((select aa.SXSM00 from BM_YBSXZD aa where aa.JKBM00=2 and aa.SXBM00='dept' and aa.VALUE0=A.dscg_caty and rownum=1),(select aa.BMMC00 from BM_BMBM00 aa where aa.BMBH00=C.DQKS00 )) as DSCG_CATY_MC ,--dscg_caty_mc:出院科别(名称) decode(a.hi_paymtd,'2',T.BKC045,nvl(A.YBTCPAY,(select sum(aa.fund_payamt) from ZY_YBJSDX aa where aa.ybjkid=a.ybjkid and aa.JKJDBM='payinfo' and aa.fund_pay_type in ('310100','390100')))) as YBTCJJZF,--医保统筹基金支付 nvl(a.zgdePay,nvl(T.BKEH73,0)) as BCYLBXZF_ZGDEBZ,--补充医疗保险支付.职工大额补助 nvl(a.jmdbPay,nvl(T.BKC052,0)) as BCYLBXZF_JMDBBX,--补充医疗保险支付.居民大病保险 nvl(a.gwyPay,nvl(T.BKC059,0)) as BCYLBXZF_GWYYLBZ,--补充医疗保险支付.公务员医疗补助 nvl(a.yljzPay,nvl(T.BKC060,0)) as YLJZZF,--医疗救助支付 nvl(a.fund_payamt_CZBZ,nvl(T.BKC612,0)) as QTZF_CZBZ,--其他支付.财政补助 nvl(a.fund_payamt_FPBZ,nvl(T.BKC062,0)) as QTZF_FPBZ,--其他支付.扶贫补助 nvl(a.fund_payamt_sybx,nvl(T.BKC054,0)) as QTZF_SYBX,--其他支付.商业保险 nvl(a.fund_payamt_qyzf,nvl(T.AKE026,0)) as QTZF_QYBC,--其他支付.企业补充 nvl(a.fund_payamt_QTZF,nvl(t.AKE173,0)) as QTZF_QTZF,--其他支付.其他支付 nvl(a.fund_payamt_JZFP01,0) as QTZF_JZFP01,--精准扶贫一道 nvl(a.fund_payamt_JZFP02,0) as QTZF_JZFP02,--精准扶贫二道 nvl(a.fund_payamt_SZHJZ,0) as QTZF_SZHJZ,--市综合救助 nvl(a.fund_payamt_CJGMBZ,0) as QTZF_CJGMBZ,--处级干部补助 nvl(A.PSN_SELFPAY,0) as GRFD_ONEPAY,--个人负担.个人自付 nvl(A.PSN_OWNPAY,0) as GRFD_ONEPOCKET,--个人负担.个人自费 nvl(A.ACCT_PAY,0) as GRZF_GRZHZF,--个人支付.个人账户支付 nvl(A.PSN_CASHPAY,0) as GRZF_GRXJZF,--个人支付.个人现金支付 nvl(SF_SF_RETURNINDEXEH(substrb(SF_SF_TYZD00('医保新接口参数设置','jsqd_title_name'),1,100),'|', 2),'医疗保障基金结算清单(住院)') as TITLENAME, --标题名称 decode(nvl(a.payinfo_num,SF_SF_GETXMLNOTE('payinfonum',A.BAKXML)),'0','',nvl(a.payinfo_num,SF_SF_GETXMLNOTE('payinfonum',A.BAKXML))) as PAYINFONUM, --基金支付信息_记录数 decode(nvl(a.opspdiseinfo_num,SF_SF_GETXMLNOTE('opspdiseinfonum',A.BAKXML)),'0','',nvl(a.opspdiseinfo_num,SF_SF_GETXMLNOTE('opspdiseinfonum',A.BAKXML))) as OPSPDISEINFONUM,--门诊慢特病诊断信息_记录数 decode(nvl(a.diseinfo_num,SF_SF_GETXMLNOTE('diseinfonum',A.BAKXML)),'0','',nvl(a.diseinfo_num,SF_SF_GETXMLNOTE('diseinfonum',A.BAKXML))) as DISEINFONUM, --住院诊断信息_记录数 decode(nvl(a.iteminfo_num,SF_SF_GETXMLNOTE('iteminfonum',A.BAKXML)),'0','',nvl(a.iteminfo_num,SF_SF_GETXMLNOTE('iteminfonum',A.BAKXML))) as ITEMINFONUM, --收费项目信息_记录数 decode(nvl(a.oprninfo_num,SF_SF_GETXMLNOTE('oprninfonum',A.BAKXML)),'0','',nvl(a.oprninfo_num,SF_SF_GETXMLNOTE('oprninfonum',A.BAKXML))) as OPRNINFONUM, --手术操作信息_记录数 decode(nvl(a.icuinfo_num,SF_SF_GETXMLNOTE('icuinfonum',A.BAKXML)),'0','',nvl(a.icuinfo_num,SF_SF_GETXMLNOTE('icuinfonum',A.BAKXML))) as ICUINFONUM, --重症监护信息_记录数 decode(nvl(a.bldinfo_num,SF_SF_GETXMLNOTE('bldinfonum',A.BAKXML)),'0','',nvl(a.bldinfo_num,SF_SF_GETXMLNOTE('bldinfonum',A.BAKXML))) as BLDINFONUM, --输血信息_记录数 nvl((select aa.SXSM00 from bm_ybsxzd aa where aa.JKBM00=2 and aa.sxbm00='mdcs_type' and aa.VALUE0=A.HI_TYPE and rownum=1),B.AAE140_MC) as HI_TYPE_MC, --hi_type_MC:医保类型（名称） substrb(B.BRCSRQ,1,4) as BRDY_years ,--brdy_years:出生日期_年 substrb(B.BRCSRQ,5,2) as BRDY_month ,--brdy_month:出生日期_月 substrb(B.BRCSRQ,7,2) as BRDY_day ,--brdy_day:出生日期_日 substrb(A.DCLA_TIME,1,4) as DCLA_TIME_years ,--dcla_time_years:申报时间_年 substrb(A.DCLA_TIME,6,2) as DCLA_TIME_month ,--dcla_time_month :申报时间_月 substrb(A.DCLA_TIME,9,2) as DCLA_TIME_day ,--dcla_time_day:申报时间_日 substrb(A.ADM_TIME,1,4) as ADM_TIME_years ,--adm_time_years:入院时间_年 substrb(A.ADM_TIME,6,2) as ADM_TIME_month ,--adm_time_month:入院时间_月 substrb(A.ADM_TIME,9,2) as ADM_TIME_day ,--adm_time_day:入院时间_日 substrb(A.ADM_TIME,12,2) as ADM_TIME_hh ,--adm_time_hh:入院时间_时 substrb(A.DSCG_TIME,1,4) as DSCG_TIME_years ,--dscg_time_years:出院时间_年 substrb(A.DSCG_TIME,6,2) as DSCG_TIME_month ,--dscg_time_month:出院时间_月 substrb(A.DSCG_TIME,9,2) as DSCG_TIME_day ,--dscg_time_day:出院时间_日 substrb(A.DSCG_TIME,12,2) as DSCG_TIME_hh , --dscg_time_hh:出院时间_时 substrb(A.SETL_BEGN_DATE,1,4) as SETL_BEGN_DATE_years ,--setl_begn_date_years:结算开始日期_年 substrb(A.SETL_BEGN_DATE,6,2) as SETL_BEGN_DATE_month ,--setl_begn_date_month :结算开始日期_月 substrb(A.SETL_BEGN_DATE,9,2) as SETL_BEGN_DATE_day ,--setl_begn_date_day:结算开始日期_日 substrb(A.SETL_END_DATE,1,4) as SETL_END_DATE_years ,--setl_end_date_years:算结束日期_年 substrb(A.SETL_END_DATE,6,2) as SETL_END_DATE_month ,--setl_end_date_month :算结束日期_月 substrb(A.SETL_END_DATE,9,2) as SETL_END_DATE_day ,--setl_end_date_day:算结束日期_日 nvl(A.dbz_bzbmmc,'') as dbz_bzbmmc ,--病种收费名称+代码 --decode(T.AAZ149,'','','单病种标准:'||T.DRGZFE) as dbz_debzmc ,--单病种定额标准名称 --decode(T.AAZ149,'','','单病种超标床位费:'||T.BKC125) as dbz_cbcwfmc ,--单病种超标床位费名称 --decode(T.AAZ149,'','','单病种除外耗材费:'||T.BKC101) as dbz_cwhcfmc ,--单病种除外耗材费名称 ' ' as dbz_debzmc ,--单病种定额标准名称 ' ' as dbz_cbcwfmc ,--单病种超标床位费名称 ' ' as dbz_cwhcfmc ,--单病种除外耗材费名称 nvl(a.total_amt,decode(a.hi_paymtd,'2',t.AKC227,(select sum(mx.AMT) from ZY_YBJSDX mx where mx.YBJKID=A.YBJKID and mx.JKJDBM='iteminfo'))) as total_amt ,--total_amt:收费项目信息.金额 nvl(a.total_claa_sumfee,decode(a.hi_paymtd,'2',0,(select sum(mx.CLAA_SUMFEE) from ZY_YBJSDX mx where mx.YBJKID=A.YBJKID and mx.JKJDBM='iteminfo'))) as total_claa_sumfee ,--total_claa_sumfee:收费项目信息.甲类费用合计 nvl(a.total_clab_amt,decode(a.hi_paymtd,'2',0,(select sum(mx.CLAB_AMT) from ZY_YBJSDX mx where mx.YBJKID=A.YBJKID and mx.JKJDBM='iteminfo'))) as total_clab_amt ,--total_clab_amt:收费项目信息.乙类金额 nvl(a.total_fulamt_ownpay_amt,decode(a.hi_paymtd,'2',0,(select sum(mx.FULAMT_OWNPAY_AMT) from ZY_YBJSDX mx where mx.YBJKID=A.YBJKID and mx.JKJDBM='iteminfo'))) as total_fulamt_ownpay_amt ,--total_fulamt_ownpay_amt:收费项目信息.全自费金额 nvl(a.total_oth_amt,decode(a.hi_paymtd,'2',0,(select sum(mx.OTH_AMT) from ZY_YBJSDX mx where mx.YBJKID=A.YBJKID and mx.JKJDBM='iteminfo'))) as total_oth_amt ,--total_oth_amt:收费项目信息.其他金额 C.DBZBM0 as DBZBM0 ,--单病种编码 c.DBZMC0 as DBZMC0 ,--单病种名称 nvl((select nvl(aa.BAEMC0,aa.DBZMC0)||'+'||nvl(aa.BAE465,aa.DBZBM0) from BM_DBZDEB aa where aa.YBZXLB=SF_ZY_SFQYDBZJK(a.ZYID00) and YBBRLB=SF_ZY_SFQYDBZJK(a.ZYID00) and aa.DBZBM0=T.AAZ149 and rownum=1 and T.AAZ149 is not null),'XX(按病种收费名称+代码)') as DBZMCBM, --按病种收费名称+代码 T.AAZ149 as AAZ149, decode(T.JKCJBM,'YBJK_GJYBJSD_0001','查询','YBJK_JSQDXXSC_001','上传','其它') as QDSCXZMC,--清单上传查询标志名称 decode(T.YBJKBM,'000000','院内生成','医保交互') as QDJKJHMC, --接口交互名称 nvl(a.QDlXBM,decode(T.JKCJBM,'YBJK_JSQDXXSC_001','0',decode(T.YBJKBM,'000000','2','1')) ) as QDlXBM, --清单类型编码 0:上传 1:查询 2:院内生成 -- decode(a.hi_paymtd,'2',to_char(t.AKC227),'') as dbz_amt ,--单病种.金额 decode(a.hi_paymtd,'2','0','') as dbz_claa_sumfee ,--单病种.甲类费用合计 decode(a.hi_paymtd,'2','0','') as dbz_clab_amt ,--单病种.乙类金额 decode(a.hi_paymtd,'2','0','') as dbz_fulamt_ownpay_amt ,--单病种.全自费金额 decode(a.hi_paymtd,'2','0','') as dbz_oth_amt --单病种.其他金额 from ZY_YBJSD0 A,ZY_BRXXB0 C,IC_YBBRLB E,BM_BRXXB0 B,ZY_YBJKRZ T where A.ZYID00=C.ZYID00 and C.BRID00=B.BRID00 and C.FBBH00=E.FBBH00 and C.YBLB00=E.YBLB00 and a.YBJKID=T.YBJKID and a.ZYID00=T.ZYID00 /