delete from hr_code where PARENT_NO='PRESENT_POSITION'; insert into hr_code (CODE_NO,CODE_NAME,CODE_ORDER,PARENT_NO)values ('010201','助教','010201','PRESENT_POSITION'), ('010401','讲师(高等学校)','010401','PRESENT_POSITION'), ('010501','副教授','010501','PRESENT_POSITION'), ('010601','教授','010601','PRESENT_POSITION'), ('020101','教员(中等专业学校)','020101','PRESENT_POSITION'), ('020101','教员(中等专业学校)','020101','PRESENT_POSITION'), ('020201','助理讲师','020201','PRESENT_POSITION'), ('020401','讲师(中等专业学校)','020401','PRESENT_POSITION'), ('020501','高级讲师(中等专业学校)','020501','PRESENT_POSITION'), ('030101','中学三级教师','030101','PRESENT_POSITION'), ('030201','中学二级教师','030201','PRESENT_POSITION'), ('030401','中学一级教师','030401','PRESENT_POSITION'), ('030501','中学高级教师','030501','PRESENT_POSITION'), ('040101','小学二级教师','040101','PRESENT_POSITION'), ('040102','幼儿园二级教师','040102','PRESENT_POSITION'), ('040201','小学一级教师','040201','PRESENT_POSITION'), ('040202','幼儿园一级教师','040202','PRESENT_POSITION'), ('040401','小学高级教师','040401','PRESENT_POSITION'), ('040402','幼儿园高级教师','040402','PRESENT_POSITION'), ('050101','实验员','050101','PRESENT_POSITION'), ('050201','助理实验师(中等专业学校)','050201','PRESENT_POSITION'), ('050401','实验师','050401','PRESENT_POSITION'), ('050501','高级实验师','050501','PRESENT_POSITION'), ('060101','教员(技工学校)','060101','PRESENT_POSITION'), ('060102','三级实习指导教师','060102','PRESENT_POSITION'), ('060201','助理讲师(技工学校)','060201','PRESENT_POSITION'), ('060202','二级实习指导教师','060202','PRESENT_POSITION'), ('060401','讲师(技工学校)','060401','PRESENT_POSITION'), ('060402','一级实习指导教师','060402','PRESENT_POSITION'), ('060501','高级讲师(技工学校)','060501','PRESENT_POSITION'), ('060502','高级实习指导教师','060502','PRESENT_POSITION'), ('070101','技术员','070101','PRESENT_POSITION'), ('070201','助理工程师','070201','PRESENT_POSITION'), ('070401','工程师','070401','PRESENT_POSITION'), ('070501','高级工程师','070501','PRESENT_POSITION'), ('070601','享受教授、研究员待遇高级工程师','070601','PRESENT_POSITION'), ('070602','教授级高级工程师','070602','PRESENT_POSITION'), ('080101','经济员','080101','PRESENT_POSITION'), ('080201','助理经济师','080201','PRESENT_POSITION'), ('080301','经济初级','080301','PRESENT_POSITION'), ('080401','经济师','080401','PRESENT_POSITION'), ('080402','经济中级','080402','PRESENT_POSITION'), ('080501','高级经济师','080501','PRESENT_POSITION'), ('090101','会计员','090101','PRESENT_POSITION'), ('090201','助理会计师','090201','PRESENT_POSITION'), ('090301','会计初级','090301','PRESENT_POSITION'), ('090401','会计师','090401','PRESENT_POSITION'), ('090402','会计中级','090402','PRESENT_POSITION'), ('090501','高级会计师','090501','PRESENT_POSITION'), ('100101','审计员','100101','PRESENT_POSITION'), ('100201','助理审计师','100201','PRESENT_POSITION'), ('100301','审计初级','100301','PRESENT_POSITION'), ('100401','审计师','100401','PRESENT_POSITION'), ('100402','审计中级','100402','PRESENT_POSITION'), ('100501','高级审计师','100501','PRESENT_POSITION'), ('110101','统计员','110101','PRESENT_POSITION'), ('110201','助理统计师','110201','PRESENT_POSITION'), ('110301','统计初级','110301','PRESENT_POSITION'), ('110401','统计师','110401','PRESENT_POSITION'), ('110402','统计中级','110402','PRESENT_POSITION'), ('110501','高级统计师','110501','PRESENT_POSITION'), ('120101','农业技术员','120101','PRESENT_POSITION'), ('120102','兽医技术员','120102','PRESENT_POSITION'), ('120103','畜牧技术员','120103','PRESENT_POSITION'), ('120201','助理农艺师','120201','PRESENT_POSITION'), ('120202','助理兽医师','120202','PRESENT_POSITION'), ('120203','助理畜牧师','120203','PRESENT_POSITION'), ('120401','农艺师','120401','PRESENT_POSITION'), ('120402','兽医师','120402','PRESENT_POSITION'), ('120403','畜牧师','120403','PRESENT_POSITION'), ('120501','高级农艺师','120501','PRESENT_POSITION'), ('120502','高级兽医师','120502','PRESENT_POSITION'), ('120503','高级畜牧师','120503','PRESENT_POSITION'), ('130101','医士','130101','PRESENT_POSITION'), ('130102','药士','130102','PRESENT_POSITION'), ('130103','护士','130103','PRESENT_POSITION'), ('130104','技士','130104','PRESENT_POSITION'), ('130105','中药士','130105','PRESENT_POSITION'), ('130201','医师','130201','PRESENT_POSITION'), ('130202','药师','130202','PRESENT_POSITION'), ('130203','护师','130203','PRESENT_POSITION'), ('130204','技师','130204','PRESENT_POSITION'), ('130205','中药师','130205','PRESENT_POSITION'), ('130301','卫生初级','130301','PRESENT_POSITION'), ('130401','主治医师主管医师','130401','PRESENT_POSITION'), ('130402','主管药师','130402','PRESENT_POSITION'), ('130403','主管护师','130403','PRESENT_POSITION'), ('130404','主管技师','130404','PRESENT_POSITION'), ('130405','主治中医师','130405','PRESENT_POSITION'), ('130406','主管中药师','130406','PRESENT_POSITION'), ('130407','主管营养师','130407','PRESENT_POSITION'), ('130501','副主任医师','130501','PRESENT_POSITION'), ('130502','副主任药师','130502','PRESENT_POSITION'), ('130503','副主任护师','130503','PRESENT_POSITION'), ('130504','副主任技师','130504','PRESENT_POSITION'), ('130505','副主任中医师','130505','PRESENT_POSITION'), ('130506','副主任中药师','130506','PRESENT_POSITION'), ('130601','主任医师','130601','PRESENT_POSITION'), ('130602','主任药师','130602','PRESENT_POSITION'), ('130603','主任护师','130603','PRESENT_POSITION'), ('130604','主任技师','130604','PRESENT_POSITION'), ('130605','主任中医师','130605','PRESENT_POSITION'), ('130606','主任中药师','130606','PRESENT_POSITION'), ('140201','助理记者','140201','PRESENT_POSITION'), ('140202','助理编辑(新闻专业)','140202','PRESENT_POSITION'), ('140401','记者','140401','PRESENT_POSITION'), ('140402','编辑(新闻专业)','140402','PRESENT_POSITION'), ('140501','主任记者','140501','PRESENT_POSITION'), ('140502','主任编辑','140502','PRESENT_POSITION'), ('140601','高级记者','140601','PRESENT_POSITION'), ('140602','高级编辑','140602','PRESENT_POSITION'), ('150201','助理翻译','150201','PRESENT_POSITION'), ('150401','翻译','150401','PRESENT_POSITION'), ('150501','副译审','150501','PRESENT_POSITION'), ('150601','译审','150601','PRESENT_POSITION'), ('160101','三级播音员','160101','PRESENT_POSITION'), ('160201','二级播音员','160201','PRESENT_POSITION'), ('160401','一级播音员','160401','PRESENT_POSITION'), ('160501','主任播音员','160501','PRESENT_POSITION'), ('160601','播音指导','160601','PRESENT_POSITION'), ('170102','技术设计员','170102','PRESENT_POSITION'), ('170103','三级校对','170103','PRESENT_POSITION'), ('170201','助理编辑(出版专业)','170201','PRESENT_POSITION'), ('170202','助理技术编辑','170202','PRESENT_POSITION'), ('170203','二级校对','170203','PRESENT_POSITION'), ('170301','出版初级','170301','PRESENT_POSITION'), ('170401','出版中级','170401','PRESENT_POSITION'), ('170402','编辑(出版专业)','170402','PRESENT_POSITION'), ('170403','技术编辑','170403','PRESENT_POSITION'), ('170404','一级校对','170404','PRESENT_POSITION'), ('170501','副编审','170501','PRESENT_POSITION'), ('170601','编审','170601','PRESENT_POSITION'), ('180101','工艺美术员','180101','PRESENT_POSITION'), ('180201','助理工艺美术师','180201','PRESENT_POSITION'), ('180401','工艺美术师','180401','PRESENT_POSITION'), ('180501','高级工艺美术师','180501','PRESENT_POSITION'), ('190101','律师助理','190101','PRESENT_POSITION'), ('190201','四级律师','190201','PRESENT_POSITION'), ('190401','三级律师','190401','PRESENT_POSITION'), ('190501','二级律师','190501','PRESENT_POSITION'), ('190601','一级律师','190601','PRESENT_POSITION'), ('200101','公证员助理','200101','PRESENT_POSITION'), ('200201','四级公证员','200201','PRESENT_POSITION'), ('200401','三级公证员','200401','PRESENT_POSITION'), ('200501','二级公证员','200501','PRESENT_POSITION'), ('200601','一级公证员','200601','PRESENT_POSITION'), ('210101','管理员(图书资料专业)','210101','PRESENT_POSITION'), ('210201','助理馆员(图书资料专业)','210201','PRESENT_POSITION'), ('210401','馆员(图书资料专业)','210401','PRESENT_POSITION'), ('210501','副研究馆员(图书资料专业)','210501','PRESENT_POSITION'), ('210601','研究馆员(图书资料专业)','210601','PRESENT_POSITION'), ('220101','管理员(档案专业)','220101','PRESENT_POSITION'), ('220201','助理馆员(档案专业)','220201','PRESENT_POSITION'), ('220301','档案初级','220301','PRESENT_POSITION'), ('220401','馆员(档案专业)','220401','PRESENT_POSITION'), ('220402','档案中级','220402','PRESENT_POSITION'), ('220501','副研究馆员(档案专业)','220501','PRESENT_POSITION'), ('220601','研究馆员(档案专业)','220601','PRESENT_POSITION'), ('230101','电影放映技术员','230101','PRESENT_POSITION'), ('230401','电影放映技师','230401','PRESENT_POSITION'), ('230501','电影放映主任技师','230501','PRESENT_POSITION'), ('240101','政工员','240101','PRESENT_POSITION'), ('240201','助理政工师','240201','PRESENT_POSITION'), ('240401','政工师','240401','PRESENT_POSITION'), ('240501','高级政工师','240501','PRESENT_POSITION'), ('250101','管理员(群文专业)','250101','PRESENT_POSITION'), ('250201','助理馆员(群文专业)','250201','PRESENT_POSITION'), ('250401','馆员(群文专业)','250401','PRESENT_POSITION'), ('250501','副研究馆员(群文专业)','250501','PRESENT_POSITION'), ('250601','研究馆员(群文专业)','250601','PRESENT_POSITION'), ('260201','助理法律顾问','260201','PRESENT_POSITION'), ('260401','三级法律顾问','260401','PRESENT_POSITION'), ('260501','二级法律顾问','260501','PRESENT_POSITION'), ('260601','一级法律顾问','260601','PRESENT_POSITION')