--注意事項:運行腳本前,請確定醫(yī)院是否有自行增加的新編碼,如果自行增加的新編碼與最新標準沖突,本腳本會按新標準執(zhí)行。自行增加的編碼將被清除。
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,'霍亂暴發(fā)型');
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*','傷寒并發(fā)腦膜炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.004',NULL,'傷寒復發(fā)');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.005+','J17.0*','傷寒并發(fā)肺炎');
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,'傷寒并發(fā)腹膜炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.009',NULL,'傷寒并發(fā)腸穿孔');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.010',NULL,'傷寒并發(fā)腸出血');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.011',NULL,'傷寒并發(fā)中毒性肝炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.012',NULL,'傷寒并發(fā)支氣管炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.014',NULL,'傷寒并發(fā)膽囊炎');
insert into icd_temp (ICD100,FZM000,JBMC00)values ('A01.016+','I41.0*','傷寒并發(fā)中毒性心肌炎');
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,'傷寒暴發(fā)型');
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,'阿哥拉沙門菌腸炎'); |
|