-- 2023-4-25 产品 圳彬 人员协作生成人员变动记录

--协作操作 	增加“生成人员变动记录”的预置数据
DELETE FROM t_hpdi_triggercolla WHERE FID = 1641328241870428160;
INSERT INTO t_hpdi_triggercolla(FID,FALIAS,FENTITYOBJECTID,FISSYSPRESET,FOPERATIONTYPEID,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FOPERATIONCLSID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1641328241870428160,'生成人员变动记录','hsas_personchange','1',1359308383789802448,NULL,' ',' ',1641328241870428160,1010,'C','1170_S','生成人员变动记录',0,{ts'2023-03-15  00:00:00'},1632628417327399936,'1','/UHMBBGZQ65X',{ts'2023-06-28  00:00:00'},13466739,0);

DELETE FROM t_hpdi_triggercolla_l WHERE FPKID = '34LF3TWPW47S';
INSERT INTO t_hpdi_triggercolla_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1641328241870428160,'生成人员变动记录','34LF3TWPW47S','zh_CN',' ',' ','生成人员变动记录');



--协作活动 	增加“生成人员变动记录”的预置数据
DELETE FROM t_hpdi_payrollact WHERE FID = 1641347587896301568;
INSERT INTO t_hpdi_payrollact(FID,FALIAS,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FBIZAPPID,FPREPAYROLLACTID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1641347587896301568,'生成人员变动记录','1',NULL,' ',' ',1641347587896301568,'C','1050_S','生成人员变动记录',0,{ts'2023-03-15  00:00:00'},1632628417327399936,'1','/UHMBBGZQ65X',1010,{ts'2023-06-28  00:00:00'},13466739,0);

DELETE FROM t_hpdi_payrollact_l WHERE FPKID = '34LIQSW468S8';
INSERT INTO t_hpdi_payrollact_l(FID,FALIAS,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1641347587896301568,'生成人员变动记录','34LIQSW468S8','zh_CN',' ',' ','生成人员变动记录');

DELETE FROM t_hpdi_payrollactent WHERE FENTRYID = 1641347587938244608;
INSERT INTO t_hpdi_payrollactent(FID,FENTRYID,FSEQ,FTRIGGERCOLLAID,FEXECUTESEQ) VALUES (1641347587896301568,1641347587938244608,1,1641328241870428160,0);

--薪资协作模板 	在预置数据“薪资协作模板”中增加“生成人员变动记录”
DELETE FROM t_hpdi_payrollactgtplent WHERE FENTRYID = 1641351804513998848;
INSERT INTO t_hpdi_payrollactgtplent(FID,FISMUSTEXECUTE,FENTRYID,FSEQ,FEXECUTESEQ,FPAYROLLACTID) VALUES (1010,'0',1641351804513998848,3,3,1641347587896301568);

