-- Start of DDL Script for View SD_HOSPITAL.VW_ZY_RQD000
-- Generated 2021/12/30 12:24:02 from SD_HOSPITAL@zpxzyy

CREATE OR REPLACE VIEW vw_zy_rqd000 (
   qdh000,
   zyid00,
   zyh000,
   jzdh00,
   qdhzyh,
   mrn000,
   xm0000,
   xb0000,
   csrq00,
   rybq00,
   rybqbh,
   rybqmc,
   rzks00,
   rzksbh,
   rzksmc,
   rycwh0,
   hjje00,
   zfje00,
   jzje00,
   gfje00,
   czrq00,
   czsj00,
   czyxm0,
   cyrq00,
   pxxh00,
   sfxnh0,
   ybzxlb,
   fbbh00,
   ryrq00,
   yexm00,
   dbzbm0,
   dbzmc0 )
AS
select
      A.QDRQ00,
      A.ZYID00  ,    --住院ID
      B.ZYH000  ,    --住院号
      min(A.JZDH00)JZDH00  ,
      A.QDRQ00||A.ZYID00,  --清单住院号
      B.MRN000  ,    --病案号
      B.XM0000  ,    --姓名
      B.XB0000  ,    --性别
      B.CSRQ00  ,    --出生日期
      B.DQBQ00  ,    --当前病区编码
      C.BH0000  ,    --当前病区编号
      substrb(C.BMMC00,1,12)  ,    --当前病区名称
      B.DQKS00  ,    --当前科室编码
      D.BH0000  ,    --当前科室编号
      substrb(D.BMMC00,1,12)  ,    --当前科室名称
      B.RYCWH0  ,    --病人住院床号
  sum(A.HJJE00) ,    --合计金额
  sum(A.ZFJE00) ,    --自付金额
  sum(A.JZJE00) ,    --记账金额
  sum(A.GFJE00) ,    --公费金额
      A.QDRQ00  ,    --操作日期
  MAX(A.CZSJ00),
  max(A.CZYXM0) ,     --操作员姓名
      B.CYRQ00  ,
      C.PXXH00  ,
      E.SFXNH0  ,
      E.YBZXLB  ,     --医保中心类别
      B.FBBH00  ,
      B.RYRQ00  ,
      ' ' YEXM00,
      B.DBZBM0  ,
      B.DBZMC0
from  ZY_BRFY00 A,ZY_BRXXB0 B,BM_BMBM00 C,BM_BMBM00 D,IC_YBBRLB E
where A.ZYID00 = B.ZYID00
  and B.DQBQ00 = C.BMBH00
  and B.DQKS00 = D.BMBH00
  and B.FBBH00 = E.FBBH00
  and B.YBLB00 = E.YBLB00
group by  A.ZYID00,B.ZYH000,B.MRN000,B.XM0000,B.XB0000,B.CSRQ00,B.DQBQ00,C.BH0000,C.BMMC00,E.YBZXLB,
     B.DQKS00,D.BH0000,D.BMMC00,B.RYCWH0,B.CYRQ00,A.QDRQ00 ,A.QDRQ00||A.ZYID00,B.CYRQ00,C.PXXH00,E.SFXNH0,B.FBBH00,B.RYRQ00,B.DBZBM0  ,
      B.DBZMC0
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZY_RQD000