---------------------------------------------------------------------------------------------------------------------------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 - Enterprise
In an enterprise, of many companies and or checkbooks, where some or many entities have a unique group of approval stakeholders then it better to create first the core approval logic using the provided SQL scripts, and then add the distinction of company, and or checkbook.
The best way to add the distinction of company, and or checkbook is to use the Threshold ID copy feature.
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