--##2021.01.18 zhangyc by MZSF-20210118-003 alter table SD_HOSPITAL.BM_BMBM00 add ( KSYBKS varchar2(20) null --跨省医保科室编码=select VALUE0 from bm_ybsxzd where jkbm00=1 and sxbm00='akf001' ); comment on column SD_HOSPITAL.BM_BMBM00.KSYBKS is '跨省医保科室编码=select VALUE0 from bm_ybsxzd where jkbm00=1 and sxbm00=akf001'; --akf001 医保科室编码 insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0100','预防保健科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0200','全科医疗科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0300','内科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0301','内科_呼吸内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0302','内科_消化内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0303','内科_神经内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0304','内科_心血管内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0305','内科_血液内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0306','内科_肾病学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0307','内科_内分泌专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0308','内科_免疫学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0309','内科_变态反应专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0310','内科_老年病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0311','内科_内科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0400','外科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0401','外科_普通外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0402','外科_神经外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0403','外科_骨科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0404','外科_泌尿外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0405','外科_胸外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0406','外科_心脏大血管外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0407','外科_烧伤科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0408','外科_整形外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0409','外科_外科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0500','妇产科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0501','妇产科_妇科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0502','妇产科_产科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0503','妇产科_计划生育专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0504','妇产科_优生学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0505','妇产科_生殖健康与不孕症专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0506','妇产科_妇产科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0600','妇女保健科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0601','妇女保健科_青春期保健专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0602','妇女保健科_围产期保健专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0603','妇女保健科_更年期保健专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0604','妇女保健科_妇女心理卫生专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0605','妇女保健科_妇女营养专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0606','妇女保健科_妇女保健科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0700','儿科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0701','儿科_新生儿专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0702','儿科_小儿传染病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0703','儿科_小儿消化专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0704','儿科_小儿呼吸专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0705','儿科_小儿心脏病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0706','儿科_小儿肾病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0707','儿科_小儿血液病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0708','儿科_小儿神经病学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0709','儿科_小儿内分泌专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0710','儿科_小儿遗传病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0711','儿科_小儿免疫专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0712','儿科_儿科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0800','小儿外科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0801','小儿外科_小儿普通外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0802','小儿外科_小儿骨科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0803','小儿外科_小儿泌尿外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0804','小儿外科_小儿胸心外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0805','小儿外科_小儿神经外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0806','小儿外科_小儿外科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0900','儿童保健科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0901','儿童保健科_儿童生长发育专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0902','儿童保健科_儿童营养专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0903','儿童保健科_儿童心理卫生专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0904','儿童保健科_儿童五官保健专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0905','儿童保健科_儿童康复专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','0906','儿童保健科_儿童保健科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1000','眼科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1100','眼科_耳鼻咽喉科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1101','眼科_耳科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1102','眼科_鼻科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1103','咽喉科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1104','其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1200','口腔科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1201','口腔科_口腔内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1202','口腔科_口腔颌面外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1203','口腔科_正畸专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1204','口腔科_口腔修复专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1205','口腔科_口腔预防保健专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1206','口腔科_口腔科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1300','皮肤科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1301','皮肤科_皮肤病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1302','皮肤科_性传播疾病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1303','皮肤科_皮肤科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1400','医疗美容科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1500','精神科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1501','精神科_精神病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1502','精神科_精神卫生专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1503','精神科_药物依赖专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1504','精神科_精神康复专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1505','精神科_社区防治专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1506','精神科_临床心理专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1507','精神科_司法精神专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1508','精神科_精神科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1600','传染科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1601','传染科_肠道传染病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1602','传染科_呼吸道传染病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1603','传染科_肝炎专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1604','传染科_虫媒传染病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1605','传染科_动物源性传染病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1606','传染科_蠕虫病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1607','传染科_传染科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1700','结核病科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1800','地方病科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','1900','肿瘤科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2000','急诊医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2100','康复医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2200','运动医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2300','职业病科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2301','职业病科_职业中毒专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2302','职业病科_尘肺专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2303','职业病科_放射病专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2304','职业病科_物理因素损伤专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2305','职业健康监护专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2306','眼科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2400','临终关怀科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2500','特种医学与军事医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2600','麻醉科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2700','疼痛科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','2800','重症医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3000','医学检验科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3001','医学检验科_临床体液、血液专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3002','医学检验科_临床微生物学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3003','医学检验科_临床化学检验专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3004','医学检验科_临床免疫、血清学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3005','医学检验科_临床细胞分子遗传学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3006','医学检验科_医学检验科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3100','病理科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3200','医学影像科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3201','医学影像科_X线诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3202','医学影像科_CT诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3203','医学影像科_磁共振成像诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3204','医学影像科_核医学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3205','医学影像科_超声诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3206','医学影像科_心电诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3207','医学影像科_脑电及脑血流图诊断专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3208','医学影像科_神经肌肉电图专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3209','医学影像科_介入放射学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3210','医学影像科_放射治疗专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','3211','医学影像科_医学影像科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5000','中医科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5001','中医科_内科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5002','中医科_外科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5003','中医科_妇产科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5004','中医科_儿科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5005','中医科_皮肤科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5006','中医科_眼科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5007','中医科_耳鼻咽喉科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5008','中医科_口腔科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5009','中医科_肿瘤科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5010','中医科_骨伤科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5011','中医科_肛肠科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5012','中医科_老年病科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5013','中医科_针灸科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5014','中医科_推拿科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5015','中医科_康复医学专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5016','中医科_急诊科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5017','中医科_预防保健科专业'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5018','中医科_中医科其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5100','民族医学科'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5101','民族医学科_维吾尔医学'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5102','民族医学科_藏医学'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5103','民族医学科_蒙医学'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5104','民族医学科_彝医学'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5105','民族医学科_傣医学'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5106','民族医学科_其他'); insert into BM_YBSXZD(NBID00,JKBM00,JKMC00,SXBM00,SXMC00,VALUE0,SXSM00) values(SQ_BM_YBJKZD_NBID00.nextval,1,'医保新接口','akf001','科室','5200','中西医结合科'); commit;