DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651379915641237504;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'入职业务管理员','HR组织','CH_020',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ',' ',' ',' ','用户',' ','组织','org',1651379915641237504,' ',' ','10001【业务组织1】;',' ',' ',' ',' ',' ',' ','user',' ','（ex：入职业务管理员角色，既负责人事业务，也负责HR组织业务）',2,1335483776523853824,{ts'2023-06-01  00:00:00'},' ',' ',40000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651372498056556544;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES (NULL,'薪酬系统管理员','薪酬管理','Payroll_01',' ',' ',' ','与角色范围一致',{ts'2023-03-29  00:00:00'},NULL,' ',' ',' ',' ',' ',' ',' ',' ',1651372498056556544,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ','下载模板，自动加载角色清单信息',1,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',10000,1335483776523853824,'场景一'); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651379067058041856;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'入职业务管理员','人事管理','CH_020',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ',' ','一个角色下，数据范围属性必须保持一致',' ','用户',' ','组织','org',1651379067058041856,' ',' ','10001【业务组织1】<包含下级>;10002【业务组织2】<包含下级>;','不同职能，业务组织范围可不同',' ','org2【**公司】',' ',' ','org1【**集团】;org2【**公司】;','user',' ','角色有多个职能',1,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',40000,1335483776523853824,'场景四');
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651380779684639744;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'人力成本管理员','薪酬管理','Payroll_03',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ',' ','一个角色下，数据范围属性必须保持一致',' ','用户','group1【奖金组】','组织','org',1651380779684639744,' ',' ','10001【业务组织1】;10002【业务组织2】;','一个角色同个职能，业务数据范围必须一致',' ',' ',' ',' ','org1【**集团】','user',' ','多组角色维度范围。用户在相同角色中，负责多类业务',1,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',50000,1335483776523853824,'场景五'); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651381578003296256;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'人力成本管理员','薪酬管理','Payroll_03',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ',' ',' ',' ','用户','group2【基本工资组】','组织','org',1651381578003296256,' ',' ','10001【业务组织1】;10002【业务组织2】;',' ',' ',' ',' ',' ','org2【**公司】','user',' ','（ex：用户在同个业务组织下，分别处理集团的奖金业务，及子公司的基本工资业务）',2,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',50000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651373951919763456;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES (NULL,'入职业务管理员','HR组织','CH_020',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},NULL,' ',' ',' ',' ',' ',' ',' ',' ',1651373951919763456,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',5,1335483776523853824,{ts'2023-03-29  00:00:00'},' ',' ',10000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651372897723397120;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES (NULL,'薪酬成本专员','薪酬管理','Payroll_02',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},NULL,' ',' ',' ',' ',' ',' ',' ',' ',1651372897723397120,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',2,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',10000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651373219845943296;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES (NULL,'人力成本管理员','薪酬管理','Payroll_03',' ',' ',' ',' ',{ts'2023-03-29  00:00:00'},NULL,' ',' ',' ',' ',' ',' ',' ',' ',1651373219845943296,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',3,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',10000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651373629872714752;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES (NULL,'入职业务管理员','人事管理','CH_020',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},NULL,' ',' ',' ',' ',' ',' ',' ',' ',1651373629872714752,' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',' ',4,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',10000,1335483776523853824,' '); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651376934573224960;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'薪酬系统管理员','薪酬管理','Payroll_01',' ',' ',' ','与角色范围一致',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ',' ',' ',' ','用户',' ','组织','org',1651376934573224960,' ',' ',' ',' ',' ',' ',' ',' ',' ','user',' ','与角色范围一致 无需设置业务组织范围和角色维度范围',1,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',20000,1335483776523853824,'场景二'); 
DELETE FROM t_hrcs_pinitdemouserdim WHERE FID = 1651378058067881984;
INSERT INTO t_hrcs_pinitdemouserdim(FVALIDEND,FROLENAME,FBUCAFUNC,FROLENUMBER,FROLENUMBERTIP,FUSERNAMETIP,FBUCAFUNCTIP,FCUSTOMENABLE,FCREATETIME,FDATEFIELD,FVALIDENDTIP,FDIMSALARYGROUPTIP,FCUSTOMENABLETIP,FFILEORGNAMETIP,FUSERNAME,FDIMSALARYGROUP,FFILEORGNAME,FFILEORGNUMBER,FID,FDIMCOUNTRYAREATIP,FFILEORGNUMBERTIP,FORGRANGE,FORGRANGETIP,FVALIDSTARTTIP,FDIMPROJECTTEAM,FDIMADMINORGTIP,FDIMCOUNTRYAREA,FDIMADMINORG,FUSERNUMBER,FDIMPROJECTTEAMTIP,FSCENEDESC,FINDEX,FMODIFIERID,FMODIFYTIME,FUSERNUMBERTIP,FROLENAMETIP,FSCENEID,FCREATORID,FSCENENAME) VALUES ({ts'2026-06-01  00:00:00'},'薪酬成本专员','薪酬管理','Payroll_02',' ',' ',' ','自定义范围',{ts'2023-03-29  00:00:00'},{ts'2023-06-01  00:00:00'},' ','当【数据范围属性=自定义范围】时，且角色有维度控权，则必须录入维度值。 除组织团队类型列，其他维度都支持设置“不限” 或者“ALL”',' ',' ','用户','ALL','组织','org',1651378058067881984,' ',' ','10001【业务组织1】<包含下级>;10002【业务组织2】<包含下级>;','1、可录入多个值，按分号分隔显示；2、名称非必录项；3、支持设置业务组织包含下级，特殊标记符号为<包含下级>。',' ',' ','1、可录入多个值，按分号分隔显示；2、名称非必录项；3、支持设置包含下级，特殊标记符号为<包含下级>。示例如下：org2【**公司】<包含下级>;org2<包含下级>；4、支持设置动态数据范围。示例如下：DYNA_COND_10020【任职部门及下级部门】。',' ','org1【**集团】<包含下级>；org2【**公司】；DYNA_COND_10010 【任职部门】;','user',' ','自定义范围。需设置业务组织范围，角色维度范围按需录入',1,1335483776523853824,{ts'2023-08-28  00:00:00'},' ',' ',30000,1335483776523853824,'场景三');
