DELETE FROM t_perm_role WHERE FID = '3=NR/T2I93RU';
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM,FUSESCOPE) VALUES ('3=NR/T2I93RU','1',NULL,'3=NR/T2I93RU','C','11H66HLOX4IC','DIM_BCM_MODEL','Role-AdQry-CM','1OSZJUZ7XQ79','体系管理员-查询-合并报表',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-合并报表',{ts'2023-03-30  08:08:08'},' ',1,0,'1','0');
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM) VALUES ('3=NR/T2I93RU','1',NULL,'3=NR/T2I93RU','C','11H66HLOX4IC','DIM_BCM_MODEL','Role-AdQry-CM','1OSZJUZ7XQ79','体系管理员-查询-合并报表',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-合并报表',{ts'2023-03-30  08:08:08'},' ',1,0,'1');
DELETE FROM t_perm_role WHERE FID = '3ACVTHN6T4DQ';
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM,FUSESCOPE) VALUES ('3ACVTHN6T4DQ','1',NULL,'3ACVTHN6T4DQ','C','L/B5N23NCFS','DIM_BCM_MODEL','Role-AdQry-RPT','1OSZJUZ7XQ79','体系管理员-查询-财务报表',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-财务报表',{ts'2023-03-30  08:08:08'},' ',1,0,'1','0');
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM) VALUES ('3ACVTHN6T4DQ','1',NULL,'3ACVTHN6T4DQ','C','L/B5N23NCFS','DIM_BCM_MODEL','Role-AdQry-RPT','1OSZJUZ7XQ79','体系管理员-查询-财务报表',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-财务报表',{ts'2023-03-30  08:08:08'},' ',1,0,'1');

DELETE FROM t_perm_role WHERE FID = '3ACVQ9=T0JR3';
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM,FUSESCOPE) VALUES ('3ACVQ9=T0JR3','1',NULL,'3ACVQ9=T0JR3','C','2K++OWYYMS5J','2MQB5OB1+/BR','Role-AdQry-FAR','1OSZJUZ7XQ79','体系管理员-查询-绩效分析',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-绩效分析',{ts'2023-03-30  08:08:08'},' ',1,0,'1','0');
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM) VALUES ('3ACVQ9=T0JR3','1',NULL,'3ACVQ9=T0JR3','C','2K++OWYYMS5J','2MQB5OB1+/BR','Role-AdQry-FAR','1OSZJUZ7XQ79','体系管理员-查询-绩效分析',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-绩效分析',{ts'2023-03-30  08:08:08'},' ',1,0,'1');

DELETE FROM t_perm_role WHERE FID = '3ACV=1/D72Q7';
IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM,FUSESCOPE) VALUES ('3ACV=1/D72Q7','1',NULL,'3ACV=1/D72Q7','C','2IFNVZ0SS0W4','2MQB5OB1+/BR','Role-AdQry-FIDM','1OSZJUZ7XQ79','体系管理员-查询-披露管理',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-披露管理',{ts'2023-03-30  08:08:08'},' ',1,0,'1','0');
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_PERM_ROLE' AND KSQL_COL_NAME ='FUSESCOPE')
  INSERT INTO t_perm_role(FID,FTYPE,FDISABLEDATE,FMASTERID,FSTATUS,FBIZDOMAINID,FDIMTYPEID,FNUMBER,FGROUPID,FNAME,FCREATETIME,FPARENTROLEID,FMODIFIERID,FENABLE,FROLEGROUPID,FREMARK,FMODIFYTIME,FLONGNUMBER,FCREATORID,FDISABLERID,FISSYSTEM) VALUES ('3ACV=1/D72Q7','1',NULL,'3ACV=1/D72Q7','C','2IFNVZ0SS0W4','2MQB5OB1+/BR','Role-AdQry-FIDM','1OSZJUZ7XQ79','体系管理员-查询-披露管理',{ts'2023-03-30  08:08:08'},' ',1,'1','0','体系管理员-查询-披露管理',{ts'2023-03-30  08:08:08'},' ',1,0,'1');


DELETE FROM t_perm_role_l WHERE FPKID = '34EB6C2+8Y8B';
INSERT INTO t_perm_role_l(FID,FPKID,FLOCALEID,FNAME,FREMARK) VALUES ('34EB6C1I3ULI','34EB6C2+8Y8B','zh_CN','Default-仅在提交后报表数据可见','Default-仅在提交后报表数据可见');
DELETE FROM t_perm_role_l WHERE FPKID = '3=NR/T2WRRVM';
INSERT INTO t_perm_role_l(FID,FPKID,FLOCALEID,FNAME,FREMARK) VALUES ('3=NR/T2I93RU','3=NR/T2WRRVM','zh_CN','体系管理员-查询-合并报表','体系管理员-查询-合并报表');
DELETE FROM t_perm_role_l WHERE FPKID = '3ACVTHN=E32K';
INSERT INTO t_perm_role_l(FID,FPKID,FLOCALEID,FNAME,FREMARK) VALUES ('3ACVTHN6T4DQ','3ACVTHN=E32K','zh_CN','体系管理员-查询-财务报表','体系管理员-查询-财务报表');
DELETE FROM t_perm_role_l WHERE FPKID = '3ACVQ9=WOEF=';
INSERT INTO t_perm_role_l(FID,FPKID,FLOCALEID,FNAME,FREMARK) VALUES ('3ACVQ9=T0JR3','3ACVQ9=WOEF=','zh_CN','体系管理员-查询-绩效分析','体系管理员-查询-绩效分析');
DELETE FROM t_perm_role_l WHERE FPKID = '3ACV=1/VAQ63';
INSERT INTO t_perm_role_l(FID,FPKID,FLOCALEID,FNAME,FREMARK) VALUES ('3ACV=1/D72Q7','3ACV=1/VAQ63','zh_CN','体系管理员-查询-披露管理','体系管理员-查询-披露管理');