<commit_before>INSERT INTO COEUS_MODULE (MODULE_CODE, DESCRIPTION, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
             VALUES (11, 'Committee', SYSDATE, 'admin', 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE (NOTIFICATION_TYPE_ID, MODULE_CODE, ACTION_CODE, DESCRIPTION, SUBJECT, MESSAGE, PROMPT_USER, SEND_NOTIFICATION, UPDATE_USER, UPDATE_TIMESTAMP, VER_NBR, OBJ_ID) 
             VALUES (10070, (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 213, 'Agenda Created Event', 'Agenda created for committee {COMMITTEE_NAME}', 'Agenda created for committee <a title="" target="_self" href="{DOCUMENT_PREFIX}/kew/DocHandler.do?command=displayDocSearchView&amp;docId={DOCUMENT_NUMBER}">{COMMITTEE_NAME}</a>. Date of committee meeting is {LAST_ACTION_DATE}.', 'N', 'Y', 'admin', SYSDATE, 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE (NOTIFICATION_TYPE_ID, MODULE_CODE, ACTION_CODE, DESCRIPTION, SUBJECT, MESSAGE, PROMPT_USER, SEND_NOTIFICATION, UPDATE_USER, UPDATE_TIMESTAMP, VER_NBR, OBJ_ID)
             VALUES (10072, (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 215, 'Minutes Generated Event', 'Minutes generated for committee {COMMITTEE_NAME}', 'Minutes generated for committee <a title="" target="_self" href="{DOCUMENT_PREFIX}/kew/DocHandler.do?command=displayDocSearchView&amp;docId={DOCUMENT_NUMBER}">{COMMITTEE_NAME}</a>. Date of committee meeting is {LAST_ACTION_DATE}.', 'N', 'Y', 'admin', SYSDATE, 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_MODULE_ROLE (NOTIFICATION_MODULE_ROLE_ID, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER, MODULE_CODE, ROLE_NAME)
             VALUES (10031, SYS_GUID(), 1, SYSDATE, 'admin', (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 'KC-COMMITTEE:Committee Administrator')
/
INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
             VALUES (10071, (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=213), 'KC-COMMITTEE:Committee Administrator', 'admin', SYSDATE, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
             VALUES (10073, (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=215), 'KC-COMMITTEE:Committee Administrator', 'admin', SYSDATE, SYS_GUID())
/
INSERT INTO NOTIFICATION_MDL_ROLE_QLFR (NOTIFICATION_MDL_ROLE_QLFR_ID, NOTIFICATION_MODULE_ROLE_ID, QUALIFIER, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER)
	           VALUES (10034, (select NOTIFICATION_MODULE_ROLE_ID from NOTIFICATION_MODULE_ROLE where ROLE_NAME = 'KC-PROTOCOL:Active Committee Member On Protocol'), 'committee', SYS_GUID(), 1, SYSDATE, 'admin')
/
INSERT INTO NOTIFICATION_MDL_ROLE_QLFR (NOTIFICATION_MDL_ROLE_QLFR_ID, NOTIFICATION_MODULE_ROLE_ID, QUALIFIER, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER)
	           VALUES (10035, (select NOTIFICATION_MODULE_ROLE_ID from NOTIFICATION_MODULE_ROLE where ROLE_NAME = 'KC-PROTOCOL:Active Committee Member On Protocol'), 'committeeSchedule', SYS_GUID(), 1, SYSDATE, 'admin')
/<commit_msg>KCIRB-1664: Create Agenda Created notification - table changes to support new roles<commit_after>INSERT INTO COEUS_MODULE (MODULE_CODE, DESCRIPTION, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
             VALUES (11, 'Committee', SYSDATE, 'admin', 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE (NOTIFICATION_TYPE_ID, MODULE_CODE, ACTION_CODE, DESCRIPTION, SUBJECT, MESSAGE, PROMPT_USER, SEND_NOTIFICATION, UPDATE_USER, UPDATE_TIMESTAMP, VER_NBR, OBJ_ID) 
             VALUES (10070, (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 213, 'Agenda Created Event', 'Agenda created for committee {COMMITTEE_NAME}', 'Agenda created for committee <a title="" target="_self" href="{DOCUMENT_PREFIX}/kew/DocHandler.do?command=displayDocSearchView&amp;docId={DOCUMENT_NUMBER}">{COMMITTEE_NAME}</a>. Date of committee meeting is {LAST_ACTION_DATE}.', 'N', 'Y', 'admin', SYSDATE, 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE (NOTIFICATION_TYPE_ID, MODULE_CODE, ACTION_CODE, DESCRIPTION, SUBJECT, MESSAGE, PROMPT_USER, SEND_NOTIFICATION, UPDATE_USER, UPDATE_TIMESTAMP, VER_NBR, OBJ_ID)
             VALUES (10072, (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 215, 'Minutes Generated Event', 'Minutes generated for committee {COMMITTEE_NAME}', 'Minutes generated for committee <a title="" target="_self" href="{DOCUMENT_PREFIX}/kew/DocHandler.do?command=displayDocSearchView&amp;docId={DOCUMENT_NUMBER}">{COMMITTEE_NAME}</a>. Date of committee meeting is {LAST_ACTION_DATE}.', 'N', 'Y', 'admin', SYSDATE, 1, SYS_GUID())
/
INSERT INTO NOTIFICATION_MODULE_ROLE (NOTIFICATION_MODULE_ROLE_ID, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER, MODULE_CODE, ROLE_NAME)
             VALUES (10031, SYS_GUID(), 1, SYSDATE, 'admin', (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='Committee'), 'KC-COMMITTEE:Committee Administrator')
/
INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
             VALUES (10071, (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=213), 'KC-COMMITTEE:Committee Administrator', 'admin', SYSDATE, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
             VALUES (10073, (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=215), 'KC-COMMITTEE:Committee Administrator', 'admin', SYSDATE, SYS_GUID())
/
INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
             VALUES (10074, (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=215), 'KC-PROTOCOL:Active Committee Member On Protocol', 'admin', SYSDATE, SYS_GUID())
/
INSERT INTO NOTIFICATION_MDL_ROLE_QLFR (NOTIFICATION_MDL_ROLE_QLFR_ID, NOTIFICATION_MODULE_ROLE_ID, QUALIFIER, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER)
             VALUES (10034, (select NOTIFICATION_MODULE_ROLE_ID from NOTIFICATION_MODULE_ROLE where ROLE_NAME = 'KC-PROTOCOL:Active Committee Member On Protocol'), 'committee', SYS_GUID(), 1, SYSDATE, 'admin')
/
INSERT INTO NOTIFICATION_MDL_ROLE_QLFR (NOTIFICATION_MDL_ROLE_QLFR_ID, NOTIFICATION_MODULE_ROLE_ID, QUALIFIER, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER)
	         VALUES (10035, (select NOTIFICATION_MODULE_ROLE_ID from NOTIFICATION_MODULE_ROLE where ROLE_NAME = 'KC-PROTOCOL:Active Committee Member On Protocol'), 'committeeSchedule', SYS_GUID(), 1, SYSDATE, 'admin')
/
INSERT INTO KRIM_ROLE_T (ROLE_ID, OBJ_ID, VER_NBR, ROLE_NM, NMSPC_CD, DESC_TXT, KIM_TYP_ID, ACTV_IND, LAST_UPDT_DT)
             VALUES (1006, SYS_GUID(), 1, 'Committee Administrator', 'KC-COMMITTEE', 'Committee Administrator', (SELECT KIM_TYP_ID FROM KRIM_TYP_T WHERE NM='Unit'), 'Y', SYSDATE)
/
INSERT INTO KRIM_ROLE_MBR_T (ROLE_MBR_ID, VER_NBR, OBJ_ID, ROLE_ID, MBR_ID, MBR_TYP_CD, ACTV_FRM_DT, ACTV_TO_DT, LAST_UPDT_DT)
             VALUES (10017, 1, SYS_GUID(), (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE ROLE_NM='Committee Administrator'), '10000000001', 'P', NULL, NULL, SYSDATE)
/
INSERT INTO KRIM_ROLE_MBR_T (ROLE_MBR_ID, VER_NBR, OBJ_ID, ROLE_ID, MBR_ID, MBR_TYP_CD, ACTV_FRM_DT, ACTV_TO_DT, LAST_UPDT_DT)
             VALUES (10112, 1, SYS_GUID(), (SELECT ROLE_ID FROM KRIM_ROLE_T WHERE ROLE_NM='Committee Administrator'), '10000000001', 'P', NULL, NULL, SYSDATE)
/
{'fraction_non_alphanumeric': 0.102088772845953, 'fraction_numerical': 0.02101827676240209, 'mean_word_length': 7.089757127771911, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 2, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2560961', 'n_tokens_mistral': 2945, 'n_tokens_neox': 2712, 'n_words': 608}