create or replace view vw_ba_sjglyyjxkh_xy as
select
'49076061-8' A01,--组织机构代码
'龙岩人民医院' A02,
A.BAH000 A48,  --病案号
A.ZYCS00 A49,--住院次数
(substrb(A.RYRQ00,1,4)||'-'||substrb(A.RYRQ00,5,2)||'-'||substrb(A.RYRQ00,7,2) ||' '|| A.RYSJ00) B12, --入院时间
(substrb(A.cyrq00,1,4)||'-'||substrb(A.cyrq00,5,2)||'-'||substrb(A.CYRQ00,7,2) ||' '|| A.CYSJ00)  B15,--出院时间
A.JKDAH0 A47, --健康卡号
 decode(A.JFFS00,'城镇职工基本医疗保险','1.1','城镇居民基本医疗保险','2.1','社会基本医疗保险','8',
'新型农村合作医疗','3.1','新农合医疗','3.1','贫困救助','4',
'商业医疗保险','5','全公费','6','公费医疗','6','全自费','7','自费医疗','7','自费','7','9') A46C,--医疗付款方式
A.BRXM00 A11, --姓名
decode(A.BRXB00,'女性','2','男性','1','0') A12C,--性别
(substrb(A.BRCSRQ,1,4)||'-'||substrb(A.BRCSRQ,5,2)||'-'||substrb(A.BRCSRQ,7,2))  A13, --出生日期
--substr(SF_BQ_CSRQTONL_DZBL(A.BRCSRQ,A.RYRQ00),1,instr(SF_BQ_CSRQTONL_DZBL(A.BRCSRQ,A.RYRQ00),'岁')-1) A14, --年龄
A.BRNL00 A14,
A.GJ0000 A15C, --国籍
decode(A.HYZK00,'未婚','1','已婚','2','离婚','4','丧偶','3','其他','9','9') A21C,--婚姻
decode(A.ZY0000,'国家公务员','11','专业技术人员','13','职员','17','企业管理人员','21','工人','24','农民','27','学生','31','现役军人',
'37','自由职业者','51','个体经营者','54','无业人员','70','退休人','80','其他','90','90') A38C,--职业
decode((select MZ.DM0000 from XT_MZ0000 MZ where MZ.MC0000=A.MZ0000),'01','1','02','2','06','6','08','8','03','3','07','7','04','4','05','5',
'09','9','97','66',(select MZ.DM0000 from XT_MZ0000 MZ where MZ.MC0000=A.MZ0000)) A19C, --民族
decode(nvl(decode(SP_SF_CHECKSFZH(upper(A.SFZH00)),1,upper(A.SFZH00),''),'-'),'-','9','1') A20N,--证件类别
nvl(decode(SP_SF_CHECKSFZH(upper(A.SFZH00)),1,upper(A.SFZH00),''),'-') A20,--身份证号
/*'1' A20N,--证件类别
nvl(decode(SP_SF_CHECKSFZH(upper(A.SFZH00)),1,upper(A.SFZH00),''),'-') A20,--身份证号*/
--nvl(A.SFZH00,'-') A20,--身份证号,
nvl(trim(A.CSDS00),'-') A22, --出生地
nvl(decode(A.JGSF00,'外籍','35',(select ZD.DM0000 from XT_ZD0000 ZD where ZD.VALUE0=(case when instr(A.JGSF00,'省')>0 then JGSF00 else JGSF00|| '省' end) and ZD.ZDBM00='JG0000')),'13') A23C,--籍贯
nvl(A.JTDZ01,'-')  A24, --户口地址
decode(A.JTYB00,'不详','364000','/','364000','','364000','无','364000','-','364000',A.JTYB00) A25C, --邮编
nvl(A.XZZXC0,'-') A26, --现住址
nvl(A.JTDH00,'-') A27, --电话
decode(A.JTYB00,'不详','364000','/','364000','','364000','无','364000','-','364000',A.JTYB00) A28C, --邮编 (现住址邮政编码)
NVL(A.GZDW00,'-') A29, --工作单位及地址
nvl(trim(A.GZDH00),'-')  A30, --单位电话
decode(A.GZYB00,'无','364000','---','364000','—','364000','不详','364000',null,'364000','/','364000','--','364000',
'----','364000','-----','364000','无 ','364000','\','364000',A.GZYB00,'364000')  A31C, --邮编 (工作邮政编码)
--decode(A.GZYB00,'无','364000',A.GZYB00,'364000')  A31C, --邮编 (工作邮政编码)
nvl(A.LXRXM0,'-') A32, --联系人姓名
decode(A.LXRGX0,'配偶','1','子','2','女','3','孙子、孙女或外孙子、外孙女','4','父母','5','祖父母或外祖父母','6','兄、弟、姐、妹','7','其他','9','9') A33C,
nvl(A.LXRDZ0||A.LXRDZ1,'-') A34,--联系人地址
nvl(trim(A.LXRDH0),'-') A35,--联系人电话
'0'  B38,--是否为日间手术
A.RYTJ00 B11C,--入院途径
(select DM0000 from BA_SJJXDY H where H.BH0000=A.RYKB00 and rownum<=1) B13C,--入院科别
substrb(A.RYBF00,1,4) B14,--入院病房
nvl((select DM0000 from BA_SJJXDY H where H.BH0000=A.ZKKB00 and rownum<=1),'-') B21C,--转科科别
(select DM0000 from BA_SJJXDY H where H.BH0000=A.CYKB00 and rownum<=1)  B16C, --出院科别
substrb(A.CYBF00,1,4) B17,--出院病房
decode(ceil(to_date(A.cyrq00,'yyyy-MM-dd')-to_date(A.RYRQ00,'yyyy-MM-dd')),'0','1',ceil(to_date(A.cyrq00,'yyyy-MM-dd')-to_date(A.RYRQ00,'yyyy-MM-dd')))  B20,--实际住院(天)
--ZYTS00 B20,--实际住院(天)
SF_BA_GETZDMRYBQZLXG20 (A.LSH000,'1',0,1) C01C,--门（急）诊诊断编码
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'1',2,1) C02N,--门（急）诊诊断名称

'' F01,--入院时情况
'' F02C,--入院诊断编码
'' F03N,--入院诊断名称
'' F04,--入院后确诊日期

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'3',0,1) C03C,--主要诊断疾病编码
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'3',2,1) C04N,--主要诊断出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'3',1,1) C05C,--主要诊断入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'3',6,1) F05,--主要诊断出院情况


SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,1) C06x01C, --其他诊断1出院西医诊断编码
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,1) C07x01N, --其他诊断1疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,1) C08x01C, --其他诊断1入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,1) F06x01, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,2) C06x02C, --其他诊断2出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,2) C07x02N, --其他诊断2疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,2) C08x02C, --其他诊断2入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,2) F06x02, --其他诊断出院情况2

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,3) C06x03C, --其他诊断3出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,3) C07x03N, --其他诊断3疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,3) C08x03C, --其他诊断3入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,3) F06x03, --其他诊断出院情况2

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,4) C06x04C, --其他诊断4出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,4) C07x04N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,4) C08x04C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,4) F06x04, --其他诊断出院情况2

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,5) C06x05C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,5) C07x05N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,5) C08x05C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,5) F06x05, --其他诊断出院情况2

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,6) C06x06C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,6) C07x06N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,6) C08x06C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,6) F06x06, --其他诊断出院情况2

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,7) C06x07C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,7) C07x07N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,7) C08x07C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,7) F06x07, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,8) C06x08C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,8) C07x08N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,8) C08x08C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,8) F06x08, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,9) C06x09C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,9) C07x09N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,9) C08x09C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,9) F06x09, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,10) C06x10C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,10) C07x10N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,10) C08x10C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,10) F06x10, --其他诊断出院情况10

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,11) C06x11C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,11) C07x11N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,11) C08x11C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,11) F06x11, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,12) C06x12C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,12) C07x12N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,12) C08x12C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,12) F06x12, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,13) C06x13C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,13) C07x13N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,13) C08x13C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,13) F06x13, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,14) C06x14C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,14) C07x14N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,14) C08x14C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,14) F06x14, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,15) C06x15C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,15) C07x15N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,15) C08x15C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,15) F06x15, --其他诊断出院情况1


SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,16) C06x16C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,16) C07x16N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,16) C08x16C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,16) F06x16, --其他诊断出院情况1


SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,17) C06x17C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,17) C07x17N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,17) C08x17C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,17) F06x17, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,18) C06x18C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,18) C07x18N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,18) C08x18C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,18) F06x18, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,19) C06x19C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,19) C07x19N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,19) C08x19C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,19) F06x19, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,20) C06x20C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,20) C07x20N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,20) C08x20C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,20) F06x20, --其他诊断出院情况1


SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,21) C06x21C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,21) C07x21N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,21) C08x21C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,21) F06x21, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,22) C06x22C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,22) C07x22N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,22) C08x22C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,22) F06x22, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,23) C06x23C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,23) C07x23N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,23) C08x23C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,23) F06x23, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,24) C06x24C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,24) C07x24N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,24) C08x24C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,24) F06x24, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,25) C06x25C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,25) C07x25N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,25) C08x25C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,25) F06x25, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,26) C06x26C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,26) C07x26N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,26) C08x26C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,26) F06x26, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,27) C06x27C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,27) C07x27N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,27) C08x27C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,27) F06x27, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,28) C06x28C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,28) C07x28N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,28) C08x28C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,28) F06x28, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,29) C06x29C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,29) C07x29N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,29) C08x29C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,29) F06x29, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,30) C06x30C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,30) C07x30N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,30) C08x30C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,30) F06x30, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,31) C06x31C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,31) C07x31N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,31) C08x31C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,31) F06x31, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,32) C06x32C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,32) C07x32N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,32) C08x32C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,32) F06x32, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,33) C06x33C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,33) C07x33N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,33) C08x33C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,33) F06x33, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,34) C06x34C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,34) C07x34N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,34) C08x34C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,34) F06x34, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,35) C06x35C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,35) C07x35N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,35) C08x35C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,35) F06x35, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,36) C06x36C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,36) C07x36N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,36) C08x36C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,36) F06x36, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,37) C06x37C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,37) C07x37N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,37) C08x37C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,37) F06x37, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,38) C06x38C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,38) C07x38N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,38) C08x38C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,38) F06x38, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,39) C06x39C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,39) C07x39N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,39) C08x39C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,39) F06x39, --其他诊断出院情况1

SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',0,40) C06x40C, --其他诊断5出院西医诊断
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',2,40) C07x40N, --其他诊断4疾病名称
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',1,40) C08x40C, --其他诊断4入院病情
SF_BA_GETZDMRYBQZLXG20(A.LSH000,'4',6,40) F06x40, --其他诊断出院情况1


nvl((select zd.BLZDBM from BA_BASZYB ZD join bq_baszdb d on zd.lsh000 = d.zyid00  where ZD.lsh000=A.LSH000 and d.ZDLB00='3' and (d.ZDM000 like 'C%' or (SUBSTR(d.ZDM000,1,3) between 'D00' and 'D48') ) and rownum=1),'') C09C,
--(select ZD.BLZDBM from BA_BASZYB ZD  where ZD.LSH000=A.LSH000) C09C,

--nvl((select ZD.FZMC00 from BQ_BASZDB ZD  where ZD.ZYID00=A.LSH000 and ZD.ZDLB00='3' and (ZD.ZDM000 like 'C%' or (SUBSTR(ZD.ZDM000,1,3) between 'D00' and 'D48') ) and rownum=1),'') C10N,
nvl((select ZD.BLZD00 from BA_BASZYB ZD join bq_baszdb d on zd.lsh000 = d.zyid00 where ZD.lsh000=A.LSH000 and d.ZDLB00='3' and (d.ZDM000 like 'C%' or (SUBSTR(d.ZDM000,1,3) between 'D00' and 'D48') ) and rownum=1),'') C10N,
--(select ZD.BLZD00 from BA_BASZYB ZD  where ZD.LSH000=A.LSH000) C10N,



A.BLH000 C11,--病理号

'' F07x01C,--病理诊断编码1
'' F08x01N,--病理诊断名称1
'' F09x01,--病理号1
'' F07x02C,--病理诊断编码2
'' F08x02N,--病理诊断名称2
'' F09x02,--病理号2


(select zd.SSZDBM from BA_BASZYB ZD join bq_baszdb d on zd.lsh000 = d.zyid00  where ZD.lsh000=A.LSH000 and d.ZDLB00='3' and (d.ZDM000 like 'S%' or d.ZDM000 like 'T%') and rownum=1 )  C12C,--损伤码
--A.SSZDWY C13N, --中毒的外部原因
(select zd.SSZDWY from BA_BASZYB ZD join bq_baszdb d on zd.lsh000 = d.zyid00  where ZD.lsh000=A.LSH000 and d.ZDLB00='3' and (d.ZDM000 like 'S%' or d.ZDM000 like 'T%') and rownum=1) C13N,
decode(A.SFYWGM,'无','1','有','2','1') C24C, --药物过敏
decode(A.GMYW00,'未发现','-',A.GMYW00) C25,--过敏药物

'' F10,
'' F11,
'' F12,

nvl2(a.kzr000,(select YSZJHM from    BM_YGBM00  where ygbh00||''=a.kzr000),'') B22C,--科主任编码
nvl(A.KZRMC0,'-') B22,--科主任
nvl2(a.fzr000,(select YSZJHM from    BM_YGBM00  where ygbh00||''=a.fzr000),'') B23C,-- 主（副主）任医师编码
nvl(A.FZRMC0,'-') B23,--副主任
nvl2(a.zzys00,(select YSZJHM from    BM_YGBM00  where ygbh00||''=a.zzys00),'') B24C,--主治医师编码
nvl(A.ZZYSMC,'-') B24,--主治医师
nvl2(a.zyys00,(select YSZJHM from    BM_YGBM00  where ygbh00||''=a.zyys00),'') B25C,--住院医师编码
nvl(A.ZYYSMC,'-') B25,--住院医师
nvl2(a.zrhs00,(select YSZJHM from    BM_YGBM00  where ygbh00||''=a.zrhs00),'') B26C,-- 责任护士编码
nvl(A.ZRHSMC,'-') B26, --责任护士
A.JXYSMC B27, --进修医师
A.YJSMC0 B28,--实习医师
nvl(A.SHRXM0,'-') B29,--编码员
decode(A.BAZL00,'甲','1','乙','2','丙','3','3') B30C,--病案质量
A.ZKYSMC B31,--质控医师
A.ZKHSMC B32, --质控护士
(substrb(A.ZKRQ00,1,4)||'-'||substrb(A.ZKRQ00,5,2)||'-'||substrb(A.ZKRQ00,7,2)) B33,--质控日期
decode(A.SFSJ00,'是','1','否','2','2') C34C,--死亡患者尸检
decode(A.XX0000,'A型','1','B型','2','O型','3','AB型','4','未检','6','未查','6','5') C26C, --血型
decode(A.RH0000,'阴','1','阳','2','不详','3','未查','4','3') C27C, --RH
nvl(SF_BA_GETBABRSSXX20(A.LSH000,0,1),'-') C14x01C,--手术操作编码1
nvl(SF_BA_GETBABRSSXX20(A.LSH000,3,1),'-') C15x01N,--主要手术操作名称
nvl(SF_BA_GETBABRSSXX20(A.LSH000,111,1),'-') C16x01,--手术操作日期1
SF_BA_GETBABRSSXX20(A.LSH000,2,1) C17x01,--手术级别1

'' F13,

SF_BA_GETBABRSSXX20(A.LSH000,6,1) C18x01,--术者1
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,1),'-') C19x01,--I助1
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,1),'-') C20x01,--II助1
SF_BA_GETBABRSSXX20(A.LSH000,11,1) C21x01C, --切口愈合等级
SF_BA_GETBABRSSXX20(A.LSH000,9,1) C22x01C,--麻醉方式

'' F15,

SF_BA_GETBABRSSXX20(A.LSH000,12,1) C23x01, --麻醉医师1
SF_BA_GETBABRSSXX20(A.LSH000,0,2) C35x01C,--手术操作编码2
SF_BA_GETBABRSSXX20(A.LSH000,0,3) C35x02C,--手术操作编码3
SF_BA_GETBABRSSXX20(A.LSH000,0,4) C35x03C,--手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,2) C36x01N,--手术操作名称2
SF_BA_GETBABRSSXX20(A.LSH000,3,3) C36x02N,--手术操作名称3
SF_BA_GETBABRSSXX20(A.LSH000,3,4) C36x03N,--手术操作名称4
SF_BA_GETBABRSSXX20(A.LSH000,111,2) C37x01,--手术操作日期2
SF_BA_GETBABRSSXX20(A.LSH000,111,3) C37x02,--手术操作日期3
SF_BA_GETBABRSSXX20(A.LSH000,111,4) C37x03,--手术操作日期4
SF_BA_GETBABRSSXX20(A.LSH000,2,2) C38x01,--手术级别2
SF_BA_GETBABRSSXX20(A.LSH000,2,3) C38x02,--手术级别3
SF_BA_GETBABRSSXX20(A.LSH000,2,4) C38x03,--手术级别4

'' F14x01,--其他手术持续时间1
'' F14x02,
'' F14x03,

SF_BA_GETBABRSSXX20(A.LSH000,6,2) C39x01,--术者2
SF_BA_GETBABRSSXX20(A.LSH000,6,3) C39x02,--术者3
SF_BA_GETBABRSSXX20(A.LSH000,6,4) C39x03,--术者4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,2),'-') C40x01,--I助2
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,3),'-') C40x02,--I助3
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,4),'-') C40x03,--I助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,2),'-') C41x01,--II助2
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,3),'-') C41x02,--II助3
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,4),'-') C41x03,--II助4
SF_BA_GETBABRSSXX20(A.LSH000,11,2) C42x01C, --切口愈合等级
SF_BA_GETBABRSSXX20(A.LSH000,11,3) C42x02C, --切口愈合等级
SF_BA_GETBABRSSXX20(A.LSH000,11,4) C42x03C, --切口愈合等级
SF_BA_GETBABRSSXX20(A.LSH000,9,2) C43x01C,
SF_BA_GETBABRSSXX20(A.LSH000,9,3) C43x02C,
SF_BA_GETBABRSSXX20(A.LSH000,9,4) C43x03C,
SF_BA_GETBABRSSXX20(A.LSH000,12,2) C44x01, --麻醉医师2
SF_BA_GETBABRSSXX20(A.LSH000,12,3) C44x02, --麻醉医师3
SF_BA_GETBABRSSXX20(A.LSH000,12,4) C44x03, --麻醉医师4


'' F16x01,
'' F16x02,
'' F16x03,

SF_BA_GETBABRSSXX20(A.LSH000,0,5)  C35x04C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,5)  C36x04N,
SF_BA_GETBABRSSXX20(A.LSH000,111,5)  C37x04,
SF_BA_GETBABRSSXX20(A.LSH000,2,5)  C38x04,--其他手术操作级别4
''  F14x04,
SF_BA_GETBABRSSXX20(A.LSH000,6,5)  C39x04,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,5),'-')  C40x04,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,5),'-')  C41x04,
SF_BA_GETBABRSSXX20(A.LSH000,11,5)  C42x04C,
SF_BA_GETBABRSSXX20(A.LSH000,9,5)  C43x04C,--其他手术操作麻醉方式4
''  F16x04,
SF_BA_GETBABRSSXX20(A.LSH000,12,5)  C44x04,

SF_BA_GETBABRSSXX20(A.LSH000,0,6) C35x05C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,6) C36x05N,
SF_BA_GETBABRSSXX20(A.LSH000,111,6) C37x05,
SF_BA_GETBABRSSXX20(A.LSH000,2,6) C38x05,--其他手术操作级别4
'' F14x05,
SF_BA_GETBABRSSXX20(A.LSH000,6,6) C39x05,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,6),'-') C40x05,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,6),'-') C41x05,
SF_BA_GETBABRSSXX20(A.LSH000,11,6) C42x05C,
SF_BA_GETBABRSSXX20(A.LSH000,9,6) C43x05C,--其他手术操作麻醉方式4
'' F16x05,
SF_BA_GETBABRSSXX20(A.LSH000,12,6) C44x05,

SF_BA_GETBABRSSXX20(A.LSH000,0,7) C35x06C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,7) C36x06N,
SF_BA_GETBABRSSXX20(A.LSH000,111,7) C37x06,
SF_BA_GETBABRSSXX20(A.LSH000,2,7) C38x06,--其他手术操作级别4
'' F14x06,
SF_BA_GETBABRSSXX20(A.LSH000,6,7) C39x06,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,7),'-') C40x06,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,7),'-') C41x06,
SF_BA_GETBABRSSXX20(A.LSH000,11,7) C42x06C,
SF_BA_GETBABRSSXX20(A.LSH000,9,7) C43x06C,--其他手术操作麻醉方式4
'' F16x06,
SF_BA_GETBABRSSXX20(A.LSH000,12,7) C44x06,

SF_BA_GETBABRSSXX20(A.LSH000,0,8) C35x07C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,8) C36x07N,
SF_BA_GETBABRSSXX20(A.LSH000,111,8) C37x07,
SF_BA_GETBABRSSXX20(A.LSH000,2,8) C38x07,--其他手术操作级别4
'' F14x07,
SF_BA_GETBABRSSXX20(A.LSH000,6,8) C39x07,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,8),'-') C40x07,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,8),'-') C41x07,
SF_BA_GETBABRSSXX20(A.LSH000,11,8) C42x07C,
SF_BA_GETBABRSSXX20(A.LSH000,9,8) C43x07C,--其他手术操作麻醉方式4
'' F16x07,
SF_BA_GETBABRSSXX20(A.LSH000,12,8) C44x07,

SF_BA_GETBABRSSXX20(A.LSH000,0,9) C35x08C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,9) C36x08N,
SF_BA_GETBABRSSXX20(A.LSH000,111,9) C37x08,
SF_BA_GETBABRSSXX20(A.LSH000,2,9) C38x08,--其他手术操作级别4
'' F14x08,
SF_BA_GETBABRSSXX20(A.LSH000,6,9) C39x08,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,9),'-') C40x08,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,9),'-') C41x08,
SF_BA_GETBABRSSXX20(A.LSH000,11,9) C42x08C,
SF_BA_GETBABRSSXX20(A.LSH000,9,9) C43x08C,--其他手术操作麻醉方式4
'' F16x08,
SF_BA_GETBABRSSXX20(A.LSH000,12,9) C44x08,

SF_BA_GETBABRSSXX20(A.LSH000,0,10) C35x09C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,10) C36x09N,
SF_BA_GETBABRSSXX20(A.LSH000,111,10) C37x09,
SF_BA_GETBABRSSXX20(A.LSH000,2,10) C38x09,--其他手术操作级别4
'' F14x09,
SF_BA_GETBABRSSXX20(A.LSH000,6,10) C39x09,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,10),'-') C40x09,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,10),'-') C41x09,
SF_BA_GETBABRSSXX20(A.LSH000,11,10) C42x09C,
SF_BA_GETBABRSSXX20(A.LSH000,9,10) C43x09C,--其他手术操作麻醉方式4
'' F16x09,
SF_BA_GETBABRSSXX20(A.LSH000,12,10) C44x09,

SF_BA_GETBABRSSXX20(A.LSH000,0,11) C35x10C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,11) C36x10N,
SF_BA_GETBABRSSXX20(A.LSH000,111,11) C37x10,
SF_BA_GETBABRSSXX20(A.LSH000,2,11) C38x10,--其他手术操作级别4
'' F14x10,
SF_BA_GETBABRSSXX20(A.LSH000,6,11) C39x10,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,11),'-') C40x10,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,11),'-') C41x10,
SF_BA_GETBABRSSXX20(A.LSH000,11,11) C42x10C,
SF_BA_GETBABRSSXX20(A.LSH000,9,11) C43x10C,--其他手术操作麻醉方式4
'' F16x10,
SF_BA_GETBABRSSXX20(A.LSH000,12,11) C44x10,

SF_BA_GETBABRSSXX20(A.LSH000,0,12) C35x11C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,12) C36x11N,
SF_BA_GETBABRSSXX20(A.LSH000,111,12) C37x11,
SF_BA_GETBABRSSXX20(A.LSH000,2,12) C38x11,--其他手术操作级别4
'' F14x11,
SF_BA_GETBABRSSXX20(A.LSH000,6,12) C39x11,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,12),'-') C40x11,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,12),'-') C41x11,
SF_BA_GETBABRSSXX20(A.LSH000,11,12) C42x11C,
SF_BA_GETBABRSSXX20(A.LSH000,9,12) C43x11C,--其他手术操作麻醉方式4
'' F16x11,
SF_BA_GETBABRSSXX20(A.LSH000,12,12) C44x11,

SF_BA_GETBABRSSXX20(A.LSH000,0,13) C35x12C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,13) C36x12N,
SF_BA_GETBABRSSXX20(A.LSH000,111,13) C37x12,
SF_BA_GETBABRSSXX20(A.LSH000,2,13) C38x12,--其他手术操作级别4
'' F14x12,
SF_BA_GETBABRSSXX20(A.LSH000,6,13) C39x12,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,13),'-') C40x12,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,13),'-') C41x12,
SF_BA_GETBABRSSXX20(A.LSH000,11,13) C42x12C,
SF_BA_GETBABRSSXX20(A.LSH000,9,13) C43x12C,--其他手术操作麻醉方式4
'' F16x12,
SF_BA_GETBABRSSXX20(A.LSH000,12,13) C44x12,

SF_BA_GETBABRSSXX20(A.LSH000,0,14) C35x13C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,14) C36x13N,
SF_BA_GETBABRSSXX20(A.LSH000,111,14) C37x13,
SF_BA_GETBABRSSXX20(A.LSH000,2,14) C38x13,--其他手术操作级别4
'' F14x13,
SF_BA_GETBABRSSXX20(A.LSH000,6,14) C39x13,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,14),'-') C40x13,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,14),'-') C41x13,
SF_BA_GETBABRSSXX20(A.LSH000,11,14) C42x13C,
SF_BA_GETBABRSSXX20(A.LSH000,9,14) C43x13C,--其他手术操作麻醉方式4
'' F16x13,
SF_BA_GETBABRSSXX20(A.LSH000,12,14) C44x13,

SF_BA_GETBABRSSXX20(A.LSH000,0,15) C35x14C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,15) C36x14N,
SF_BA_GETBABRSSXX20(A.LSH000,111,15) C37x14,
SF_BA_GETBABRSSXX20(A.LSH000,2,15) C38x14,--其他手术操作级别4
'' F14x14,
SF_BA_GETBABRSSXX20(A.LSH000,6,15) C39x14,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,15),'-') C40x14,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,15),'-') C41x14,
SF_BA_GETBABRSSXX20(A.LSH000,11,15) C42x14C,
SF_BA_GETBABRSSXX20(A.LSH000,9,15) C43x14C,--其他手术操作麻醉方式4
'' F16x14,
SF_BA_GETBABRSSXX20(A.LSH000,12,15) C44x14,

SF_BA_GETBABRSSXX20(A.LSH000,0,16) C35x15C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,16) C36x15N,
SF_BA_GETBABRSSXX20(A.LSH000,111,16) C37x15,
SF_BA_GETBABRSSXX20(A.LSH000,2,16) C38x15,--其他手术操作级别4
'' F14x15,
SF_BA_GETBABRSSXX20(A.LSH000,6,16) C39x15,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,16),'-') C40x15,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,16),'-') C41x15,
SF_BA_GETBABRSSXX20(A.LSH000,11,16) C42x15C,
SF_BA_GETBABRSSXX20(A.LSH000,9,16) C43x15C,--其他手术操作麻醉方式4
'' F16x15,
SF_BA_GETBABRSSXX20(A.LSH000,12,16) C44x15,

SF_BA_GETBABRSSXX20(A.LSH000,0,17) C35x16C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,17) C36x16N,
SF_BA_GETBABRSSXX20(A.LSH000,111,17) C37x16,
SF_BA_GETBABRSSXX20(A.LSH000,2,17) C38x16,--其他手术操作级别4
'' F14x16,
SF_BA_GETBABRSSXX20(A.LSH000,6,17) C39x16,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,17),'-') C40x16,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,17),'-') C41x16,
SF_BA_GETBABRSSXX20(A.LSH000,11,17) C42x16C,
SF_BA_GETBABRSSXX20(A.LSH000,9,17) C43x16C,--其他手术操作麻醉方式4
'' F16x16,
SF_BA_GETBABRSSXX20(A.LSH000,12,17) C44x16,

SF_BA_GETBABRSSXX20(A.LSH000,0,18) C35x17C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,18) C36x17N,
SF_BA_GETBABRSSXX20(A.LSH000,111,18) C37x17,
SF_BA_GETBABRSSXX20(A.LSH000,2,18) C38x17,--其他手术操作级别4
'' F14x17,
SF_BA_GETBABRSSXX20(A.LSH000,6,18) C39x17,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,18),'-') C40x17,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,18),'-') C41x17,
SF_BA_GETBABRSSXX20(A.LSH000,11,18) C42x17C,
SF_BA_GETBABRSSXX20(A.LSH000,9,18) C43x17C,--其他手术操作麻醉方式4
'' F16x17,
SF_BA_GETBABRSSXX20(A.LSH000,12,18) C44x17,

SF_BA_GETBABRSSXX20(A.LSH000,0,19) C35x18C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,19) C36x18N,
SF_BA_GETBABRSSXX20(A.LSH000,111,19) C37x18,
SF_BA_GETBABRSSXX20(A.LSH000,2,19) C38x18,--其他手术操作级别4
'' F14x18,
SF_BA_GETBABRSSXX20(A.LSH000,6,19) C39x18,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,19),'-') C40x18,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,19),'-') C41x18,
SF_BA_GETBABRSSXX20(A.LSH000,11,19) C42x18C,
SF_BA_GETBABRSSXX20(A.LSH000,9,19) C43x18C,--其他手术操作麻醉方式4
'' F16x18,
SF_BA_GETBABRSSXX20(A.LSH000,12,19) C44x18,

SF_BA_GETBABRSSXX20(A.LSH000,0,20) C35x19C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,20) C36x19N,
SF_BA_GETBABRSSXX20(A.LSH000,111,20) C37x19,
SF_BA_GETBABRSSXX20(A.LSH000,2,20) C38x19,--其他手术操作级别4
'' F14x19,
SF_BA_GETBABRSSXX20(A.LSH000,6,20) C39x19,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,20),'-') C40x19,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,20),'-') C41x19,
SF_BA_GETBABRSSXX20(A.LSH000,11,20) C42x19C,
SF_BA_GETBABRSSXX20(A.LSH000,9,20) C43x19C,--其他手术操作麻醉方式4
'' F16x19,
SF_BA_GETBABRSSXX20(A.LSH000,12,20) C44x19,

SF_BA_GETBABRSSXX20(A.LSH000,0,21) C35x20C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,21) C36x20N,
SF_BA_GETBABRSSXX20(A.LSH000,111,21) C37x20,
SF_BA_GETBABRSSXX20(A.LSH000,2,21) C38x20,--其他手术操作级别4
'' F14x20,
SF_BA_GETBABRSSXX20(A.LSH000,6,21) C39x20,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,21),'-') C40x20,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,21),'-') C41x20,
SF_BA_GETBABRSSXX20(A.LSH000,11,21) C42x20C,
SF_BA_GETBABRSSXX20(A.LSH000,9,21) C43x20C,--其他手术操作麻醉方式4
'' F16x20,
SF_BA_GETBABRSSXX20(A.LSH000,12,21) C44x20,

SF_BA_GETBABRSSXX20(A.LSH000,0,22) C35x21C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,22) C36x21N,
SF_BA_GETBABRSSXX20(A.LSH000,111,22) C37x21,
SF_BA_GETBABRSSXX20(A.LSH000,2,22) C38x21,--其他手术操作级别4
'' F14x21,
SF_BA_GETBABRSSXX20(A.LSH000,6,22) C39x21,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,22),'-') C40x21,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,22),'-') C41x21,
SF_BA_GETBABRSSXX20(A.LSH000,11,22) C42x21C,
SF_BA_GETBABRSSXX20(A.LSH000,9,22) C43x21C,--其他手术操作麻醉方式4
'' F16x21,
SF_BA_GETBABRSSXX20(A.LSH000,12,22) C44x21,

SF_BA_GETBABRSSXX20(A.LSH000,0,23) C35x22C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,23) C36x22N,
SF_BA_GETBABRSSXX20(A.LSH000,111,23) C37x22,
SF_BA_GETBABRSSXX20(A.LSH000,2,23) C38x22,--其他手术操作级别4
'' F14x22,
SF_BA_GETBABRSSXX20(A.LSH000,6,23) C39x22,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,23),'-') C40x22,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,23),'-') C41x22,
SF_BA_GETBABRSSXX20(A.LSH000,11,23) C42x22C,
SF_BA_GETBABRSSXX20(A.LSH000,9,23) C43x22C,--其他手术操作麻醉方式4
'' F16x22,
SF_BA_GETBABRSSXX20(A.LSH000,12,23) C44x22,

SF_BA_GETBABRSSXX20(A.LSH000,0,24) C35x23C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,24) C36x23N,
SF_BA_GETBABRSSXX20(A.LSH000,111,24) C37x23,
SF_BA_GETBABRSSXX20(A.LSH000,2,24) C38x23,--其他手术操作级别4
'' F14x23,
SF_BA_GETBABRSSXX20(A.LSH000,6,24) C39x23,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,24),'-') C40x23,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,24),'-') C41x23,
SF_BA_GETBABRSSXX20(A.LSH000,11,24) C42x23C,
SF_BA_GETBABRSSXX20(A.LSH000,9,24) C43x23C,--其他手术操作麻醉方式4
'' F16x23,
SF_BA_GETBABRSSXX20(A.LSH000,12,24) C44x23,

SF_BA_GETBABRSSXX20(A.LSH000,0,25) C35x24C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,25) C36x24N,
SF_BA_GETBABRSSXX20(A.LSH000,111,25) C37x24,
SF_BA_GETBABRSSXX20(A.LSH000,2,25) C38x24,--其他手术操作级别4
'' F14x24,
SF_BA_GETBABRSSXX20(A.LSH000,6,25) C39x24,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,25),'-') C40x24,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,25),'-') C41x24,
SF_BA_GETBABRSSXX20(A.LSH000,11,25) C42x24C,
SF_BA_GETBABRSSXX20(A.LSH000,9,25) C43x24C,--其他手术操作麻醉方式4
'' F16x24,
SF_BA_GETBABRSSXX20(A.LSH000,12,25) C44x24,

SF_BA_GETBABRSSXX20(A.LSH000,0,26) C35x25C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,26) C36x25N,
SF_BA_GETBABRSSXX20(A.LSH000,111,26) C37x25,
SF_BA_GETBABRSSXX20(A.LSH000,2,26) C38x25,--其他手术操作级别4
'' F14x25,
SF_BA_GETBABRSSXX20(A.LSH000,6,26) C39x25,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,26),'-') C40x25,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,26),'-') C41x25,
SF_BA_GETBABRSSXX20(A.LSH000,11,26) C42x25C,
SF_BA_GETBABRSSXX20(A.LSH000,9,26) C43x25C,--其他手术操作麻醉方式4
'' F16x25,
SF_BA_GETBABRSSXX20(A.LSH000,12,26) C44x25,

SF_BA_GETBABRSSXX20(A.LSH000,0,27) C35x26C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,27) C36x26N,
SF_BA_GETBABRSSXX20(A.LSH000,111,27) C37x26,
SF_BA_GETBABRSSXX20(A.LSH000,2,27) C38x26,--其他手术操作级别4
'' F14x26,
SF_BA_GETBABRSSXX20(A.LSH000,6,27) C39x26,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,27),'-') C40x26,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,27),'-') C41x26,
SF_BA_GETBABRSSXX20(A.LSH000,11,27) C42x26C,
SF_BA_GETBABRSSXX20(A.LSH000,9,27) C43x26C,--其他手术操作麻醉方式4
'' F16x26,
SF_BA_GETBABRSSXX20(A.LSH000,12,27) C44x26,

SF_BA_GETBABRSSXX20(A.LSH000,0,28) C35x27C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,28) C36x27N,
SF_BA_GETBABRSSXX20(A.LSH000,111,28) C37x27,
SF_BA_GETBABRSSXX20(A.LSH000,2,28) C38x27,--其他手术操作级别4
'' F14x27,
SF_BA_GETBABRSSXX20(A.LSH000,6,28) C39x27,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,28),'-') C40x27,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,28),'-') C41x27,
SF_BA_GETBABRSSXX20(A.LSH000,11,28) C42x27C,
SF_BA_GETBABRSSXX20(A.LSH000,9,28) C43x27C,--其他手术操作麻醉方式4
'' F16x27,
SF_BA_GETBABRSSXX20(A.LSH000,12,28) C44x27,


SF_BA_GETBABRSSXX20(A.LSH000,0,29) C35x28C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,29) C36x28N,
SF_BA_GETBABRSSXX20(A.LSH000,111,29) C37x28,
SF_BA_GETBABRSSXX20(A.LSH000,2,29) C38x28,--其他手术操作级别4
'' F14x28,
SF_BA_GETBABRSSXX20(A.LSH000,6,29) C39x28,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,29),'-') C40x28,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,29),'-') C41x28,
SF_BA_GETBABRSSXX20(A.LSH000,11,29) C42x28C,
SF_BA_GETBABRSSXX20(A.LSH000,9,29) C43x28C,--其他手术操作麻醉方式4
'' F16x28,
SF_BA_GETBABRSSXX20(A.LSH000,12,29) C44x28,


SF_BA_GETBABRSSXX20(A.LSH000,0,30) C35x29C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,30) C36x29N,
SF_BA_GETBABRSSXX20(A.LSH000,111,30) C37x29,
SF_BA_GETBABRSSXX20(A.LSH000,2,30) C38x29,--其他手术操作级别4
'' F14x29,
SF_BA_GETBABRSSXX20(A.LSH000,6,30) C39x29,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,30),'-') C40x29,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,30),'-') C41x29,
SF_BA_GETBABRSSXX20(A.LSH000,11,30) C42x29C,
SF_BA_GETBABRSSXX20(A.LSH000,9,30) C43x29C,--其他手术操作麻醉方式4
'' F16x29,
SF_BA_GETBABRSSXX20(A.LSH000,12,30) C44x29,

SF_BA_GETBABRSSXX20(A.LSH000,0,31) C35x30C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,31) C36x30N,
SF_BA_GETBABRSSXX20(A.LSH000,111,31) C37x30,
SF_BA_GETBABRSSXX20(A.LSH000,2,31) C38x30,--其他手术操作级别4
'' F14x30,
SF_BA_GETBABRSSXX20(A.LSH000,6,31) C39x30,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,31),'-') C40x30,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,31),'-') C41x30,
SF_BA_GETBABRSSXX20(A.LSH000,11,31) C42x30C,
SF_BA_GETBABRSSXX20(A.LSH000,9,31) C43x30C,--其他手术操作麻醉方式4
'' F16x30,
SF_BA_GETBABRSSXX20(A.LSH000,12,31) C44x30,

SF_BA_GETBABRSSXX20(A.LSH000,0,32) C35x31C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,32) C36x31N,
SF_BA_GETBABRSSXX20(A.LSH000,111,32) C37x31,
SF_BA_GETBABRSSXX20(A.LSH000,2,32) C38x31,--其他手术操作级别4
'' F14x31,
SF_BA_GETBABRSSXX20(A.LSH000,6,32) C39x31,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,32),'-') C40x31,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,32),'-') C41x31,
SF_BA_GETBABRSSXX20(A.LSH000,11,32) C42x31C,
SF_BA_GETBABRSSXX20(A.LSH000,9,32) C43x31C,--其他手术操作麻醉方式4
'' F16x31,
SF_BA_GETBABRSSXX20(A.LSH000,12,32) C44x31,

SF_BA_GETBABRSSXX20(A.LSH000,0,33) C35x32C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,33) C36x32N,
SF_BA_GETBABRSSXX20(A.LSH000,111,33) C37x32,
SF_BA_GETBABRSSXX20(A.LSH000,2,33) C38x32,--其他手术操作级别4
'' F14x32,
SF_BA_GETBABRSSXX20(A.LSH000,6,33) C39x32,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,33),'-') C40x32,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,33),'-') C41x32,
SF_BA_GETBABRSSXX20(A.LSH000,11,33) C42x32C,
SF_BA_GETBABRSSXX20(A.LSH000,9,33) C43x32C,--其他手术操作麻醉方式4
'' F16x32,
SF_BA_GETBABRSSXX20(A.LSH000,12,33) C44x32,

SF_BA_GETBABRSSXX20(A.LSH000,0,34) C35x33C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,34) C36x33N,
SF_BA_GETBABRSSXX20(A.LSH000,111,34) C37x33,
SF_BA_GETBABRSSXX20(A.LSH000,2,34) C38x33,--其他手术操作级别4
'' F14x33,
SF_BA_GETBABRSSXX20(A.LSH000,6,34) C39x33,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,34),'-') C40x33,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,34),'-') C41x33,
SF_BA_GETBABRSSXX20(A.LSH000,11,34) C42x33C,
SF_BA_GETBABRSSXX20(A.LSH000,9,34) C43x33C,--其他手术操作麻醉方式4
'' F16x33,
SF_BA_GETBABRSSXX20(A.LSH000,12,34) C44x33,

SF_BA_GETBABRSSXX20(A.LSH000,0,35) C35x34C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,35) C36x34N,
SF_BA_GETBABRSSXX20(A.LSH000,111,35) C37x34,
SF_BA_GETBABRSSXX20(A.LSH000,2,35) C38x34,--其他手术操作级别4
'' F14x34,
SF_BA_GETBABRSSXX20(A.LSH000,6,35) C39x34,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,35),'-') C40x34,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,35),'-') C41x34,
SF_BA_GETBABRSSXX20(A.LSH000,11,35) C42x34C,
SF_BA_GETBABRSSXX20(A.LSH000,9,35) C43x34C,--其他手术操作麻醉方式4
'' F16x34,
SF_BA_GETBABRSSXX20(A.LSH000,12,35) C44x34,

SF_BA_GETBABRSSXX20(A.LSH000,0,36) C35x35C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,36) C36x35N,
SF_BA_GETBABRSSXX20(A.LSH000,111,36) C37x35,
SF_BA_GETBABRSSXX20(A.LSH000,2,36) C38x35,--其他手术操作级别4
'' F14x35,
SF_BA_GETBABRSSXX20(A.LSH000,6,36) C39x35,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,36),'-') C40x35,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,36),'-') C41x35,
SF_BA_GETBABRSSXX20(A.LSH000,11,36) C42x35C,
SF_BA_GETBABRSSXX20(A.LSH000,9,36) C43x35C,--其他手术操作麻醉方式4
'' F16x35,
SF_BA_GETBABRSSXX20(A.LSH000,12,36) C44x35,

SF_BA_GETBABRSSXX20(A.LSH000,0,37) C35x36C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,37) C36x36N,
SF_BA_GETBABRSSXX20(A.LSH000,111,37) C37x36,
SF_BA_GETBABRSSXX20(A.LSH000,2,37) C38x36,--其他手术操作级别4
'' F14x36,
SF_BA_GETBABRSSXX20(A.LSH000,6,37) C39x36,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,37),'-') C40x36,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,37),'-') C41x36,
SF_BA_GETBABRSSXX20(A.LSH000,11,37) C42x36C,
SF_BA_GETBABRSSXX20(A.LSH000,9,37) C43x36C,--其他手术操作麻醉方式4
'' F16x36,
SF_BA_GETBABRSSXX20(A.LSH000,12,37) C44x36,


SF_BA_GETBABRSSXX20(A.LSH000,0,38) C35x37C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,38) C36x37N,
SF_BA_GETBABRSSXX20(A.LSH000,111,38) C37x37,
SF_BA_GETBABRSSXX20(A.LSH000,2,38) C38x37,--其他手术操作级别4
'' F14x37,
SF_BA_GETBABRSSXX20(A.LSH000,6,38) C39x37,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,38),'-') C40x37,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,38),'-') C41x37,
SF_BA_GETBABRSSXX20(A.LSH000,11,38) C42x37C,
SF_BA_GETBABRSSXX20(A.LSH000,9,38) C43x37C,--其他手术操作麻醉方式4
'' F16x37,
SF_BA_GETBABRSSXX20(A.LSH000,12,38) C44x37,

SF_BA_GETBABRSSXX20(A.LSH000,0,39) C35x38C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,39) C36x38N,
SF_BA_GETBABRSSXX20(A.LSH000,111,39) C37x38,
SF_BA_GETBABRSSXX20(A.LSH000,2,39) C38x38,--其他手术操作级别4
'' F14x38,
SF_BA_GETBABRSSXX20(A.LSH000,6,39) C39x38,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,39),'-') C40x38,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,39),'-') C41x38,
SF_BA_GETBABRSSXX20(A.LSH000,11,39) C42x38C,
SF_BA_GETBABRSSXX20(A.LSH000,9,39) C43x38C,--其他手术操作麻醉方式4
'' F16x38,
SF_BA_GETBABRSSXX20(A.LSH000,12,39) C44x38,

SF_BA_GETBABRSSXX20(A.LSH000,0,40) C35x39C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,40) C36x39N,
SF_BA_GETBABRSSXX20(A.LSH000,111,40) C37x39,
SF_BA_GETBABRSSXX20(A.LSH000,2,40) C38x39,--其他手术操作级别4
'' F14x39,
SF_BA_GETBABRSSXX20(A.LSH000,6,40) C39x39,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,40),'-') C40x39,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,40),'-') C41x39,
SF_BA_GETBABRSSXX20(A.LSH000,11,40) C42x39C,
SF_BA_GETBABRSSXX20(A.LSH000,9,40) C43x39C,--其他手术操作麻醉方式4
'' F16x39,
SF_BA_GETBABRSSXX20(A.LSH000,12,40) C44x39,


SF_BA_GETBABRSSXX20(A.LSH000,0,41) C35x40C,--其他手术操作编码4
SF_BA_GETBABRSSXX20(A.LSH000,3,41) C36x40N,
SF_BA_GETBABRSSXX20(A.LSH000,111,41) C37x40,
SF_BA_GETBABRSSXX20(A.LSH000,2,41) C38x40,--其他手术操作级别4
'' F14x40,
SF_BA_GETBABRSSXX20(A.LSH000,6,41) C39x40,
nvl(SF_BA_GETBABRSSXX20(A.LSH000,7,41),'-') C40x40,--其他手术操作Ⅰ助4
nvl(SF_BA_GETBABRSSXX20(A.LSH000,8,41),'-') C41x40,
SF_BA_GETBABRSSXX20(A.LSH000,11,41) C42x40C,
SF_BA_GETBABRSSXX20(A.LSH000,9,41) C43x40C,--其他手术操作麻醉方式4
'' F16x40,
SF_BA_GETBABRSSXX20(A.LSH000,12,41) C44x40,


'' F17,
'' F18,
'' F19,
'' F20,
'' F21,
'' F22,
'' F23,
'' F24,
'' F25,
'' F26,


decode(A.BRNLDD,'0','',A.BRNLDD) A16, --（年龄不足1周岁的）年龄(月)
A.YECSTZ A18x01, --新生儿出生体重(克)
'' A18x02,
'' A18x03,
'' A18x04,
'' A18x05,
A.YERYTZ A17, --新生儿入院体重（克）
NVL(to_char(A.HMRYQD),'-') C28,--入院前时间（颅脑损伤患者昏迷时间 天）
nvl(to_char(A.HMRYQH),'-') C29,--入院前多少小时（颅脑损伤患者昏迷时间 小时）
NVL(to_char(A.HMRYQM),'0') C30, --入院前多少小分钟（颅脑损伤患者昏迷时间 分钟）
NVL(to_char(A.HMRYHD),'0') C31,
NVL(to_char(A.HMRYHH),'0') C32,--入院后多少小时（颅脑损伤患者昏迷时间 小时）
NVL(to_char(A.HMRYHM),'0') C33,--入院后多少分钟（颅脑损伤患者昏迷时间 分钟）

--(select b.jicurq ||' '||b.jicusj  from BA_BRZYFY b where b.zyid00 = a.lsh000) C471,
--(select b.cicurq ||' '||b.cicusj  from BA_BRZYFY b where b.zyid00 = a.lsh000) C472,
(select decode(trim(b.hxjysj),' ','0','-','0','/','0','—','0','--','0','+','0',CEIL(trim(b.hxjysj))) from BA_BRZYFY b where b.zyid00 = a.lsh000) C47,
(select decode(b.jicurq,'','',substrb(b.jicurq,1,4)||'-'||substrb(b.jicurq,5,2)||'-'||substrb(b.jicurq,7,2)) || ' ' || b.jicusj from BA_BRZYFY b where b.zyid00 = a.lsh000) C49x01,
(select decode(b.cicurq,'','',substrb(b.cicurq,1,4)||'-'||substrb(b.cicurq,5,2)||'-'||substrb(b.cicurq,7,2)) || ' ' || b.cicusj from BA_BRZYFY b where b.zyid00 = a.lsh000) C50x01,

--a.HXJSJ0  C47,--有创呼吸机使用时间
'' C48x01C,--重症监护室名称1
--'' C49x01,--进入时间1
--'' C50x01,--退出时间1

'' C48x02C,--重症监护室名称2
'' C49x02,--进入时间1
'' C50x02,--退出时间1

'' C48x03C,--重症监护室名称3
'' C49x03,--进入时间1
'' C50x03,--退出时间1

'' C48x04C,--重症监护室名称4
'' C49x04,--进入时间1
'' C50x04,--退出时间1

'' C48x05C,--重症监护室名称5
'' C49x05,--进入时间1
'' C50x05,--退出时间1

decode(A.ZZYJH0,'有','2','无','1','1') B36C, --出院31天内再住院计划
A.ZZYMD0 B37, --出院31天内再住院计划目的
decode(A.LYFS00,'医嘱离院','1','医嘱转院','2','医嘱转社区卫生服务机构','3','非医嘱离院','4','死亡','5','其他','9','9') B34C,--离院方式
A.ZYYLJG B35,--医嘱转社区卫生服务机构/乡镇卫生院，拟接收医疗机构名称
FY.ZYZFY0 D01, --总费用
FY.ZFJE00 D09, --自付金额
FY.YBYLFW D11, --一般医疗服务费
FY.YBZLCZ D12, --一般治疗操作费
FY.HLF000 D13, --护理费
FY.QTFY00 D14, --其他费
FY.BLZDF0 D15, --病理诊断费
FY.SYSZDF D16, --实验室诊断费
FY.YXXZDF D17, --影像学诊断费
FY.LCZDXM D18, --临床诊断项目费
FY.FSSZLF D19, --非手术治疗项目费
FY.LCWLZL D19x01, --临床物理治疗费
FY.SSZLF0 D20, --手术治疗费
FY.MZF000 D20x01, --麻醉费
FY.SSF000 D20x02, --手术费
FY.KFF000 D21, --康复费
FY.ZYZL00 D22,--中医治疗
FY.XYF000 D23, --西药费
FY.KJYWF0 D23x01, --抗菌药物费
FY.ZCYF00 D24, --中成药费
FY.ZCYF10 D25, --中草药费
FY.XF0000 D26, --血费
FY.BDBLZP D27, --白蛋白类制品费
FY.QDBLZP D28, --球蛋白类制品费
FY.NXYZZP D29, --凝血因子类制品费
FY.XBYZZP D30, --细胞因子类制品费
FY.JCYCLF D31, --检查用一次性医用材料费
FY.ZLYCLF D32, --治疗用一次性医用材料费
FY.SSYCLF D33, --手术用一次性医用材料费
FY.Qtf000 D34,
cyrq00
from BA_BRZYXX A join BA_SYFYB0 FY on A.LSH000=FY.ZYID00;