--动态权限场景订阅事件
DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE FID = 1895708555839822848;
INSERT INTO T_HRCS_MSGSUBSCRIBER(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGPUBLISHERID,FMSGSUBNO,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('0','1','动态权限订阅',0,1335553746759046144,'MP20220117000056_dynaperm',{ts'2024-02-29  00:00:00'},'1','0PEIU203SX4Y',108010,'consumerDyPerm',0,1895708555839822848,0,NULL,' ',{ts'2024-02-29  00:00:00'},'0','C','MP20220117000056_dynaperm','确认入职',0,101010,'IHRCSMsgConsumerService',1,{ts'2024-02-29  00:00:00'},'15NPDX/GJFOO',101010,1);
DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE FID = 1895710402407321600;
INSERT INTO T_HRCS_MSGSUBSCRIBER(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGPUBLISHERID,FMSGSUBNO,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('0','1','动态权限订阅',0,1389874574543335424,'MP20220402000103_dynaperm',{ts'2024-02-29  00:00:00'},'1','0PEIU203SX4Y',108010,'consumerDyPerm',0,1895710402407321600,0,NULL,' ',{ts'2024-02-29  00:00:00'},'0','C','MP20220402000103_dynaperm','公司内调动生效消息',0,101050,'IHRCSMsgConsumerService',1,{ts'2024-02-29  00:00:00'},'15NPDX/GJFOO',101050,1);
DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE FID = 1895710618959237120;
INSERT INTO T_HRCS_MSGSUBSCRIBER(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGPUBLISHERID,FMSGSUBNO,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('0','1','动态权限订阅',0,1389876269352529920,'MP20220402000104_dynaperm',{ts'2024-02-29  00:00:00'},'1','0PEIU203SX4Y',108010,'consumerDyPerm',0,1895710618959237120,0,NULL,' ',{ts'2024-03-15  00:00:00'},'0','C','MP20220402000104_dynaperm','跨公司调动生效消息',0,101060,'IHRCSMsgConsumerService',1,{ts'2024-03-15  00:00:00'},'15NPDX/GJFOO',101060,1);
DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE FID = 1895709574351048704;
INSERT INTO T_HRCS_MSGSUBSCRIBER(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FMSGPUBLISHERID,FMSGSUBNO,FCREATETIME,FENABLE,FCONSUMERCLOUD,FSUBSCRIBEBDID,FCONSUMERMETHOD,FDISABLERID,FID,FSUBERID,FDISABLEDATE,FSIMPLENAME,FSUBTIME,FISNONORIGINAL,FSTATUS,FNUMBER,FNAME,FINDEX,FACTIONID,FCONSUMERSERVICE,FMODIFIERID,FMODIFYTIME,FCONSUMERAPP,FACTIONTYPEID,FCREATORID) VALUES ('0','1','动态权限订阅',0,1417222299727207424,'MP20220510000693_dynaperm',{ts'2024-02-29  00:00:00'},'1','0PEIU203SX4Y',108010,'consumerDyPerm',0,1895709574351048704,0,NULL,' ',{ts'2024-03-06  00:00:00'},'0','C','MP20220510000693_dynaperm','兼职生效消息',0,101070,'IHRCSMsgConsumerService',1,{ts'2024-03-06  00:00:00'},'15NPDX/GJFOO',101070,1);

DELETE FROM t_hrcs_msgsubscriber_l WHERE FPKID = '3YV5+TVOI9GK';
INSERT INTO t_hrcs_msgsubscriber_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1895708555839822848,'3YV5+TVOI9GK','zh_CN',' ','动态权限订阅','确认入职');
DELETE FROM t_hrcs_msgsubscriber_l WHERE FPKID = '3YV5B9N3DGGG';
INSERT INTO t_hrcs_msgsubscriber_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1895710402407321600,'3YV5B9N3DGGG','zh_CN',' ','动态权限订阅','公司内调动生效消息');
DELETE FROM t_hrcs_msgsubscriber_l WHERE FPKID = '3YV5CV69CRCY';
INSERT INTO t_hrcs_msgsubscriber_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1895710618959237120,'3YV5CV69CRCY','zh_CN',' ','动态权限订阅','跨公司调动生效消息');
DELETE FROM t_hrcs_msgsubscriber_l WHERE FPKID = '3YV568ABNNYY';
INSERT INTO t_hrcs_msgsubscriber_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1895709574351048704,'3YV568ABNNYY','zh_CN',' ','动态权限订阅','兼职生效消息');

--动态权限场景
DELETE FROM t_hrcs_dynascene WHERE FID = 1877473869162440704;
INSERT INTO t_hrcs_dynascene(FID,FCANCEL,FISSYSPRESET,FALLOCATED,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FENTITYTYPEID,FNUMBER,FNAME,FINDEX,FMSGPUBLISHERID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1877473869162440704,'0','1','0',{ts'2024-02-23  00:00:00'},' ',' ',1877473869162440704,'C','hom_onbrdbillbase','10010','确认入职自动分权',0,1335553746759046144,{ts'2024-02-04  00:00:00'},'1',1,{ts'2024-03-18  00:00:00'},1,1);
DELETE FROM t_hrcs_dynascene WHERE FID = 1876249674969542656;
INSERT INTO t_hrcs_dynascene(FID,FCANCEL,FISSYSPRESET,FALLOCATED,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FENTITYTYPEID,FNUMBER,FNAME,FINDEX,FMSGPUBLISHERID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1876249674969542656,'0','1','0',{ts'2024-02-05  00:00:00'},' ',' ',1876249674969542656,'C','hdm_transferbasebill','10030','公司内调动自动授权',0,1389874574543335424,{ts'2024-02-02  00:00:00'},'1',1,{ts'2024-03-18  00:00:00'},1,1);
DELETE FROM t_hrcs_dynascene WHERE FID = 1876249901990440960;
INSERT INTO t_hrcs_dynascene(FID,FCANCEL,FISSYSPRESET,FALLOCATED,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FENTITYTYPEID,FNUMBER,FNAME,FINDEX,FMSGPUBLISHERID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1876249901990440960,'0','1','0',{ts'2024-02-05  00:00:00'},' ',' ',1876249901990440960,'C','hdm_transferbasebill','10040','跨公司调动自动授权',0,1389876269352529920,{ts'2024-02-02  00:00:00'},'1',1,{ts'2024-03-18  00:00:00'},1,1);
DELETE FROM t_hrcs_dynascene WHERE FID = 1878317805816797184;
INSERT INTO t_hrcs_dynascene(FID,FCANCEL,FISSYSPRESET,FALLOCATED,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FENTITYTYPEID,FNUMBER,FNAME,FINDEX,FMSGPUBLISHERID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1878317805816797184,'0','1','0',{ts'2024-02-05  00:00:00'},' ',' ',1878317805816797184,'C','hdm_parttimeapplybill','10050','兼职生效自动分权',0,1417222299727207424,{ts'2024-02-05  00:00:00'},'1',1,{ts'2024-03-18  00:00:00'},1,1);

DELETE FROM t_hrcs_dynascene_l WHERE FPKID = '3WLSXZWLA85R';
INSERT INTO t_hrcs_dynascene_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1877473869162440704,'3WLSXZWLA85R','zh_CN',' ',' ','确认入职自动分权');
DELETE FROM t_hrcs_dynascene_l WHERE FPKID = '3WFY6=429D6+';
INSERT INTO t_hrcs_dynascene_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1876249674969542656,'3WFY6=429D6+','zh_CN',' ',' ','公司内调动自动授权');
DELETE FROM t_hrcs_dynascene_l WHERE FPKID = '3WFY7YMX05QD';
INSERT INTO t_hrcs_dynascene_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1876249901990440960,'3WFY7YMX05QD','zh_CN',' ',' ','跨公司调动自动授权');
DELETE FROM t_hrcs_dynascene_l WHERE FPKID = '3WPULQ24NC=I';
INSERT INTO t_hrcs_dynascene_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1878317805816797184,'3WPULQ24NC=I','zh_CN',' ',' ','兼职生效自动分权');


