 -- 业务领域（t_hbss_hrbusinessfield）
 DELETE FROM T_HBSS_HRBUSINESSFIELD WHERE fid=1050;
 INSERT INTO T_HBSS_HRBUSINESSFIELD(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fname,fsimplename,fdescription,ffullname,forinumber,foriname,foristatus)
 VALUES(1050,'1050_S','C',1,{ts'2023-12-18 19:59:22'},1,{ts'2023-12-18 19:59:59'},'1',1050,0,null,0,'1','目标绩效',' ',' ',' ',' ',' ','0');
 DELETE FROM T_HBSS_HRBUSINESSFIELD_L WHERE FPKID='3SCJM/=SR7SL';
 INSERT INTO T_HBSS_HRBUSINESSFIELD_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription,ffullname,foriname)
 VALUES('3SCJM/=SR7SL',1050,'zh_CN','目标绩效',' ',' ',' ','目标绩效');

-- 删除个人绩效多语言数据
 DELETE FROM T_HBSS_HRBUSINESSFIELD_L WHERE FPKID='2BEK1VZ4D=JR';
 DELETE FROM T_HBSS_HRBUSINESSFIELD_L WHERE FPKID='3DH4K4E36ILG';



  -- 业务类型
 DELETE FROM T_HBSS_BUSSINESSFIELD WHERE fid=105010;
 INSERT INTO T_HBSS_BUSSINESSFIELD(fid,fnumber,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fstatus,fdisablerid,fdisabledate,findex,fissyspreset,fmasterid,fcontrolfuntypeid,fbusinessfieldid,fname,fsimplename,fdescription,fbussinessobjectid,forinumber,foriname,foristatus)
 VALUES(105010,'105010_S',1,{ts'2022-03-30 11:36:04'},1,{ts'2022-03-30 11:54:27'},'1','C',0,null,0,'1',105010,36,1050,'绩效管理',' ','  ',0,'105010_S','绩效管理','0');
 DELETE FROM T_HBSS_BUSSINESSFIELD_L WHERE FPKID='2BERE909LJRJ';

 INSERT INTO T_HBSS_BUSSINESSFIELD_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription,foriname)
 VALUES('2BERE909LJRJ',105010,'zh_CN','绩效管理',' ','  ',' ');
-- 删除集成服务
 DELETE FROM T_HBSS_BUSSINESSFIELD WHERE fid=109010;
 DELETE FROM T_HBSS_BUSSINESSFIELD_L WHERE FPKID='3HUFYNIEIPH2';
 DELETE FROM T_HBSS_BUSSINESSFIELD_L WHERE FPKID='3KEQC=E0DE69';


  -- 应用与业务类型关系配置（t_hbss_appbusinesstype  1334_S 1336_S 1338_S 1363_S）
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1334;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1334,'1334_S','C',1,{ts'2023-12-19 00:00:00'},1,{ts'2023-12-19 00:00:00'},'1',1,0,null,0,'1','24E05ECYZ6K0',105010,' ',' ',' ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1336;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1336,'1336_S','C',1,{ts'2023-12-19 00:00:00'},1,{ts'2023-12-19 00:00:00'},'1',1,0,null,0,'1','24E/XB8SQUZU',105010,' ',' ',' ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1338;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1338,'1338_S','C',1,{ts'2023-12-19 00:00:00'},1,{ts'2023-12-19 00:00:00'},'1',1,0,null,0,'1','24BC1SMQXGOE',105010,' ',' ',' ');
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1363;
 INSERT INTO T_HBSS_APPBUSINESSTYPE(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fappid,fbusinesstypeid,fname,fsimplename,fdescription)
 VALUES(1363,'1363_S','C',1,{ts'2023-12-19 00:00:00'},1,{ts'2023-12-19 00:00:00'},'1',1,0,null,0,'1','3=0WAUGB+EOW',106010,' ',' ',' ');

-- 删除多余数据
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1762368671306555392;
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1752299391005343744;
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1752304382159995904;
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1767492905276035072;
 DELETE FROM T_HBSS_APPBUSINESSTYPE WHERE fid=1767493104773911552;

  -- 职能类型
 DELETE FROM T_HBSS_HRBUCAFUNC WHERE fid=36;
 INSERT INTO T_HBSS_HRBUCAFUNC(fid,fnumber,fstatus,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fmasterid,fdisablerid,fdisabledate,findex,fissyspreset,fname,fsimplename,fdescription)
 VALUES(36,'36','C',1,{ts'2021-10-25 00:00:00'},1,{ts'2022-02-21 00:00:00'},'1',36,0,null,0,'1','绩效管理',' ','绩效管理组织为企业目标/团队/个人绩效业务的虚拟管控实体，用于绩效管理业务数据权限管控。企业可以将业务数据在绩效管理组织之间共享参考，也可以分配使用。');
 DELETE FROM T_HBSS_HRBUCAFUNC_L WHERE FPKID='2+JHULQCRLRE';
 INSERT INTO T_HBSS_HRBUCAFUNC_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('2+JHULQCRLRE',36,'zh_CN','绩效管理',' ','绩效管理组织为企业目标/团队/个人绩效业务的虚拟管控实体，用于绩效管理业务数据权限管控。企业可以将业务数据在绩效管理组织之间共享参考，也可以分配使用。');

 -- HR业务管理视图
 DELETE FROM T_HBSS_HRBUCA WHERE fid=36;
 INSERT INTO T_HBSS_HRBUCA(fid,fnumber,fcreatorid,fcreatetime,fmodifierid,fmodifytime,fenable,fstatus,fdisablerid,fdisabledate,findex,fmasterid,fissyspreset,fhrbubaid,fdybutton,fhrbucafuncid,ffinalparentid,fparentid,fsyncstrategy,fname,fsimplename,fdescription)
 VALUES(36,'36',1,{ts'2020-05-15 17:01:58'},1,{ts'2023-12-18 20:33:23'},'1','C',0,null,0,36,'1',0,' ',0,0,11,'0','绩效管理视图默认方案',' ','绩效管理视图是企业的绩效管理组织层次结构，反应全部绩效管理组织上下层级关系的树状结构。');
 DELETE FROM T_HBSS_HRBUCA_L WHERE FPKID='1648I35XFJ2V';
 INSERT INTO T_HBSS_HRBUCA_L(fpkid,fid,flocaleid,fname,fsimplename,fdescription)
 VALUES('1648I35XFJ2V',36,'zh_CN','绩效管理视图默认方案',' ','绩效管理视图是企业的绩效管理组织层次结构，反应全部绩效管理组织上下层级关系的树状结构。');

-- HR职能类型（hbss_hrbucafunc）
UPDATE t_hbss_hrbucafunc SET fnumber = '11,21,24,25,28,29,30,26,31,34,36,38' WHERE fid = 618;

 

 