
--------能力等级方案
-- 管控策略
DELETE FROM t_bd_defaultctrlstrategy WHERE FID = 1944998201950069760;
INSERT INTO t_bd_defaultctrlstrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FUPGRADESTATUS,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1944998201950069760,34,'1','2',NULL,1944998201950069760,'A','XYRL3+A8Z+Z',' ','5','hbss_capacityrankscheme',{ts'2024-05-07  00:00:00'},'1','1',13466739,' ',{ts'2024-05-07  00:00:00'},13466739,'0',0);
--角色预置（无需预置TDRG_020 任职资格业务管理员）
--TDRG_000 人才业务管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XDLPYYVB8L';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','4730fc9f000000ac','42XDLPYYVB8L',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XDLPYYVB8M';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','/IN0GIK354+3','42XDLPYYVB8M',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XDLPYYVB8N';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513208000000ac','42XDLPYYVB8N',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XDLPYYVB8O';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513209000000ac','42XDLPYYVB8O',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityrankscheme',' ');
--TDRG_001 专委会管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ5';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','4730fc9f000000ac','46XJU1=RSZZ5',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ6';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','/IN0GIK354+3','46XJU1=RSZZ6',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ7';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513209000000ac','46XJU1=RSZZ7',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityrankscheme',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ8';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513208000000ac','46XJU1=RSZZ8',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityrankscheme',' ');

--------能力素质维度
-- 管控策略
DELETE FROM t_bd_defaultctrlstrategy WHERE FID = 1945036636370781184;
INSERT INTO t_bd_defaultctrlstrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FUPGRADESTATUS,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1945036636370781184,34,'1','2',NULL,1945036636370781184,'A','XYRL3+A8Z+Z',' ','5','hbss_capacitygroup',{ts'2024-05-07  00:00:00'},'1','1',13466739,' ',{ts'2024-05-07  00:00:00'},13466739,'0',0);
--角色预置（无需预置TDRG_020 任职资格业务管理员）
--TDRG_000 人才业务管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XI6ISD=I/O';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','/IN0GIK354+3','42XI6ISD=I/O',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XI6ISD=I/P';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','4730fc9f000000ac','42XI6ISD=I/P',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XI6ISD=I/Q';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513208000000ac','42XI6ISD=I/Q',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '42XI6ISD=I/R';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513209000000ac','42XI6ISD=I/R',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacitygroup',' ');
--TDRG_001 专委会管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJDEAP79VP';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','/IN0GIK354+3','46XJDEAP79VP',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJDEAP79VQ';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','4730fc9f000000ac','46XJDEAP79VQ',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJDEAP79VR';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513208000000ac','46XJDEAP79VR',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacitygroup',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJDEAP79VS';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513209000000ac','46XJDEAP79VS',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacitygroup',' ');


--------能力素质项
-- 管控策略
DELETE FROM t_bd_defaultctrlstrategy WHERE FID = 1945620186849625088;
INSERT INTO t_bd_defaultctrlstrategy(FID,FCTRLVIEW,FDEFAULTMANAGESTRATEGY,FDATATYPE,FDISABLEDATE,FMASTERID,FSTATUS,FAPPSYSTEMID,FNUMBER,FDEFAULTCTRLSTRATEGY,FBASEDATAID,FCREATETIME,FUPGRADESTATUS,FENABLE,FMODIFIERID,FPLUGIN,FMODIFYTIME,FCREATORID,FISSYSTEM,FDISABLERID) VALUES (1945620186849625088,34,'1','2',NULL,1945620186849625088,'A','XYRL3+A8Z+Z',' ','5','hbss_capacityitem',{ts'2024-05-08  00:00:00'},'1','1',13466739,' ',{ts'2024-05-08  00:00:00'},13466739,'0',0);

--角色预置（无需预置TDRG_020 任职资格业务管理员）
--TDRG_000 人才业务管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '43+PWKWNRGR1';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513209000000ac','43+PWKWNRGR1',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '43+PWKWNRGR2';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','80513208000000ac','43+PWKWNRGR2',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '43+PWKWNRGR3';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','/IN0GIK354+3','43+PWKWNRGR3',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '43+PWKWNRGR4';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==PHU0=2VBN','4730fc9f000000ac','43+PWKWNRGR4',' ','23I=0+6+0DLX',0,'3==PHT3/YY7N','hbss_capacityitem',' ');
--TDRG_001 专委会管理员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ9';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','4730fc9f000000ac','46XJU1=RSZZ9',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZ=';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','/IN0GIK354+3','46XJU1=RSZZ=',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZA';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513209000000ac','46XJU1=RSZZA',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityitem',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '46XJU1=RSZZB';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('3==SERCPKR1+','80513208000000ac','46XJU1=RSZZB',' ','23I=0+6+0DLX',0,'3==SER7V4KXO','hbss_capacityitem',' ');







