 /** 订阅人事业务消息（外派业务_外派终止），进行权限档案同步 **/
 DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE fid=1478142428572667904;
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MJMJKU66GHE'; 
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MJMJKU66GHF';  
 /** 
 INSERT INTO T_HRCS_MSGSUBSCRIBER(fid,fnumber,fname,fstatus,fcreatorid,fmodifierid,fenable,fcreatetime,fmodifytime,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fsimplename,fdescription,fsubscribebdid,fsuberid,fmsgpublisherid,factiontypeid,fmsgsubno,fsubstatus,fsubtime,fconsumerservice,fconsumermethod,fconsumercloud,fconsumerapp,factionid)
 VALUES(1478142428572667904,'MS20220802000399','外派业务_外派终止','C',1,1,'1',{ts'2022-08-02 10:44:30'},{ts'2022-08-02 10:45:08'},1478142428572667904,0,null,0,'1',' ','同步权限档案',108010,1285511430891740160,1427691021474489344,101140,'MS20220802000399','1',{ts'2022-08-02 10:44:30'},'IHRCSMsgConsumerService','consumerSaveMsg','0PEIU203SX4Y','15NPDX/GJFOO',101140);
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MJMJKU66GHE',1478142428572667904,'zh_TW','外派業務_外派終止',' ','同步權限檔案');
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MJMJKU66GHF',1478142428572667904,'zh_CN','外派业务_外派终止',' ','同步权限档案');
  */
 
 /** 订阅人事业务消息（离职生效消息），进行权限档案同步 **/
 DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE fid=1477679103061643264;   
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MHE+B9EB/RA';
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MHE+B9EB/RB'; 
  /** 
 INSERT INTO T_HRCS_MSGSUBSCRIBER(fid,fnumber,fname,fstatus,fcreatorid,fmodifierid,fenable,fcreatetime,fmodifytime,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fsimplename,fdescription,fsubscribebdid,fsuberid,fmsgpublisherid,factiontypeid,fmsgsubno,fsubstatus,fsubtime,fconsumerservice,fconsumermethod,fconsumercloud,fconsumerapp,factionid)
 VALUES(1477679103061643264,'MS20220801000396','离职生效消息','C',1,1,'1',{ts'2022-08-01 19:24:09'},{ts'2022-08-01 19:24:36'},1477679103061643264,0,null,0,'1',' ','同步权限档案',108010,1285511430891740160,1335337092829417472,101020,'MS20220801000396','1',{ts'2022-08-01 19:24:09'},'IHRCSMsgConsumerService','consumerSaveMsg','0PEIU203SX4Y','15NPDX/GJFOO',101020);
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MHE+B9EB/RA',1477679103061643264,'zh_TW','離職生效消息',' ','同步權限檔案');
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MHE+B9EB/RB',1477679103061643264,'zh_CN','离职生效消息',' ','同步权限档案');
   */

 /** 订阅人事业务消息（兼职终止消息），进行权限档案同步 **/
 DELETE FROM T_HRCS_MSGSUBSCRIBER WHERE fid=1477630285280587776; 
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MH5VLMOFDF=';  
 DELETE FROM T_HRCS_MSGSUBSCRIBER_L WHERE FPKID='2MH5VLMOFDFA'; 
 /**
 INSERT INTO T_HRCS_MSGSUBSCRIBER(fid,fnumber,fname,fstatus,fcreatorid,fmodifierid,fenable,fcreatetime,fmodifytime,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fsimplename,fdescription,fsubscribebdid,fsuberid,fmsgpublisherid,factiontypeid,fmsgsubno,fsubstatus,fsubtime,fconsumerservice,fconsumermethod,fconsumercloud,fconsumerapp,factionid)
 VALUES(1477630285280587776,'MS20220801000393','兼职终止消息','C',1,1,'1',{ts'2022-08-01 17:47:14'},{ts'2022-08-01 17:47:36'},1477630285280587776,0,null,0,'1',' ','同步权限档案',108010,1285511430891740160,1417377024145774592,101100,'MS20220801000393','1',{ts'2022-08-01 17:47:14'},'IHRCSMsgConsumerService','consumerSaveMsg','0PEIU203SX4Y','15NPDX/GJFOO',101100);
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MH5VLMOFDF=',1477630285280587776,'zh_TW','兼職終止消息',' ','同步權限檔案');
 INSERT INTO T_HRCS_MSGSUBSCRIBER_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2MH5VLMOFDFA',1477630285280587776,'zh_CN','兼职终止消息',' ','同步权限档案');
  */