slaj/deliverables/08_dict_att_org.sql

-- ============================================================
-- 字典导入：机构 / 参建单位 / 分包单位 / 项目 / 人员 相关字典
-- 来源：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);