-- 薪资数据集成，协作活动预置数据
DELETE FROM t_hpdi_payrollact WHERE FID = 1010;
INSERT INTO t_hpdi_payrollact(FID,FALIAS,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'同步计薪人员','1',NULL,' ',' ',1010,'C','1010_S','同步计薪人员',0,{ts'2020-04-28  00:00:00'},1150721201652407296,'1',{ts'2021-11-19  00:00:00'},1,0); 
DELETE FROM t_hpdi_payrollact WHERE FID = 1194240056647333888;
INSERT INTO t_hpdi_payrollact(FID,FALIAS,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1194240056647333888,'新增/变更人员薪资档案','1',NULL,' ',' ',1194240056647333888,'C','1020_S','新增/变更人员薪资档案',0,{ts'2021-07-06  00:00:00'},1158705950345960448,'1',{ts'2021-07-06  00:00:00'},1158705950345960448,0); 

DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '0R01+FBRN7OY';
INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'同步计薪人员','0R01+FBRN7OY','zh_CN',' ',' ','同步计薪人员'); 
DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '0R01+FBRN7OZ';
--INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'同步計薪人員','0R01+FBRN7OZ','zh_TW',' ',' ','同步計薪人員'); 
DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '1QOGLV=9CLY/';
INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1194240056647333888,'新增/变更人员薪资档案','1QOGLV=9CLY/','zh_CN',' ',' ','新增/变更人员薪资档案'); 
DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '1QOGLV=9CLY0';
--INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1194240056647333888,'新增/變更人員薪資檔案','1QOGLV=9CLY0','zh_TW',' ',' ','新增/變更人員薪資檔案'); 


DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 1194240056655722496;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1194240056647333888,1194240056655722496,1,1194234308747966464,0); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275588;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275588,5,1292124049001948160,5); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275589;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275589,6,1292128598387347456,6); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275590;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275590,4,1292133831201017856,7); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275591;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275591,8,1292135024480494592,8); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275592;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275592,9,1292135942127112192,9); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275593;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275593,10,1292136719952389120,10); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275594;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275594,11,1292730922109672448,11); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275595;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275595,12,1292132256877388800,12); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275596;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275596,13,1292118425757295616,13); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275584;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275584,1,1292039619482756096,1); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275585;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275585,2,1292046837275960320,2); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275586;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275586,3,1292051430793815040,3); 
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275587;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275587,4,1292114768475202560,4); 
-- 2022-4-7 增加教育经历
DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 879597434622275597;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1010,879597434622275597,14,1393377542790120448,14); 

