--新病历组成项目 HQ 2013-06-28
insert into XT_XTCS00 (NAME00, VALUE0, FLAG00, BZ0000)
values ('ZS_XBLZCFL', 'Y', '1', '新病历组成项目,Y-开启,N-不开启');
commit;
--##2013.06.29 yangy  病历组成分类初始化
insert into ZS_BLZCFL(FLID00,FLBH00,FLMC00,PLXH00,SFYX00)
values(1,'001','住院记录',1,'1');
insert into ZS_BLZCFL(FLID00,FLBH00,FLMC00,PLXH00,SFYX00)
values(2,'002','病程记录',2,'1');
insert into ZS_BLZCFL(FLID00,FLBH00,FLMC00,PLXH00,SFYX00)
values(3,'003','手术相关记录',3,'1');
insert into ZS_BLZCFL(FLID00,FLBH00,FLMC00,PLXH00,SFYX00)
values(4,'004','其他记录',4,'1');
insert into ZS_BLZCFL(FLID00,FLBH00,FLMC00,PLXH00,SFYX00)
values(5,'005','新生婴儿病程',5,'1');
--参照省人民医院的初始化病历组成分类
update ZS_BLZCXM set FLID00=1, PLXH00='2001' where BLXZ00='21' and FLID00 is null;
update ZS_BLZCXM set FLID00=1, PLXH00='2002' where BLXZ00='22' and FLID00 is null;
update ZS_BLZCXM set FLID00=1, PLXH00='2003' where BLXZ00='23' and FLID00 is null;
update ZS_BLZCXM set FLID00=1, PLXH00='2004' where BLXZ00='24' and FLID00 is null;
update ZS_BLZCXM set FLID00=1, PLXH00='2005' where BLXZ00='25' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3001' where BLXZ00='31' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3002' where BLXZ00='33' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3003' where BLXZ00='32' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3004' where BLXZ00='3D' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3005' where BLXZ00='3G' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3006' where BLXZ00='37' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3007' where BLXZ00='38' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3008' where BLXZ00='35' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3009' where BLXZ00='36' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3010' where BLXZ00='39' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3011' where BLXZ00='3A' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3012' where BLXZ00='3C' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3017' where BLXZ00='3K' and FLID00 is null;
update ZS_BLZCXM set FLID00=2, PLXH00='3018' where BLXZ00='3L' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='3014' where BLXZ00='3E' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='3015' where BLXZ00='3F' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='4016' where BLXZ00='45' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='4017' where BLXZ00='3H' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='4018' where BLXZ00='47' and FLID00 is null;
update ZS_BLZCXM set FLID00=3, PLXH00='4019' where BLXZ00='4B' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4001' where BLXZ00='43' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4002' where BLXZ00='49' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4003' where BLXZ00='48' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4004' where BLXZ00='3B' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4005' where BLXZ00='4D' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4006' where BLXZ00='4A' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4007' where BLXZ00='46' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4010' where BLXZ00='41' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4011' where BLXZ00='42' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='4013' where BLXZ00='3J' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='5004' where BLXZ00='34' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='5008' where BLXZ00='44' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='5009' where BLXZ00='4E' and FLID00 is null;
update ZS_BLZCXM set FLID00=4, PLXH00='' where BLXZ00='4F' and FLID00 is null;
update ZS_BLZCXM set FLID00=5, PLXH00='' where BLXZ00='3M' and FLID00 is null;
update ZS_BLZCXM set FLID00=5, PLXH00='' where BLXZ00='3Q' and FLID00 is null;
commit;