text: DELIMITER /
  INSERT INTO SEQ_NOTIFICATION_TYPE_ID VALUES(NULL)
  /
  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 ((SELECT (MAX(ID)) FROM SEQ_NOTIFICATION_TYPE_ID), (SELECT MODULE_CODE FROM COEUS_MODULE WHERE DESCRIPTION='IRB'), 301, 'Protocol Terminated Action', 'Protocol {PROTOCOL_NUMBER} Terminated', 'The IRB protocol number <a title="" target="_self" href="{DOCUMENT_PREFIX}/kew/DocHandler.do?command=displayDocSearchView&amp;docId={DOCUMENT_NUMBER}">{PROTOCOL_NUMBER}</a>, Principal Investigator {PI_NAME} has had the action "Termination" performed on it.<br />The action was executed by {USER_FULLNAME} on {TERMINATION_DATE}. Additional information and further actions can be accessed through the Kuali Coeus system.', 'N', 'N', 'admin', NOW(), 1, UUID())
  /
  INSERT INTO SEQ_NOTIFICATION_TYPE_ID VALUES(NULL)
  /
  INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
  VALUES ((SELECT (MAX(ID)) FROM SEQ_NOTIFICATION_TYPE_ID), (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=301), 'KC-UNT:IRB Administrator', 'admin', NOW(), UUID())
  /
  INSERT INTO SEQ_NOTIFICATION_TYPE_ID VALUES(NULL)
  /
  INSERT INTO NOTIFICATION_TYPE_RECIPIENT (NOTIFICATION_TYPE_RECIPIENT_ID, NOTIFICATION_TYPE_ID, ROLE_NAME, UPDATE_USER, UPDATE_TIMESTAMP, OBJ_ID)
  VALUES ((SELECT (MAX(ID)) FROM SEQ_NOTIFICATION_TYPE_ID), (SELECT NOTIFICATION_TYPE_ID FROM NOTIFICATION_TYPE WHERE ACTION_CODE=301), 'KC-PROTOCOL:PI', 'admin', NOW(), UUID())
  /
  COMMIT
  /
  DELIMITER ;
  