-- 入职办理列表新增职位体系管理组织维度

-- 入职办理列表-入职流程中
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1433931114447223808;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1433931114447223808,{ts'2022-06-02  00:00:00'},13466739,{ts'2024-06-06  00:00:00'},'1WXB5G9/BL46',1,'hom_personwaitonbrd');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1966905073980262400;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1433931114447223808,'0','1','ajobscmorg',1966905073980262400,1401510877118763008,4,' ','2');


-- 入职办理列表-入职终止
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1397806363186497536;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1397806363186497536,{ts'2022-04-13  00:00:00'},13466739,{ts'2024-06-06  00:00:00'},'1WXB5G9/BL46',1356610128484410368,'hom_personbreakuponbrd');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1966905426217917440;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1397806363186497536,'0','1','ajobscmorg',1966905426217917440,1401510877118763008,4,' ','2');

-- 入职办理列表-全部
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1433917136216112128;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1433917136216112128,{ts'2022-06-02  00:00:00'},13466739,{ts'2024-05-22  00:00:00'},'1WXB5G9/BL46',1,'hom_personallonbrd');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1955752174428381184;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1433917136216112128,'0','1','ajobscmorg',1955752174428381184,1401510877118763008,6,' ','2');

-- 入职办理列表-已入职
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1397804631484154880;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1397804631484154880,{ts'2022-04-13  00:00:00'},13466739,{ts'2024-06-06  00:00:00'},'1WXB5G9/BL46',1356610128484410368,'hom_personhasonbrd');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1966906161773004800;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1397804631484154880,'0','1','ajobscmorg',1966906161773004800,1401510877118763008,4,' ','2');

-- 入职办理列表-待启动入职
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1433929155195551744;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1433929155195551744,{ts'2022-06-02  00:00:00'},13466739,{ts'2024-06-06  00:00:00'},'1WXB5G9/BL46',1,'hom_personwaitstart');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1966906381781026816;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1433929155195551744,'0','1','ajobscmorg',1966906381781026816,1401510877118763008,5,' ','2');

-- 预入职
DELETE FROM T_HRCS_ENTITYCTRL WHERE FID = 1813846111312615424;
INSERT INTO T_HRCS_ENTITYCTRL(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1813846111312615424,{ts'2023-11-08  00:00:00'},13466739,{ts'2024-05-30  00:00:00'},'1WXB5G9/BL46',13466739,'hom_preonbrdbasebill');
DELETE FROM T_HRCS_ENTITYDIMENTRY WHERE FENTRYID = 1961816582644575232;
INSERT INTO T_HRCS_ENTITYDIMENTRY(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1813846111312615424,'0','1','ajobscmorg',1961816582644575232,1401510877118763008,3,' ','2');
