-- ============================================================ -- 字典导入:机构 / 参建单位 / 分包单位 / 项目 / 人员 相关字典 -- 来源:docs/项目基础信息表.docx -- 约定:dict_code / dict_id 由数据库自增生成;status='0' 正常; -- is_default='N';dict_sort 取代码值;create_by='admin' -- 字段与字典类型对照见每条 INSERT 注释 -- ============================================================ -- 1) 机构级别 (ATT_ORG_BASE.ORG_LEVEL / ATT_ORG_UWAT_BASE.ORG_LEVEL / 单位规格) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('机构级别', 'slaj_org_level', '0', 'admin', now(), '机构/参建单位级别'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '国家级正职', '01', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (2, '国家级副职', '02', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (3, '正部(省)级', '03', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (4, '副部(省)级', '04', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (5, '司、局、地、厅级', '05', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (6, '副司、副局、副地、副厅级', '06', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (7, '县、正处级', '07', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (8, '副县、副处级', '08', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (9, '科级', '09', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (10, '副科级', '10', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (11, '股级', '11', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (12, '副股级', '12', 'slaj_org_level', 'N', '0', 'admin', now(), NULL), (90, '其他级(含无级)', '90', 'slaj_org_level', 'N', '0', 'admin', now(), NULL); -- 2) 机构类型 (ATT_ORG_BASE.ORG_TYPE / ATT_ORG_UWAT_BASE.ORG_TYPE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('机构类型', 'slaj_org_type', '0', 'admin', now(), '机构/参建单位类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '单位', '1', 'slaj_org_type', 'N', '0', 'admin', now(), NULL), (2, '部门', '2', 'slaj_org_type', 'N', '0', 'admin', now(), NULL), (9, '其他', '9', 'slaj_org_type', 'N', '0', 'admin', now(), NULL); -- 3) 机构状态 (ATT_ORG_BASE.STATUS / ATT_ORG_UWAT_BASE.STATUS) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('机构状态', 'slaj_org_status', '0', 'admin', now(), '机构/参建单位状态'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '启用', '1', 'slaj_org_status', 'N', '0', 'admin', now(), NULL), (2, '停用', '2', 'slaj_org_status', 'N', '0', 'admin', now(), NULL), (9, '注销', '9', 'slaj_org_status', 'N', '0', 'admin', now(), NULL); -- 4) 区域类型 (ATT_ORG_BASE.AREA_TYPE / ATT_ORG_UWAT_BASE.AREA_TYPE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('区域类型', 'slaj_area_type', '0', 'admin', now(), '管辖范围分区类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '行政区划', '1', 'slaj_area_type', 'N', '0', 'admin', now(), NULL), (2, '水资源分区', '2', 'slaj_area_type', 'N', '0', 'admin', now(), NULL), (3, '流域分区', '3', 'slaj_area_type', 'N', '0', 'admin', now(), NULL), (4, '流域片区', '4', 'slaj_area_type', 'N', '0', 'admin', now(), NULL), (5, '单位', '5', 'slaj_area_type', 'N', '0', 'admin', now(), NULL), (9, '其他', '9', 'slaj_area_type', 'N', '0', 'admin', now(), NULL); -- 5) 单位类型(客户端) (ATT_ORG_EXT.ORG_CLIEN_TYPE / ATT_ORG_UWAT_EXT.ORG_CLIEN_TYPE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('单位类型(客户端)', 'slaj_org_clien_type', '0', 'admin', now(), '单位类型客户端'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '大中型已建工程运行管理单位', '1', 'slaj_org_clien_type', 'N', '0', 'admin', now(), NULL), (2, '大中型在建工程项目法人', '2', 'slaj_org_clien_type', 'N', '0', 'admin', now(), NULL), (3, '小型工程管理单位和技术服务单位', '3', 'slaj_org_clien_type', 'N', '0', 'admin', now(), NULL); -- 6) 水利机构单位类型 (ATT_ORG_EXT.ORG_TYPE 表2.5-122) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('水利机构单位类型', 'slaj_ext_org_type', '0', 'admin', now(), '水利机构扩展单位类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '工程管理单位', '1', 'slaj_ext_org_type', 'N', '0', 'admin', now(), NULL), (2, '项目法人', '2', 'slaj_ext_org_type', 'N', '0', 'admin', now(), NULL), (3, '施工单位', '3', 'slaj_ext_org_type', 'N', '0', 'admin', now(), NULL), (4, '其他', '4', 'slaj_ext_org_type', 'N', '0', 'admin', now(), NULL); -- 7) 参建单位类型 (ATT_ORG_UWAT_EXT.ORG_TYPE 表2.5-139) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('参建单位类型', 'slaj_uwat_org_type', '0', 'admin', now(), '参建单位类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '施工单位', '1', 'slaj_uwat_org_type', 'N', '0', 'admin', now(), NULL), (2, '监理单位', '2', 'slaj_uwat_org_type', 'N', '0', 'admin', now(), NULL); -- 8) 单位性质 (ATT_ORG_EXT.WIUN_PROP / ATT_ORG_UWAT_EXT.WIUN_PROP) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('单位性质', 'slaj_wiun_prop', '0', 'admin', now(), '单位性质'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '国有企业', '1', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (2, '国有控股企业', '2', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (3, '外资企业', '3', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (4, '合资企业', '4', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (5, '私营企业', '5', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (6, '事业单位', '6', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (7, '国家行政机关', '7', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL), (8, '政府', '8', 'slaj_wiun_prop', 'N', '0', 'admin', now(), NULL); -- 9) 是否水利系统 (ATT_ORG_EXT.IF_WATE_ENTE / ATT_ORG_UWAT_EXT.IF_WATE_ENTE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('是否水利系统', 'slaj_if_wate_ente', '0', 'admin', now(), '是否水利系统'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '0', 'slaj_if_wate_ente', 'N', '0', 'admin', now(), NULL), (1, '是', '1', 'slaj_if_wate_ente', 'N', '0', 'admin', now(), NULL), (2, '否', '2', 'slaj_if_wate_ente', 'N', '0', 'admin', now(), NULL); -- 10) 是否项目法人单位 (ATT_ORG_EXT.IS_LEG_ENTI / ATT_ORG_UWAT_EXT.IS_LEG_ENTI) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('是否项目法人单位', 'slaj_is_leg_enti', '0', 'admin', now(), '是否项目法人单位'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '0', 'slaj_is_leg_enti', 'N', '0', 'admin', now(), NULL), (1, '是', '1', 'slaj_is_leg_enti', 'N', '0', 'admin', now(), NULL), (2, '否', '2', 'slaj_is_leg_enti', 'N', '0', 'admin', now(), NULL); -- 11) 是否部直属单位 (ATT_ORG_EXT.IF_MINI_DIRE / ATT_ORG_UWAT_EXT.IF_MINI_DIRE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('是否部直属单位', 'slaj_if_mini_dire', '0', 'admin', now(), '是否部直属单位'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (0, '未知', '0', 'slaj_if_mini_dire', 'N', '0', 'admin', now(), NULL), (1, '是', '1', 'slaj_if_mini_dire', 'N', '0', 'admin', now(), NULL), (2, '否', '2', 'slaj_if_mini_dire', 'N', '0', 'admin', now(), NULL); -- 12) 施工总承包资质 (ATT_ORG_EXT.CONTR_QUAL_GRAD / ATT_ORG_UWAT_EXT.CONTR_QUAL_GRAD / ATT_ORG_WSUB.CONTR_QUAL_GRAD) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('施工总承包资质', 'slaj_contr_qual_grad', '0', 'admin', now(), '施工总承包资质'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '一级', '1', 'slaj_contr_qual_grad', 'N', '0', 'admin', now(), NULL), (2, '二级', '2', 'slaj_contr_qual_grad', 'N', '0', 'admin', now(), NULL), (3, '三级', '3', 'slaj_contr_qual_grad', 'N', '0', 'admin', now(), NULL); -- 13) 监理资质等级 (ATT_ORG_EXT.SUP_QUAL_GRAD / ATT_ORG_UWAT_EXT.SUP_QUAL_GRAD) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('监理资质等级', 'slaj_sup_qual_grad', '0', 'admin', now(), '监理资质等级'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '甲级', '1', 'slaj_sup_qual_grad', 'N', '0', 'admin', now(), NULL), (2, '乙级', '2', 'slaj_sup_qual_grad', 'N', '0', 'admin', now(), NULL), (3, '丙级', '3', 'slaj_sup_qual_grad', 'N', '0', 'admin', now(), NULL); -- 14) 标准化等级 (ATT_ORG_EXT.STAN_GRAD / ATT_ORG_UWAT_EXT.STAN_GRAD) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('标准化等级', 'slaj_stan_grad', '0', 'admin', now(), '标准化等级'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '一级', '1', 'slaj_stan_grad', 'N', '0', 'admin', now(), NULL), (2, '二级', '2', 'slaj_stan_grad', 'N', '0', 'admin', now(), NULL), (3, '三级', '3', 'slaj_stan_grad', 'N', '0', 'admin', now(), NULL), (4, '无', '4', 'slaj_stan_grad', 'N', '0', 'admin', now(), NULL); -- 15) 经费来源 (ATT_ORG_EXT.FUND_SOUR / ATT_ORG_UWAT_EXT.FUND_SOUR) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('经费来源', 'slaj_fund_sour', '0', 'admin', now(), '经费来源'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '财政全额', '1', 'slaj_fund_sour', 'N', '0', 'admin', now(), NULL), (2, '财政差额', '2', 'slaj_fund_sour', 'N', '0', 'admin', now(), NULL), (3, '自筹自支', '3', 'slaj_fund_sour', 'N', '0', 'admin', now(), NULL), (4, '其他', '4', 'slaj_fund_sour', 'N', '0', 'admin', now(), NULL); -- 16) 项目部类型 (ATT_ORG_UWAT_EXT.PROJ_GROUP_TYPE 表2.5-149) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('项目部类型', 'slaj_proj_group_type', '0', 'admin', now(), '项目部类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '施工单位', '1', 'slaj_proj_group_type', 'N', '0', 'admin', now(), NULL), (2, '监理单位', '2', 'slaj_proj_group_type', 'N', '0', 'admin', now(), NULL); -- 17) 人员类型 (ATT_PERS_BASE.PERS_TYPE) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('人员类型', 'slaj_pers_type', '0', 'admin', now(), '人员类型'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '行政', '01', 'slaj_pers_type', 'N', '0', 'admin', now(), NULL), (2, '事业', '02', 'slaj_pers_type', 'N', '0', 'admin', now(), NULL), (3, '参公', '03', 'slaj_pers_type', 'N', '0', 'admin', now(), NULL), (4, '外聘', '04', 'slaj_pers_type', 'N', '0', 'admin', now(), NULL), (5, '其他', '05', 'slaj_pers_type', 'N', '0', 'admin', now(), NULL); -- 18) 性别 (ATT_PERS_BASE.SEX) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('性别', 'slaj_sex', '0', 'admin', now(), '性别'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (0, '未知的性别', '0', 'slaj_sex', 'N', '0', 'admin', now(), NULL), (1, '男', '1', 'slaj_sex', 'N', '0', 'admin', now(), NULL), (2, '女', '2', 'slaj_sex', 'N', '0', 'admin', now(), NULL), (9, '未说明', '9', 'slaj_sex', 'N', '0', 'admin', now(), NULL); -- 19) 民族 (ATT_PERS_BASE.NATION) INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('民族', 'slaj_nation', '0', 'admin', now(), '民族'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (1, '汉族', '01', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (2, '蒙古族', '02', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (3, '回族', '03', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (4, '藏族', '04', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (5, '维吾尔族', '05', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (6, '苗族', '06', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (7, '彝族', '07', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (8, '壮族', '08', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (9, '布依族', '09', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (10, '朝鲜族', '10', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (11, '满族', '11', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (12, '侗族', '12', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (13, '瑶族', '13', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (14, '白族', '14', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (15, '土家族', '15', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (16, '哈尼族', '16', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (17, '哈萨克族', '17', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (18, '傣族', '18', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (19, '黎族', '19', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (20, '傈僳族', '20', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (21, '佤族', '21', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (22, '畲族', '22', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (23, '高山族', '23', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (24, '拉祜族', '24', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (25, '水族', '25', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (26, '东乡族', '26', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (27, '纳西族', '27', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (28, '景颇族', '28', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (29, '柯尔克孜族', '29', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (30, '土族', '30', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (31, '达斡尔族', '31', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (32, '仫佬族', '32', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (33, '羌族', '33', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (34, '布朗族', '34', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (35, '撒拉族', '35', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (36, '毛南族', '36', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (37, '仡佬族', '37', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (38, '锡伯族', '38', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (39, '阿昌族', '39', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (40, '普米族', '40', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (41, '塔吉克族', '41', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (42, '怒族', '42', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (43, '乌孜别克族', '43', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (44, '俄罗斯族', '44', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (45, '鄂温克族', '45', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (46, '德昂族', '46', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (47, '保安族', '47', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (48, '裕固族', '48', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (49, '京族', '49', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (50, '塔塔尔族', '50', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (51, '独龙族', '51', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (52, '鄂伦春族', '52', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (53, '赫哲族', '53', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (54, '门巴族', '54', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (55, '珞巴族', '55', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (56, '基诺族', '56', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (97, '其他', '97', 'slaj_nation', 'N', '0', 'admin', now(), NULL), (98, '外国血统中国籍人士', '98', 'slaj_nation', 'N', '0', 'admin', now(), NULL); -- 20) 职务级别 (ATT_PERS_BASE.ADM_DUTY) 仅取叶子节点 INSERT INTO sys_dict_type (dict_name, dict_type, status, create_by, create_time, remark) VALUES ('职务级别', 'slaj_adm_duty', '0', 'admin', now(), '职务级别(叶子节点)'); INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, is_default, status, create_by, create_time, remark) VALUES (101, '国家级正职', '101', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (102, '国家级副职', '102', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (111, '省部级正职', '111', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (112, '省部级副职', '112', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (121, '厅局级正职', '121', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (122, '厅局级副职', '122', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (131, '县处级正职', '131', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (132, '县处级副职', '132', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (141, '乡科级正职', '141', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (142, '乡科级副职', '142', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (150, '科员级', '150', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (160, '办事员级', '160', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (199, '未定职公务员', '199', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (211, '一级职员', '211', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (212, '二级职员', '212', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (221, '三级职员', '221', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (222, '四级职员', '222', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (231, '五级职员', '231', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (232, '六级职员', '232', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (241, '七级职员', '241', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (242, '八级职员', '242', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (250, '九级职员', '250', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (260, '十级职员', '260', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (299, '未定级职员', '299', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (410, '高级', '410', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (411, '正高级', '411', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (412, '副高级', '412', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (420, '中级', '420', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (430, '初级', '430', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (434, '助理级', '434', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (435, '员级', '435', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL), (499, '未定职级专业技术人员', '499', 'slaj_adm_duty', 'N', '0', 'admin', now(), NULL);