/* 预置HR的相关职能类型 */
DELETE FROM t_org_bizlist WHERE FID = 21;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (21,'1',NULL,21,'C','0','0','组织设计业务组织','21','fishrod',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrod',1,0);
DELETE FROM t_org_bizlist WHERE FID = 22;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (22,'1',NULL,22,'C','0','0','组织绩效业务组织','22','fishrop',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrop',1,0);
DELETE FROM t_org_bizlist WHERE FID = 23;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (23,'1',NULL,23,'C','0','0','编制/预算业务组织','23','fishrbg',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrbg',1,0);
DELETE FROM t_org_bizlist WHERE FID = 24;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (24,'1',NULL,24,'C','0','0','人才招聘业务组织','24','fishrtr',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrtr',1,0);
DELETE FROM t_org_bizlist WHERE FID = 25;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (25,'1',NULL,25,'C','0','0','员工人事业务组织','25','fishrpa',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrpa',1,0);
DELETE FROM t_org_bizlist WHERE FID = 26;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (26,'1',NULL,26,'C','0','0','工时考勤业务组织','26','fishrwt',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrwt',1,0);
DELETE FROM t_org_bizlist WHERE FID = 27;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (27,'1',NULL,27,'C','0','0','薪酬管理业务组织','27','fishrcmp',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrcmp',1,0);
DELETE FROM t_org_bizlist WHERE FID = 28;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (28,'1',NULL,28,'C','0','0','定调薪业务组织','28','fishrbs',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrbs',1,0);
DELETE FROM t_org_bizlist WHERE FID = 29;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (29,'1',NULL,29,'C','0','0','发薪业务组织','29','fishrpay',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrpay',1,0);
DELETE FROM t_org_bizlist WHERE FID = 30;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (30,'1',NULL,30,'C','0','0','个税业务组织','30','fishrtax',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrtax',1,0);
DELETE FROM t_org_bizlist WHERE FID = 31;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (31,'1',NULL,31,'C','0','0','社保业务组织','31','fishrsi',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrsi',1,0);
DELETE FROM t_org_bizlist WHERE FID = 32;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (32,'1',NULL,32,'C','0','0','长期激励业务组织','32','fishrlti',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrlti',1,0);
DELETE FROM t_org_bizlist WHERE FID = 33;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (33,'1',NULL,33,'C','0','0','奖金业务组织','33','fishrbm',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrbm',1,0);
DELETE FROM t_org_bizlist WHERE FID = 34;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (34,'1',NULL,34,'C','0','0','人才发展业务组织','34','fishrtd',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrtd',1,0);
DELETE FROM t_org_bizlist WHERE FID = 35;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (35,'1',NULL,35,'C','0','0','培训学习业务组织','35','fishrtl',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrtl',1,0);
DELETE FROM t_org_bizlist WHERE FID = 36;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (36,'1',NULL,36,'C','0','0','个人绩效业务组织','36','fishrip',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrip',1,0);
DELETE FROM t_org_bizlist WHERE FID = 37;
INSERT INTO t_org_bizlist(FID,FISENABLED,FDISABLEDATE,FMASTERID,FSTATUS,FUSERDEFINE,FVISIABLE,FNAME,FNUMBER,FPROPERTYNAME,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FISBASETYPE,FCATEGORY,FFIELDNAME,FCREATORID,FDISABLERID) VALUES (37,'1',NULL,37,'C','0','0','HR共享服务业务组织','37','fishrssc',{ts'2018-08-08 18:08:08'},'1',1,{ts'2018-08-08 18:08:08'},'1','1','fishrssc',1,0);

DELETE FROM t_org_bizlist_l WHERE FPKID = '16483DLV8K+3';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (21,'16483DLV8K+3','zh_CN','组织设计业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648569KVKTQ';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (22,'1648569KVKTQ','zh_CN','组织绩效业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '164862ZT0QBP';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (23,'164862ZT0QBP','zh_CN','编制/预算业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '16488575+D37';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (24,'16488575+D37','zh_CN','人才招聘业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648940VBCMP';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (25,'1648940VBCMP','zh_CN','员工人事业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '16489YU7AYGL';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (26,'16489YU7AYGL','zh_CN','工时考勤业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648=WFHE5RJ';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (27,'1648=WFHE5RJ','zh_CN','薪酬管理业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648AOSGB2KJ';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (28,'1648AOSGB2KJ','zh_CN','定调薪业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648BOYDMV8L';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (29,'1648BOYDMV8L','zh_CN','发薪业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648CNU14JTV';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (30,'1648CNU14JTV','zh_CN','个税业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648DI=8C20U';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (31,'1648DI=8C20U','zh_CN','社保业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648EBRR4W4G';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (32,'1648EBRR4W4G','zh_CN','长期激励业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648F7BDEAM1';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (33,'1648F7BDEAM1','zh_CN','奖金业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648G9FCTPVL';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (34,'1648G9FCTPVL','zh_CN','人才发展业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648H6117222';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (35,'1648H6117222','zh_CN','培训学习业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648I35XFJ2V';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (36,'1648I35XFJ2V','zh_CN','个人绩效业务组织');
DELETE FROM t_org_bizlist_l WHERE FPKID = '1648J260/5XQ';
INSERT INTO t_org_bizlist_l(FID,FPKID,FLOCALEID,FNAME) VALUES (37,'1648J260/5XQ','zh_CN','HR共享服务业务组织');

/* 预置HR的相关职能类型对应的默认视图方案 */
DELETE FROM t_org_viewschema WHERE FID = 21;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (21,{ts'2018-08-08  18:08:08'},NULL,'1',21,'C','21','组织设计业务视图默认方案',{ts'2018-08-08  18:08:08'},'21','1',1,21,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 22;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (22,{ts'2018-08-08  18:08:08'},NULL,'1',22,'C','22','组织绩效业务视图默认方案',{ts'2018-08-08  18:08:08'},'22','1',1,22,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 23;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (23,{ts'2018-08-08  18:08:08'},NULL,'1',23,'C','23','编制/预算业务视图默认方案',{ts'2018-08-08  18:08:08'},'23','1',1,23,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 24;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (24,{ts'2018-08-08  18:08:08'},NULL,'1',24,'C','24','人才招聘业务视图默认方案',{ts'2018-08-08  18:08:08'},'24','1',1,24,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 25;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (25,{ts'2018-08-08  18:08:08'},NULL,'1',25,'C','25','员工人事业务视图默认方案',{ts'2018-08-08  18:08:08'},'25','1',1,25,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 26;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (26,{ts'2018-08-08  18:08:08'},NULL,'1',26,'C','26','工时考勤业务视图默认方案',{ts'2018-08-08  18:08:08'},'26','1',1,26,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 27;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (27,{ts'2018-08-08  18:08:08'},NULL,'1',27,'C','27','薪酬管理业务视图默认方案',{ts'2018-08-08  18:08:08'},'27','1',1,27,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 28;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (28,{ts'2018-08-08  18:08:08'},NULL,'1',28,'C','28','定调薪业务视图默认方案',{ts'2018-08-08  18:08:08'},'28','1',1,28,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 29;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (29,{ts'2018-08-08  18:08:08'},NULL,'1',29,'C','29','发薪业务视图默认方案',{ts'2018-08-08  18:08:08'},'29','1',1,29,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 30;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (30,{ts'2018-08-08  18:08:08'},NULL,'1',30,'C','30','个税业务视图默认方案',{ts'2018-08-08  18:08:08'},'30','1',1,30,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 31;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (31,{ts'2018-08-08  18:08:08'},NULL,'1',31,'C','31','社保业务视图默认方案',{ts'2018-08-08  18:08:08'},'31','1',1,31,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 32;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (32,{ts'2018-08-08  18:08:08'},NULL,'1',32,'C','32','长期激励业务视图默认方案',{ts'2018-08-08  18:08:08'},'32','1',1,32,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 33;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (33,{ts'2018-08-08  18:08:08'},NULL,'1',33,'C','33','奖金业务视图默认方案',{ts'2018-08-08  18:08:08'},'33','1',1,33,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 34;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (34,{ts'2018-08-08  18:08:08'},NULL,'1',34,'C','34','人才发展业务视图默认方案',{ts'2018-08-08  18:08:08'},'34','1',1,34,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 35;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (35,{ts'2018-08-08  18:08:08'},NULL,'1',35,'C','35','培训学习业务视图默认方案',{ts'2018-08-08  18:08:08'},'35','1',1,35,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 36;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (36,{ts'2018-08-08  18:08:08'},NULL,'1',36,'C','36','个人绩效业务视图默认方案',{ts'2018-08-08  18:08:08'},'36','1',1,36,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);
DELETE FROM t_org_viewschema WHERE FID = 37;
INSERT INTO t_org_viewschema(FID,FSTARTDATE,FCHECKDATE,FISDEFAULT,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FTREETYPE,FENABLE,FMODIFIERID,FTREETYPEID,FMODIFYTIME,FENDDATE,FUSAGE,FCHECKERID,FCREATORID) VALUES (37,{ts'2018-08-08  18:08:08'},NULL,'1',37,'C','37','HR共享服务业务视图默认方案',{ts'2018-08-08  18:08:08'},'37','1',1,37,{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},' ',0,1);


DELETE FROM t_org_viewschema_l WHERE FPKID = '16483DPV5E95';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (21,'16483DPV5E95','zh_CN',' ','组织设计业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '164856=EHAJB';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (22,'164856=EHAJB','zh_CN',' ','组织绩效业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '164863+TY=GB';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (23,'164863+TY=GB','zh_CN',' ','编制/预算业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648857X+PNA';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (24,'1648857X+PNA','zh_CN',' ','人才招聘业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648941P+3CA';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (25,'1648941P+3CA','zh_CN',' ','员工人事业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '16489YV0ZO77';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (26,'16489YV0ZO77','zh_CN',' ','工时考勤业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648=WGB0XH5';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (27,'1648=WGB0XH5','zh_CN',' ','薪酬管理业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648AOTDL8HO';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (28,'1648AOTDL8HO','zh_CN',' ','定调薪业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648BOZAX/5Q';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (29,'1648BOZAX/5Q','zh_CN',' ','发薪业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648CNUWS=JG';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (30,'1648CNUWS=JG','zh_CN',' ','个税业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648DIA2+TSF';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (31,'1648DIA2+TSF','zh_CN',' ','社保业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648EBSOE01L';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (32,'1648EBSOE01L','zh_CN',' ','长期激励业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648F7C811BO';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (33,'1648F7C811BO','zh_CN',' ','奖金业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648G9G7FFL7';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (34,'1648G9G7FFL7','zh_CN',' ','人才发展业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648H61T7DM6';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (35,'1648H61T7DM6','zh_CN',' ','培训学习业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648I36YB37H';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (36,'1648I36YB37H','zh_CN',' ','个人绩效业务视图默认方案');
DELETE FROM t_org_viewschema_l WHERE FPKID = '1648J26S/HFU';
INSERT INTO t_org_viewschema_l(FID,FPKID,FLOCALEID,FCOMMENT,FNAME) VALUES (37,'1648J26S/HFU','zh_CN',' ','HR共享服务业务视图默认方案');


/* 预置HR的相关职能类型对应的默认视图方案的根组织 */
DELETE FROM t_org_structure WHERE FID = 1018857396446966784;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018857396446966784,{ts'2018-08-08  18:08:08'},'1',21,1,' ',' ',1018857396446966784,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018857641000055808;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018857641000055808,{ts'2018-08-08  18:08:08'},'1',22,1,' ',' ',1018857641000055808,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018857766644626432;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018857766644626432,{ts'2018-08-08  18:08:08'},'1',23,1,' ',' ',1018857766644626432,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858048954840064;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858048954840064,{ts'2018-08-08  18:08:08'},'1',24,1,' ',' ',1018858048954840064,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858182090437632;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858182090437632,{ts'2018-08-08  18:08:08'},'1',25,1,' ',' ',1018858182090437632,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858293910582272;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858293910582272,{ts'2018-08-08  18:08:08'},'1',26,1,' ',' ',1018858293910582272,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858422759601152;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858422759601152,{ts'2018-08-08  18:08:08'},'1',27,1,' ',' ',1018858422759601152,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858533061407744;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858533061407744,{ts'2018-08-08  18:08:08'},'1',28,1,' ',' ',1018858533061407744,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858670861071360;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858670861071360,{ts'2018-08-08  18:08:08'},'1',29,1,' ',' ',1018858670861071360,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858804164441088;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858804164441088,{ts'2018-08-08  18:08:08'},'1',30,1,' ',' ',1018858804164441088,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018858921898554368;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018858921898554368,{ts'2018-08-08  18:08:08'},'1',31,1,' ',' ',1018858921898554368,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859036218504192;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859036218504192,{ts'2018-08-08  18:08:08'},'1',32,1,' ',' ',1018859036218504192,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859154338493440;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859154338493440,{ts'2018-08-08  18:08:08'},'1',33,1,' ',' ',1018859154338493440,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859298916152320;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859298916152320,{ts'2018-08-08  18:08:08'},'1',34,1,' ',' ',1018859298916152320,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859424225178624;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859424225178624,{ts'2018-08-08  18:08:08'},'1',35,1,' ',' ',1018859424225178624,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859551421641728;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859551421641728,{ts'2018-08-08  18:08:08'},'1',36,1,' ',' ',1018859551421641728,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);
DELETE FROM t_org_structure WHERE FID = 1018859685068944384;
INSERT INTO t_org_structure(FSEALUPTIME,FCREATEORGID,FISHR,FYZJORGID,FMASTERID,FCREATETIME,FENABLE,FVIEWID,FLEVEL,FLONGNUMBER,FFULLNAME,FID,FSORTCODE,FMODIFYORGID,FSTARTDATE,FISBIZUNIT,FYZJPARENTORGID,FORGID,FSTATUS,FPARENTID,FNUMBER,FISFREEZE,FMODIFIERID,FISLEAF,FISSTATSUM,FISCTRLUNIT,FMODIFYTIME,FENDDATE,FCREATORID) VALUES (NULL,0,'0',' ',1018859685068944384,{ts'2018-08-08  18:08:08'},'1',37,1,' ',' ',1018859685068944384,'0',0,{ts'2018-08-08  18:08:08'},'1',' ',100000,'C',0,' ','0',1,'1','0','1',{ts'2018-08-08  18:08:08'},{ts'2999-12-31  00:00:00'},1);

DELETE FROM t_org_structure_l WHERE FPKID = '16483DV8GHEX';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018857396446966784,'16483DV8GHEX','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '164856BNI=5N';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018857641000055808,'164856BNI=5N','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648631872GO';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018857766644626432,'1648631872GO','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '164885=7N2G4';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858048954840064,'164885=7N2G4','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648943Y/2+M';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858182090437632,'1648943Y/2+M','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '16489YX6C7N/';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858293910582272,'16489YX6C7N/','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648=WICU0QF';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858422759601152,'1648=WICU0QF','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648AOVXHFPI';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858533061407744,'1648AOVXHFPI','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648BP03OFZ3';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858670861071360,'1648BP03OFZ3','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648CNXKYB4B';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858804164441088,'1648CNXKYB4B','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648DICH9LSS';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018858921898554368,'1648DICH9LSS','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648EBVJTX0H';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859036218504192,'1648EBVJTX0H','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648F7EUKOR0';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859154338493440,'1648F7EUKOR0','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648G9I5L5N+';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859298916152320,'1648G9I5L5N+','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648H6408C8H';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859424225178624,'1648H6408C8H','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648I39XCDCX';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859551421641728,'1648I39XCDCX','zh_CN',' ',' ');
DELETE FROM t_org_structure_l WHERE FPKID = '1648J292NW9N';
INSERT INTO t_org_structure_l(FID,FPKID,FLOCALEID,FFULLNAME,FNAME) VALUES (1018859685068944384,'1648J292NW9N','zh_CN',' ',' ');

/** 更新根组织长编码、长名称 */
update T_ORG_STRUCTURE set flongnumber = isnull(select max(fnumber) from t_org_org where fid = 100000, ' ') where forgid = 100000 and fviewid between 21 and 37;
update T_ORG_STRUCTURE set ffullname = isnull(select max(fname) from t_org_org_l ol where flocaleid = 'zh_CN' and fid = 100000, ' ') where forgid = 100000 and fviewid between 21 and 37;
update T_ORG_STRUCTURE_L set ffullname = isnull(select max(fname) from t_org_org_l ol where T_ORG_STRUCTURE_L.flocaleid = ol.flocaleid and fid = 100000, ' ') where fid in (select fid from t_org_structure where forgid = 100000 and fviewid between 21 and 37);

/** 组织表勾选相应职能类型 */
update t_org_org set fishr = '1',fishrod = '1',fishrop = '1',fishrbg = '1',fishrtr = '1',fishrpa = '1',fishrwt = '1',fishrcmp = '1',fishrbs = '1',fishrpay = '1',fishrtax = '1',fishrsi = '1',fishrlti = '1',fishrbm = '1',fishrtd = '1',fishrtl = '1',fishrip = '1',fishrssc = '1' where fid = 100000;
