-- Start of DDL script for VW_BQ_CYTZD0
-- Generated 17-十二月-14  10:04:23 am
-- from fw2-SD_HOSPITAL:1

-- View VW_BQ_CYTZD0

CREATE OR REPLACE VIEW vw_bq_cytzd0 (
   zyid00,
   zyh000,
   xm0000,
   xb0000,
   rycwh0,
   brnl00,
   cyrqsj,
   ryrq00,
   dqbqmc,
   dqbq00,
   cyrq00,
   zyts00,
   ybmc00 )
AS
select
       a.ZYID00,     --住院ID
       a.ZYH000,     --住院号
       a.XM0000,     --病人姓名
       a.XB0000,     --病人性别
       a.RYCWH0,     --床号
       SF_ZS_CSRQTONL(a.CSRQ00) BRNL00,     --病人年龄
       to_char(to_date(a.SJCYRQ,'YYYYMMDD'),'YYYY.MM.DD') CYRQSJ,      --出院日期时间
       to_char(to_date(a.RYRQ00,'YYYYMMDD'),'YYYY.MM.DD'),
       (select BMMC00 from BM_BMBM00 where BMBH00=a.DQBQ00) DQBQMC,
       DQBQ00,
       SJCYRQ CYRQ00,
       TRUNC(decode(SJCYRQ,'20991231',sysdate,to_date(SJCYRQ,'YYYYMMDD')))-TO_DATE(RYRQ00,'YYYYMMDD') ZYTS00,
       decode(a.YBZXLB,'1','省医保','2','市医保','3','两费中心','4','保健中心','@','新农合','Z','铁路医保','0','自费',a.ybzxlb) YBMC00
       from ZY_BRXXB0 a
/

-- End of DDL script for VW_BQ_CYTZD0