医疗结算数据查询 - 2023年3月9日至11日

SELECT YB.PSN_NAME AS 姓名, DECODE(YB.GEND,1,'男',2,'女') AS 性别, YB.BRDY AS 出生日期, YB.AGE AS 年龄, YB.NATY AS 民族, YB.CERTNO AS 证件号码, YB.PSN_NO AS 人员编号, YB.psn_cert_type AS 人员证件类型, YB.insutype AS 险种类型, YB.psn_type AS 人员类别, YB.cvlserv_flag AS 公务员标志, YB.med_type AS 医疗类别, YB.mdtrt_cert_type AS 就诊凭证类型, YB.cjsj AS 结算时间, YB.mdtrt_id AS 就诊ID, YB.setl_id AS 结算ID, YB.medfee_sumamt AS 医疗费总额, YB.psn_cash_pay AS 个人现金支出, YB.fund_pay_sumamt AS 基金支付总额, YB.hosp_part_amt AS 医院负担金额, YB.acct_pay AS 个人账户支出, YB.fulamt_ownpay_amt AS 全自费金额, YB.overlmt_selfpay AS 超限价自费费用, YB.preselfpay_amt AS 先行自付金额, YB.inscp_scp_amt AS 符合政策范围金额, YB.act_pay_dedc AS 实际支付起付线, YB.pool_prop_selfpay AS 基本医疗保险统筹基金支付比例, YB.hifp_pay AS 基本医疗保险统筹基金支出, YB.hifmi_pay AS 居民大病保险资金支出, YB.hifob_pay AS 职工大额医疗费用补助基金支出, YB.cvlserv_pay AS 公务员医疗补助资金支出, YB.hifes_pay AS 企业补充医疗保险基金支出, YB.maf_pay AS 医疗救助基金支出, YB.oth_pay AS 其他支出, YB.acct_mulaid_pay AS 个人账户共济支付金额, YB.psn_part_amt AS 个人负担总金额, YB.medins_setl_id AS 医药机构结算id, YB.clr_optins AS 清算经办机构, YB.clr_way AS 清算方式, YB.clr_type AS 清算类别, YB.balc AS 余额 , YB.inscp_scp_amt AS 符合政策范围金额, YB.fund_pay_sumamt AS 基金支付总额 FROM YB_JIXIAN_CZ_JSDZ YB WHERE YB.CJSJ BETWEEN '2023-03-09 00:00:00' AND '2023-03-11 23:59:59'