--调动终止原因 修改预置数据id
delete from t_hdm_transfertermreason where fid in (1294783281157550080,1294783435340165120,1294783614302726144,1294783738294740992,1294784182580586496,1294784369503940608,1475384550682171392);
delete from t_hdm_transfertermreason_l where fid in (1294783281157550080,1294783435340165120,1294783614302726144,1294783738294740992,1294784182580586496,1294784369503940608,1475384550682171392);

DELETE FROM t_hdm_transfertermreason WHERE FID = 1010;
INSERT INTO t_hdm_transfertermreason(FID,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'2021-11-22  00:00:00'},1,'1',{ts'2021-11-22  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1020;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020,'1',NULL,' ','预置数据',1020,'C','1020_S','部门要求',0,{ts'2021-11-22  00:00:00'},1,'1',{ts'2021-11-22  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1030;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030,'1',NULL,' ','预置数据',1030,'C','1030_S','员工主动要求终止',0,{ts'2021-11-22  00:00:00'},1,'1',{ts'2021-11-22  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1040;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040,'1',NULL,' ','预置数据',1040,'C','1040_S','合同到期',0,{ts'2021-11-22  00:00:00'},1,'1',{ts'2021-11-22  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1050;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1050,'1',NULL,' ','预置数据',1050,'C','1050_S','调动协作未完成',0,{ts'2021-11-22  00:00:00'},1,'1',{ts'2021-11-22  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1060;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1060,'1',NULL,' ','预置数据',1060,'C','1060_S','其他',0,{ts'2021-11-22  00:00:00'},1,'1',{ts'2022-08-09  00:00:00'},1,0);
DELETE FROM t_hdm_transfertermreason WHERE FID = 1070;
INSERT INTO t_hdm_transfertermreason(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1070,'1',NULL,' ','预置数据',1070,'C','1070_S','员工已离职',0,{ts'2022-07-29  00:00:00'},1,'1',{ts'2022-08-09  00:00:00'},1,0);

DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105OLWVVWSZ';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'2105OLWVVWSZ','zh_CN',' ','预置数据','操作失误');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105PQOMT74F';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'2105PQOMT74F','zh_CN',' ','预置数据','部门要求');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105R0J5J06G';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'2105R0J5J06G','zh_CN',' ','预置数据','员工主动要求终止');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105RYSEX0JG';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'2105RYSEX0JG','zh_CN',' ','预置数据','合同到期');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105V60OC15+';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1050,'2105V60OC15+','zh_CN',' ','预置数据','调动协作未完成');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2105WJ5F6UAN';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1060,'2105WJ5F6UAN','zh_CN',' ','预置数据','其他');
DELETE FROM t_hdm_transfertermreason_l WHERE FPKID = '2M7E9+1QD7GB';
INSERT INTO t_hdm_transfertermreason_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1070,'2M7E9+1QD7GB','zh_CN',' ','预置数据','员工已离职');

--修改终止原因预置数据id,需要对旧数据进行更新
update t_hdm_transferbill  set fterminationreasonid = 1010 where fterminationreasonid = 1294783281157550080;
update t_hdm_transferbill  set fterminationreasonid = 1020 where fterminationreasonid = 1294783435340165120;
update t_hdm_transferbill  set fterminationreasonid = 1030 where fterminationreasonid = 1294783614302726144;
update t_hdm_transferbill  set fterminationreasonid = 1040 where fterminationreasonid = 1294783738294740992;
update t_hdm_transferbill  set fterminationreasonid = 1050 where fterminationreasonid = 1294784182580586496;
update t_hdm_transferbill  set fterminationreasonid = 1060 where fterminationreasonid = 1294784369503940608;
update t_hdm_transferbill  set fterminationreasonid = 1070 where fterminationreasonid = 1475384550682171392;
