CREATE OR REPLACE VIEW SD_HOSPITAL.VW_EMR_INAPTIENT_DISEASE
 (
 PID, IPID, ADMINISSIONNO, BEDNO, PATIENTNAME, SEX, ADMINISSIONTIME, WARDCODE, 
DEPTCODE, MEDICINECENTERTYPE, MEDICINEPATIENTTYPE, PATIENTTYPESHORTNAME, 
BALANCE, LIMIT, FEETYPENAME, FEETYPECODE, DISEASEINFO, HOSPITALCODE, RECORDSNUMBER, 
RETIRED

 )
 AS 
select A.BRID00,    --病人ID
       A.ZYID00,    --住院ID
       A.ZYH000,    --住院号
       A.RYCWH0,    --床号
       A.XM0000,    --姓名
       A.XB0000,    --性别
       A.RYRQ00,    --入院日期
       A.DQBQ00,    --病区
       A.DQKS00,    --科室
       C.YBZXLB,    --医保中心类别
       A.YBBRLB,    --医保病人类别
       D.BRLBJC,    --病人类别简称
       '<font color=''red''>'||'账户余额'||SF_BQ_KYJE00(A.ZYID00,A.BRID00)||'</font>' YKZYE0,  --预扣后的可用额
       --E.YKZYE0-E.TYJE00 YKZYE0,  --预扣后的可用额
       E.BJJE00,    --报警限额
       F.FBMC00,    --费别名称：自费、记帐、医保等
       A.FBBH00,
       nvl((select '<font color=''blue''>病种(限额'||decode(YBYJS0,0,BZSFJE+DBZHCF,YBYJS0)||' 费用'||nvl(BZNZFY,0)||' 差额'||nvl(BZNCE0,0)||' '||trim(BZMC00)||')</font>' from VW_ZY_DBZCZB where ZYID00=A.ZYID00),' ') diseaseInfo,
       (select nvl(trim(max(YYID00)),'0') from BM_BMBM00 where BMBH00=A.DQKS00) YYID00,
       MRN000,
       '' retired
from ZY_BRXXB0 A,IC_YBBRLB C,BM_YBBRLB D,ZY_BRZHXX E,BM_BRFBB0 F
where C.YBLB00 = A.YBLB00
  and D.YBBRLB = A.YBBRLB
  and D.YBZXLB = C.YBZXLB
  and F.FBBH00 = A.FBBH00
  and E.BRID00 = A.BRID00
  and A.FBBH00 = D.FBBH00
/