-- （平台）业务管理视图（新）
DELETE FROM t_org_viewschema_l WHERE fpkid = '16483DPV5E95';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('16483DPV5E95', 21, 'zh_CN', '组织管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648857X+PNA';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648857X+PNA', 24, 'zh_CN', '招聘管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648941P+3CA';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648941P+3CA', 25, 'zh_CN', '人事管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '16489YV0ZO77';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('16489YV0ZO77', 26, 'zh_CN', '考勤管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648AOTDL8HO';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648AOTDL8HO', 28, 'zh_CN', '薪酬管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648BOZAX/5Q';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648BOZAX/5Q', 29, 'zh_CN', '算发薪管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648CNUWS=JG';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648CNUWS=JG', 30, 'zh_CN', '个税管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648DIA2+TSF';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648DIA2+TSF', 31, 'zh_CN', '社保公积金管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648G9G7FFL7';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1648G9G7FFL7', 34, 'zh_CN', '人才管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1648I36YB37H';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment) 
VALUES ('1648I36YB37H', 36, 'zh_CN', '绩效管理视图默认方案', ' ');

DELETE FROM t_org_viewschema_l WHERE fpkid = '1R775E/L6ZCA';
INSERT INTO t_org_viewschema_l (fpkid, fid, flocaleid, fname, fcomment)
VALUES ('1R775E/L6ZCA', 38, 'zh_CN', '人力成本管理视图默认方案', ' ');

update t_org_viewschema set fname = (select max(fname) from t_org_viewschema_l bl where bl.flocaleid = 'zh_CN' and bl.fid = t_org_viewschema.fid)
where fid in (21,24,25,26,28,29,30,31,34,36,38);

-- （平台）组织职能类型
DELETE FROM t_org_bizlist_l WHERE fpkid = '4cceaab6-1278-4c9d-a39d-63e9e6e5ca19';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('4cceaab6-1278-4c9d-a39d-63e9e6e5ca19', 11, 'zh_CN', 'HR组织', 'HR管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '16483DLV8K+3';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('16483DLV8K+3', 21, 'zh_CN', '组织管理', '组织体系管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '16488575+D37';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('16488575+D37', 24, 'zh_CN', '招聘管理', '招聘管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648940VBCMP';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648940VBCMP', 25, 'zh_CN', '人事管理', '人事管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '16489YU7AYGL';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('16489YU7AYGL', 26, 'zh_CN', '考勤管理', '考勤管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648AOSGB2KJ';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648AOSGB2KJ', 28, 'zh_CN', '薪酬管理', '薪酬管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648BOYDMV8L';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648BOYDMV8L', 29, 'zh_CN', '算发薪管理', '算发薪管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648CNU14JTV';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648CNU14JTV', 30, 'zh_CN', '个税管理', '个税管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648DI=8C20U';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648DI=8C20U', 31, 'zh_CN', '社保公积金管理', '社保公积金管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648G9FCTPVL';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648G9FCTPVL', 34, 'zh_CN', '人才管理', '人才管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1648I35XFJ2V';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1648I35XFJ2V', 36, 'zh_CN', '绩效管理', '绩效管理组织');

DELETE FROM t_org_bizlist_l WHERE fpkid = '1R775DYTEHKY';
INSERT INTO t_org_bizlist_l (fpkid, fid, flocaleid, fname, fuserdefinename)
VALUES ('1R775DYTEHKY', 38, 'zh_CN', '人力成本管理', '人力成本管理组织');

update t_org_bizlist set fname = (select max(fname) from t_org_bizlist_l bl where bl.flocaleid = 'zh_CN' and bl.fid = t_org_bizlist.fid),
fuserdefinename = (select max(fuserdefinename) from t_org_bizlist_l bl2 where bl2.flocaleid = 'zh_CN' and bl2.fid = t_org_bizlist.fid)
where fid in (11,21,24,25,26,28,29,30,31,34,36,38);