国产在线a,av在线不卡一区,成人91av

医盟网-全国首家医疗信息化行业门户网站

獲得積分

資料庫會員登錄

搜索: [高級搜索]

下載首頁 | 資源分類 | 下載排行

您的位置: 首頁 > 標準文檔 > ICD

分類導航

下載排行

最新資源

ICD10Ver2_SQL

資源大小：189.34 KB	資源類型：文檔
下載積分： 0

-->

下載統計：總下載：0，本月下載：0，本周下載：0，今日下載：0

發表評論

錯誤報告

加入收藏夾

資源介紹

--注意事項：運行腳本前，請確定醫院是否有自行增加的新編碼，如果自行增加的新編碼與最新標準沖突，本腳本會按新標準執行。自行增加的編碼將被清除。

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,'阿哥拉沙門菌腸炎');

下載地址

下載地址1

按字母檢索

下載須知:
大部份資源無需注冊即可下載
需要積分的資源要在會員中心注冊會員并用積分體系中提示的方法賺取積分才能下載。

免責聲明：
所有資源只能用于參考學習，不能用于任何商業用途，否則后果自負！