-- Offer状态
-- 删除老数据
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030030;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030040;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040020;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010050;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010030;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010040;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020010;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020030;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020020;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020040;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040010;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040040;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040030;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030020;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010010;
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010020;
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4II15=38G';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4II15=38H';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4JWAW6H2G';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4JWAW6H2H';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4RC8DRZUT';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4RC8DRZUU';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5/VCPIFXJ';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5/VCPIFXK';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5392MN1I4';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5392MN1I5';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4V+XC/K1O';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4W2WEG=Q9';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244ME2S9YO4X';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244ME2S9YO4Y';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MGM/0NJGW';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MGM/0NJGX';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MHDEHEWD8';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MHDEHEWD9';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MICTVNL3Z';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244MICTVNL4+';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4OK39ZJIE';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4OK39ZJIF';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4L/YXBW9X';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4L/YXBW9Y';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4NG/YPQ/7';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4NG/YPQ/8';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4TQDQH/ZY';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4TQDQH/ZZ';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4V+XC/K1N';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4W2WEG=Q=';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4X7Q85RA0';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4X7Q85RA1';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5+MMZWKJU';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5+MMZWKJV';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '245FI5NE61KB';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '245FI5NE61KC';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1YB/G=YR9ARI';
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1YB/G=YR9ARJ';

DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040010;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040010,'1',NULL,'候选人在最晚回复Offer日期内还没有回复Offer',1040010,'C','待回复',1040,'1040010_S',6,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040030;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040030,'1',NULL,'候选人已经接受Offer Letter',1040030,'C','已接受',1040,'1040030_S',8,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-17  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010030;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010030,'1',NULL,'Offer申请不通过',1010030,'C','申请终止',1010,'1010030_S',0,{ts'2021-12-27  00:00:00'},1164453183364274176,'1',{ts'2022-01-10  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040040;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040040,'1',NULL,'候选人已经拒绝Offer Letter',1040040,'C','已拒绝',1040,'1040040_S',9,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-17  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010010;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010010,'1',NULL,'用人部门有意录用候选人，此时需要给候选人申请Offer',1010010,'C','待申请',1010,'1010010_S',1,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020020;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020020,'1',NULL,'在最晚发送日期前没有发送Offer Letter',1020020,'C','逾期未发送',1020,'1020020_S',5,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-01-10  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020030;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020030,'1',NULL,'Offer Letter已经发送给候选人',1020030,'C','已发送',1020,'1020030_S',5,{ts'2021-09-30  00:00:00'},1164453183364274176,'1',{ts'2022-01-10  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020010;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020010,'1',NULL,'Offer申请通过，可以把Offer Letter发送给候选人',1020010,'C','待发送',1020,'1020010_S',4,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-17  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010040;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010040,'1',NULL,'Offer申请通过',1010040,'C','申请通过',1010,'1010040_S',0,{ts'2022-02-22  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010050;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010050,'1',NULL,'因一些特殊原因Offer申请人主动废弃Offer',1010050,'C','已废弃',1010,'1010050_S',10,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020040;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020040,'1',NULL,'因一些特殊原因Offer申请人主动废弃Offer，同时关联废弃Offer Letter；或直接废弃Offer Letter',1020040,'C','已废弃',1020,'1020040_S',0,{ts'2021-12-27  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1020050;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020050,'1',NULL,'Offer Letter有效期变更还未审批通过',1020050,'C','待生成',1020,'1020050_S',0,{ts'2022-02-22  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030010;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030010,'1',NULL,'Offer申请通过，可以把待生效的Offer Letter发送给候选人',1030040,'C','待生效',1030,'1030010_S',0,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030020;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030020,'1',NULL,'Offer Letter成功发送给候选人后，立即生效',1030020,'C','已生效',1030,'1030020_S',0,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1010020;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010020,'1',NULL,'已提交Offer进行审批',1010020,'C','申请中',1010,'1010020_S',2,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2021-06-14  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1030030;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030030,'1',NULL,'因一些特殊原因Offer申请人主动废弃Offer和Offer Letter，或Offer Letter超过了时效性',1030030,'C','已失效',1030,'1030030_S',0,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatus WHERE FID = 1040020;
INSERT INTO t_tsrbd_offerstatus(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FGROUPID,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040020,'1',NULL,'候选人在最晚回复Offer Letter日期前，没有给出回复',1040020,'C','逾期未回复',1040,'1040020_S',0,{ts'2022-02-17  00:00:00'},1164453183364274176,'1',{ts'2022-02-22  00:00:00'},1164453183364274176,0);

DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '297JWVOM/RYT';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020050,'297JWVOM/RYT','zh_TW','Offer Letter有效期變更還未審批通過','待生成');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5392MN1I4';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030010,'1OP5392MN1I4','zh_CN','Offer申请通过，可以把待生效的Offer Letter发送给候选人','待生效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4TQDQH/ZY';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020010,'1OP4TQDQH/ZY','zh_CN','Offer申请通过，可以把Offer Letter发送给候选人','待发送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4II15=38G';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010010,'1OP4II15=38G','zh_CN','用人部门有意录用候选人，此时需要给候选人申请Offer','待申请');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4II15=38H';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010010,'1OP4II15=38H','zh_TW','用人部門有意錄用候選人，此時需要給候選人申請Offer','待申請');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '297JJV4VG2I+';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010040,'297JJV4VG2I+','zh_CN','Offer申请通过','申请通过');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '297JJV4VG2I/';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010040,'297JJV4VG2I/','zh_TW','Offer申請通過','申請通過');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4OK39ZJIE';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010050,'1OP4OK39ZJIE','zh_CN','因一些特殊原因Offer申请人主动废弃Offer','已废弃');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4OK39ZJIF';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010050,'1OP4OK39ZJIF','zh_TW','因一些特殊原因Offer申請人主動廢棄Offer','已廢棄');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244ME2S9YO4X';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020040,'244ME2S9YO4X','zh_CN','因一些特殊原因Offer申请人主动废弃Offer，同时关联废弃Offer Letter；或直接废弃Offer Letter','已废弃');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '244ME2S9YO4Y';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020040,'244ME2S9YO4Y','zh_TW','因一些特殊原因Offer申請人主動廢棄Offer，同時關聯廢棄Offer Letter；或直接廢棄Offer Letter','已廢棄');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '297JWVOM/RYS';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020050,'297JWVOM/RYS','zh_CN','Offer Letter有效期变更还未审批通过','待生成');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5392MN1I5';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030010,'1OP5392MN1I5','zh_TW','Offer申請通過，可以把待生效的Offer Letter發送給候選人','待生效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5/VCPIFXJ';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030030,'1OP5/VCPIFXJ','zh_CN','因一些特殊原因Offer申请人主动废弃Offer和Offer Letter，或Offer Letter超过了时效性','已失效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5/VCPIFXK';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030030,'1OP5/VCPIFXK','zh_TW','因一些特殊原因Offer申請人主動廢棄Offer和Offer Letter，或Offer Letter超過了時效性','已失效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '28SVZ++WKG+R';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1040020,'28SVZ++WKG+R','zh_CN','候选人在最晚回复Offer Letter日期前，没有给出回复','逾期未回复');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '28SVZ++WKG+S';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1040020,'28SVZ++WKG+S','zh_TW','候選人在最晚回複Offer Letter日期前，沒有給出回複','逾期未回複');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4JWAW6H2G';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010020,'1OP4JWAW6H2G','zh_CN','已提交Offer进行审批','申请中');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4JWAW6H2H';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010020,'1OP4JWAW6H2H','zh_TW','已提交Offer進行審批','申請中');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4RC8DRZUT';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010060,'1OP4RC8DRZUT','zh_CN','Offer审批不通过；
Offer创建人主动废弃Offer审批流程和Offer；
因一些特殊原因Offer创建人主动废弃待发送/已发送/已接受的Offer；
候选人拒绝Offer；
候选人没有入职；','已废弃');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4RC8DRZUU';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010060,'1OP4RC8DRZUU','zh_TW','Offer審批不通過；Offer創建人主動廢棄Offer審批流程和Offer；因一些特殊原因Offer創建人主動廢棄待發送/已發送/已接受的Offer；候選人拒絕Offer；候選人沒有入職；','已廢棄');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4V+XC/K1O';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020020,'1OP4V+XC/K1O','zh_TW','在最晚發送日期前沒有發送Offer Letter','逾期未發送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4W2WEG=Q9';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020030,'1OP4W2WEG=Q9','zh_CN','Offer Letter已经发送给候选人','已发送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4L/YXBW9X';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010030,'1OP4L/YXBW9X','zh_CN','Offer申请不通过','申请终止');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4L/YXBW9Y';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010030,'1OP4L/YXBW9Y','zh_TW','Offer申請不通過','申請終止');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4V+XC/K1N';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020020,'1OP4V+XC/K1N','zh_CN','在最晚发送日期前没有发送Offer Letter','逾期未发送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4W2WEG=Q=';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020030,'1OP4W2WEG=Q=','zh_TW','Offer Letter已經發送給候選人','已發送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP4TQDQH/ZZ';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1020010,'1OP4TQDQH/ZZ','zh_TW','Offer申請通過，可以把Offer Letter發送給候選人','待發送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5+MMZWKJU';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030020,'1OP5+MMZWKJU','zh_CN','Offer Letter成功发送给候选人后，立即生效','已生效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1OP5+MMZWKJV';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1030020,'1OP5+MMZWKJV','zh_TW','Offer Letter成功發送給候選人後，立即生效','已生效');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1YB/G=YR9ARI';
INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010070,'1YB/G=YR9ARI','zh_CN','Offer申请人在最晚发送Offer日期内没有发送Offer','逾期未发送');
DELETE FROM t_tsrbd_offerstatus_l WHERE FPKID = '1YB/G=YR9ARJ';
--INSERT INTO t_tsrbd_offerstatus_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1010070,'1YB/G=YR9ARJ','zh_TW','Offer申請人在最晚發送Offer日期內沒有發送Offer','逾期未發送');

-- Offer状态类型
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1LNHEMKQM';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1LNHEMKQN';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '244J7YDDK1D4';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '244J7YDDK1D5';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1JA6/IHT0';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1JA6/IHT1';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '244LCVF0Q1M2';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '244LCVF0Q1M3';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1KLZNVEIN';
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '1OP1KLZNVEIO';
DELETE FROM t_tsrbd_offerstatustype WHERE FID = 1010;
INSERT INTO t_tsrbd_offerstatustype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1010,'1',NULL,'Offer状态','Offer业务状态',1010,'C','Offer状态','1010_S',0,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-25  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatustype WHERE FID = 1020;
INSERT INTO t_tsrbd_offerstatustype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1020,'1',NULL,'Offer Letter状态','Offer Letter业务状态（Offer申请人操作）',1020,'C','Offer Letter状态','1020_S',1,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-25  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatustype WHERE FID = 1040;
INSERT INTO t_tsrbd_offerstatustype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1040,'1',NULL,'Offer Letter回复状态','Offer Letter业务状态（候选人操作）',1040,'C','Offer Letter回复状态','1040_S',3,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-25  00:00:00'},1164453183364274176,0);
DELETE FROM t_tsrbd_offerstatustype WHERE FID = 1030;
INSERT INTO t_tsrbd_offerstatustype(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FNUMBER,FINDEX,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1030,'1',NULL,'Offer Letter数据状态','Offer Letter数据状态',1030,'C','Offer Letter数据状态','1030_S',2,{ts'2021-06-14  00:00:00'},1164453183364274176,'1',{ts'2022-02-25  00:00:00'},1164453183364274176,0);

DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWTMYPIS/+';
INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'29GWTMYPIS/+','zh_CN','Offer状态','Offer业务状态','Offer状态');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWTMYPIS//';
--INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1010,'29GWTMYPIS//','zh_TW','Offer狀態','Offer業務狀態','Offer狀態');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWV4L+I/Q4';
INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'29GWV4L+I/Q4','zh_CN','Offer Letter状态','Offer Letter业务状态（Offer申请人操作）','Offer Letter状态');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWV4L+I/Q5';
--INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1020,'29GWV4L+I/Q5','zh_TW','Offer Letter狀態','Offer Letter業務狀態（Offer申請人操作）','Offer Letter狀態');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWWNLA/YVG';
INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'29GWWNLA/YVG','zh_CN','Offer Letter回复状态','Offer Letter业务状态（候选人操作）','Offer Letter回复状态');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWWNLA/YVH';
--INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1040,'29GWWNLA/YVH','zh_TW','Offer Letter回複狀態','Offer Letter業務狀態（候選人操作）','Offer Letter回複狀態');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWVZ4I03L1';
INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'29GWVZ4I03L1','zh_CN','Offer Letter数据状态','Offer Letter数据状态','Offer Letter数据状态');
DELETE FROM t_tsrbd_offerstatustype_l WHERE FPKID = '29GWVZ4I03L2';
--INSERT INTO t_tsrbd_offerstatustype_l(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1030,'29GWVZ4I03L2','zh_TW','Offer Letter數據狀態','Offer Letter數據狀態','Offer Letter數據狀態');

--基础资料列表
DELETE FROM t_tsrbd_basedatalist WHERE FID = 1260;
INSERT INTO t_tsrbd_basedatalist(FID,FISSYSPRESET,FDISABLEDATE,FSIMPLENAME,FDESCRIPTION,FMASTERID,FSTATUS,FNAME,FNUMBER,FINDEX,FCREATETIME,FPAGEKEY,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1260,'1',NULL,' ','包含Offer状态、Offer Letter状态、Offer Letter回复状态、Offer Letter数据状态',1260,'C','Offer状态','1260_S',0,{ts'2021-05-19  00:00:00'},'tsrbd_offerstatus',1164453183364274176,'1',{ts'2022-02-17  00:00:00'},1,0);

--OfferLetter字段业务模板
DELETE FROM t_tsrbd_msgfield WHERE FID = 1287628358061927424;
INSERT INTO t_tsrbd_msgfield(FID,FDISABLEDATE,FFIELDPOOLID,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FBIZRANGE,FCREATETIME,FENABLE,FMODIFIERID,FBIZFIELD,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (1287628358061927424,NULL,1287612296545207296,1287628358061927424,'C','T-20211112-02018','验证码',1330385865343538176,',1,',{ts'2021-11-12  00:00:00'},'1',1164453183364274176,'verifycode',{ts'2022-02-25  00:00:00'},1164988236288777216,0);
