-- 增加协作应用维度
DELETE FROM t_hrcs_dimension WHERE FID = 2006587995527869440;
-- INSERT INTO t_hrcs_dimension(FID,FAUTHTYPE,FISSYSPRESET,FSHOWTYPE,FDISABLEDATE,FSIMPLENAME,FISADMINORG,FDESCRIPTION,FISORG,FMASTERID,FSTATUS,FBUCAFUNCID,FDATASOURCE,FENTITYTYPEID,FNUMBER,FNAME,FINDEX,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FTEAMTYPEID,FCREATORID,FDISABLERID) VALUES (2006587995527869440,'row','1','list',NULL,' ','0','薪酬核定单、协作任务中心协作应用、核定应用在字段控权维度。','0',2006587995527869440,'C',0,'basedata','hbp_devportal_bizapp','collaapp','协作应用',0,{ts'2024-07-31  00:00:00'},'1',1,{ts'2024-07-31  00:00:00'},0,1,0); 
DELETE FROM t_hrcs_dimension_L WHERE FPKID = '4=GCBDLZ=BIU';
-- INSERT INTO t_hrcs_dimension_L(FID,FPKID,FLOCALEID,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (2006587995527869440,'4=GCBDLZ=BIU','zh_CN',' ','薪酬核定单、协作任务中心协作应用、核定应用在字段控权维度。','协作应用'); 


-- 协作任务中心 薪酬核定单 增加关联协作应用维度
DELETE FROM t_hrcs_entityctrl WHERE FID = 2006588244996682752;
INSERT INTO t_hrcs_entityctrl(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (2006588244996682752,{ts'2024-07-31  00:00:00'},1,{ts'2024-07-31  00:00:00'},'0NXW1VOPH+QV',1,'hpdi_taskcenter'); 
DELETE FROM t_hrcs_entityctrl WHERE FID = 2006588395773626368;
INSERT INTO t_hrcs_entityctrl(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (2006588395773626368,{ts'2024-07-31  00:00:00'},1,{ts'2024-07-31  00:00:00'},'0NXW1VOPH+QV',1,'hpdi_collatask'); 
DELETE FROM t_hrcs_entityctrl WHERE FID = 1686168188204732416;
INSERT INTO t_hrcs_entityctrl(FID,FCREATETIME,FMODIFIERID,FMODIFYTIME,FAPPID,FCREATORID,FENTITYTYPEID) VALUES (1686168188204732416,{ts'2023-05-16  00:00:00'},1,{ts'2024-07-31  00:00:00'},'0NXW1VOPH+QV',1,'hpdi_summaryvbill'); 

DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 2006588244996786176;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (2006588244996682752,'0','1','collaapp',2006588244996786176,1399092241674404864,1,' ','3'); 
DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 2006588395773522944;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (2006588395773626368,'0','1','collaapp',2006588395773522944,1399092241674404864,1,' ','3'); 
DELETE FROM t_hrcs_entitydimentry WHERE FENTRYID = 2006766809998563328;
INSERT INTO t_hrcs_entitydimentry(FID,FISMUST,FISSYSPRESET,FPROPKEY,FENTRYID,FDIMENSIONID,FSEQ,FDESCRIPTION,FAUTHRANGE) VALUES (1686168188204732416,'0','1','verifyapp',2006766809998563328,1399092241674404864,2,' ','3'); 

