---------------------------------------------------------------------------------------------------------------------------APPROVER1_LVL1
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER1_LVL1' ,'MEKORMA_APPROVER1_LVL1','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER1_LVL1' ,'MEKORMA_APPROVER1_LVL1',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER1_LVL1' ,'MEKORMA_APPROVER1_LVL1');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER1_LVL1' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER2_LVL1
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER2_LVL1' ,'MEKORMA_APPROVER2_LVL1','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER2_LVL1' ,'MEKORMA_APPROVER2_LVL1',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER2_LVL1' ,'MEKORMA_APPROVER2_LVL1');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER2_LVL1' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER1_LVL2
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER1_LVL2' ,'MEKORMA_APPROVER1_LVL2','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER1_LVL2' ,'MEKORMA_APPROVER1_LVL2',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER1_LVL2' ,'MEKORMA_APPROVER1_LVL2');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER1_LVL2' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER2_LVL2
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER2_LVL2' ,'MEKORMA_APPROVER2_LVL2','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER2_LVL2' ,'MEKORMA_APPROVER2_LVL2',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER2_LVL2' ,'MEKORMA_APPROVER2_LVL2');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER2_LVL2' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER1_LVL3
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER1_LVL3' ,'MEKORMA_APPROVER1_LVL3','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER1_LVL3' ,'MEKORMA_APPROVER1_LVL3',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER1_LVL3' ,'MEKORMA_APPROVER1_LVL3');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER1_LVL3' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER2_LVL3
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER2_LVL3' ,'MEKORMA_APPROVER2_LVL3','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER2_LVL3' ,'MEKORMA_APPROVER2_LVL3',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER2_LVL3' ,'MEKORMA_APPROVER2_LVL3');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER2_LVL3' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER1_LVL4
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER1_LVL4' ,'MEKORMA_APPROVER1_LVL4','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER1_LVL4' ,'MEKORMA_APPROVER1_LVL4',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER1_LVL4' ,'MEKORMA_APPROVER1_LVL4');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER1_LVL4' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER2_LVL4
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER2_LVL4' ,'MEKORMA_APPROVER2_LVL4','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER2_LVL4' ,'MEKORMA_APPROVER2_LVL4',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER2_LVL4' ,'MEKORMA_APPROVER2_LVL4');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER2_LVL4' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER1_LVL5
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER1_LVL5' ,'MEKORMA_APPROVER1_LVL5','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER1_LVL5' ,'MEKORMA_APPROVER1_LVL5',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER1_LVL5' ,'MEKORMA_APPROVER1_LVL5');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER1_LVL5' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------APPROVER2_LVL5
INSERT INTO SY09000 (SECURITYTASKID,
SECURITYTASKNAME,SECURITYTASKDESC,SECURITYTASKCATEGORY,DEFSECTASK,CRUSRID,CREATDDT,MODIFDT,Workflow_Status,SecurityTaskCatgModified)
VALUES ('MEKORMA_APPROVER2_LVL5' ,'MEKORMA_APPROVER2_LVL5','Mekorma Threshold Security',7,0,'sa','2023-08-13
00:00:00.000','1900-01-01 00:00:00.000',9,0);
INSERT INTO SY09100 (SECURITYROLEID, SECURITYROLENAME,SECROLETYPE,CRUSRID,CREATDDT,MODIFDT,Workflow_Status)
VALUES ('MEKORMA_APPROVER2_LVL5' ,'MEKORMA_APPROVER2_LVL5',2,'sa','2023-08-13 00:00:00.000','1900-01-01
00:00:00.000',9);
INSERT INTO SY10600 (SECURITYROLEID,SECURITYTASKID)
VALUES ('MEKORMA_APPROVER2_LVL5' ,'MEKORMA_APPROVER2_LVL5');
INSERT INTO SY10700 (SECURITYTASKID,DICTID,SECURITYID,SECRESTYPE)
VALUES ('MEKORMA_APPROVER2_LVL5' ,2404,65539,900);
---------------------------------------------------------------------------------------------------------------------------DONE
Mekorma Approval - Two Tier
When both approval tiers are used, then it becomes important to identify which tier that decision point is referring to. This is where added the insert statements create another series of GP Roles that will be used to identify the levels of threshold, and the distinction of which tier one or two, it is referencing. Also requires that there is just a single group of approvers. For example, if the first tier, first threshold level approvers are the same used across all companies and checkbook, and that is true for ALL approval points then the two-tier process is good choice to use.
Warning. This process will insert rows of data into your GP database.
It is advised to first test this process, in a separate instance of SQL with GP Dynamics,
and also to back up your Dynamics system database prior to running this process in production.
Copy the insert statements provided to clipboard, then run in MSSQL Server Manager