--注意事项：运行脚本前，请确定医院是否有自行增加的新编码，如果自行增加的新编码与最新标准冲突，本脚本会按新标准执行。自行增加的编码将被清除。
drop table xt_icd100;
create synonym xt_icd100 for xt_icd900;
create table xt_icd100_ver1 as select * from xt_icd100;
alter table xt_icd900 modify JBMC00 varchar2(100);
create table icd_temp (icd100 varchar2(40),fzm000 varchar2(40),jbmc00 varchar2(200));
create unique index idx_temp on icd_temp(icd100);
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.001',NULL,'古典生物型霍乱');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.101',NULL,'埃尔托生物型霍乱');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.901',NULL,'霍乱');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.902',NULL,'霍乱轻型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.903',NULL,'霍乱中型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.904',NULL,'霍乱重型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A00.905',NULL,'霍乱暴发型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.001',NULL,'伤寒');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.002',NULL,'伤寒杆菌败血症');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.003+','G01*','伤寒并发脑膜炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.004',NULL,'伤寒复发');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.005+','J17.0*','伤寒并发肺炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.006',NULL,'伤寒迁延型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.007',NULL,'伤寒逍遥型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.008',NULL,'伤寒并发腹膜炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.009',NULL,'伤寒并发肠穿孔');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.010',NULL,'伤寒并发肠出血');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.011',NULL,'伤寒并发中毒性肝炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.012',NULL,'伤寒并发支气管炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.014',NULL,'伤寒并发胆囊炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.016+','I41.0*','伤寒并发中毒性心肌炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.017',NULL,'伤寒轻型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.018',NULL,'伤寒普通型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.019',NULL,'伤寒暴发型');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.020',NULL,'伤寒再燃');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.101',NULL,'副伤寒甲');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.201',NULL,'副伤寒乙');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.301',NULL,'副伤寒丙');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.401',NULL,'副伤寒');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.001',NULL,'沙门菌肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.002',NULL,'沙门菌胃肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.003',NULL,'沙门菌伦敦血清型肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.004',NULL,'鼠伤寒沙门菌肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.005',NULL,'婴儿沙门菌肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.006',NULL,'C群沙门菌肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.007',NULL,'B群沙门菌肠炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A02.008',NULL,'阿哥拉沙门菌肠炎'); |
|
资源大小：189.34 KB 
