/*关联权限项同步到角色 预置脚本*/

-- 动态表单 hpdi_bizdatabillchoicetpl 是关联权限，不需要在角色（Payroll_002）预置数据
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '3/541VMX1+OA';
--INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','2C8K1HOXFILW','3/541VMX1+OA',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabillchoicetpl',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '3/3/TVJ71S3+';
--INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','3/3/TVJ71S3+',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabillchoicetpl',' ');


--如下是全量 --业务数据提报员
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXO';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','201MRIKT8W9J','2D5F2034KVXO',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_allbizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXP';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0=KX5+R7YTRT','2D5F2034KVXP',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_allbizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXQ';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','2D5F2034KVXQ',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_allbizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXR';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','2D5F2034KVXR',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_allbizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXS';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','2D5F2034KVXS',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdataerrorlog',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXT';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','2D5F2034KVXT',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdataerrorlog',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXU';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','2D5F2034KVXU',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_circlebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXV';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','2D5F2034KVXV',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_circlebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXW';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','03LX7W=NY=F2','2D5F2034KVXW',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_circlebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXX';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','201MRIKT8W9J','2D5F2034KVXX',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_circlebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXY';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0=KX5+R7YTRT','2D5F2034KVXY',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_circlebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVXZ';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','2D5F2034KVXZ',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_notcirclebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY+';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0=KX5+R7YTRT','2D5F2034KVY+',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_notcirclebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY/';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','03LX7W=NY=F2','2D5F2034KVY/',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_notcirclebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY0';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','2D5F2034KVY0',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_notcirclebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY1';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','201MRIKT8W9J','2D5F2034KVY1',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_notcirclebizdata',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY2';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4715a0df000000ac','2D5F2034KVY2',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY3';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47156aff000000ac','2D5F2034KVY3',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY4';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0=KX5+R7YTRT','2D5F2034KVY4',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY5';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0A3CBG6XWQC5','2D5F2034KVY5',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY6';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4715e1f1000000ac','2D5F2034KVY6',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY7';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','2C8K1HOXFILW','2D5F2034KVY7',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY8';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0K6+MBJ9Z+KL','2D5F2034KVY8',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY9';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','2D5F2034KVY9',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVY=';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','2D5F2034KVY=',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVYA';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','80513207000000ac','2D5F2034KVYA',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '2D5F2034KVYB';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','804f6478000000ac','2D5F2034KVYB',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabill',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '3/3/TVJ71S3+';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','3/3/TVJ71S3+',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatabillchoicetpl',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '310W5=NCFDMN';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','0=KX5+R7YTRT','310W5=NCFDMN',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatarecord',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '310W5=NCFDMO';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','03LX7W=NY=F2','310W5=NCFDMO',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatarecord',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '310W5=NCFDMP';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','4730fc9f000004ae','310W5=NCFDMP',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatarecord',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '310W5=NCFDMQ';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','201MRIKT8W9J','310W5=NCFDMQ',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatarecord',' ');
DELETE FROM t_perm_rolepermdetial WHERE FENTRYID = '310W5=NCFDMR';
INSERT INTO t_perm_rolepermdetial(FID,FPERMITEMID,FENTRYID,FINHERITMODE,FBIZAPPID,FSEQ,FROLEID,FENTITYTYPEID,FCONTROLMODE) VALUES ('2D5ECEP=2WM8','47150e89000000ac','310W5=NCFDMR',' ','0NXW1VOPH+QV',0,'2D5ECEASF48H','hpdi_bizdatarecord',' ');
