KNTA_NOTIFICATIONS

This table stores the definition of each notification created by the user. These notifications are used as a template to create the actual email notifications that are triggered by events in PPM Center. For example, the Workflow Step Notification is triggered to create an email by a change in the workflow step and status for a package line. For DM and DpM notification types, the CONDITION_VALUE maps to the workflow_step and the EVENT_VALUE maps to the status.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_NOTIF_INTERVALS_NLS	INTERVAL_ID	INTERVAL_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_NOTIFICATION_COLUMNS	NOTIFICATION_COLUMN_ID	NOTIFICATION_COLUMN_ID
KNTA_NOTIFICATIONS_NLS	NOTIFICATION_ID	NOTIFICATION_SET_ID
KNTA_NOTIFICATION_TYPES	NOTIFICATION_TYPE_ID	NOTIFICATION_TYPE_ID
KNTA_NOTIF_TYPE_MESSAGES	NOTIF_TYPE_MESSAGE_ID	NOTIF_TYPE_MESSAGE_ID
KRML_PARAMETER_SET_FLDS_COPY	PARAMETER_SET_FIELD_ID	PARAMETER_SET_FIELD_ID
KNTA_PARAM_SET_FIELDS_NLS	PARAMETER_SET_FIELD_ID	PARAMETER_SET_FIELD_ID

Column Descriptions

Column Name	Null?	Data Type	Description
NOTIFICATION_ID	NOT NULL	NUMBER	System-generated identifier
CREATED_BY	NOT NULL	NUMBER	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
LAST_UPDATED_BY	NOT NULL	NUMBER	Identifier for the user who last updated the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
ENTITY_LAST_UPDATE_DATE	NOT NULL	DATE	Date a record in the entity was last updated
DESCRIPTION	NULLABLE	VARCHAR2(240)	Description of the notification.
NOTIFICATION_TYPE_ID	NOT NULL	NUMBER	Type of the notification.
CONDITION_VALUE	NULLABLE	VARCHAR2(80)
EVENT_VALUE	NULLABLE	VARCHAR2(80)	Event for which the notification is triggered.
VISIBLE_EVENT_VALUE	NULLABLE	VARCHAR2(80)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
INTERVAL_ID	NOT NULL	NUMBER
NOTIF_TYPE_MESSAGE_ID	NULLABLE	NUMBER
FROM_RECIPIENT_TYPE_CODE	NULLABLE	VARCHAR2(30)
FROM_TOKEN_TYPE_CODE	NULLABLE	VARCHAR2(30)
FROM_ADDRESS	NULLABLE	VARCHAR2(80)
SUBJECT	NULLABLE	VARCHAR2(240)
REPLY_TO_RECIPIENT_TYPE_CODE	NULLABLE	VARCHAR2(30)
REPLY_TO_TOKEN_TYPE_CODE	NULLABLE	VARCHAR2(30)
REPLY_TO_ADDRESS	NULLABLE	VARCHAR2(80)
CONTENT_TYPE_CODE	NULLABLE	VARCHAR2(30)
PARENT_TEXT	NOT NULL	CLOB
NOTIFICATION_COLUMN_ID	NULLABLE	NUMBER
DELETE_FLAG	NOT NULL	VARCHAR2(1)
REMINDER_DAYS	NULLABLE	NUMBER
NOTIFICATION_SET_ID	NULLABLE	NUMBER
SOURCE_TYPE_CODE	NULLABLE	VARCHAR2(30)
SOURCE	NULLABLE	VARCHAR2(100)
NOTIFICATION_FORMAT_CODE	NOT NULL	VARCHAR2(50)
PARAMETER_SET_FIELD_ID	NULLABLE	NUMBER
SEND_ON_SUBMIT_FLAG	NOT NULL	VARCHAR2(1)
MINUTE_OFFSET	NULLABLE	NUMBER
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)
ENABLE_EMAIL_APPROVALS	NOT NULL	VARCHAR2(1)
ENABLE_CHATBOT_APPROVALS	NOT NULL	VARCHAR2(1)	Flag for decision by Chatbot
INCLUDE_REPORT_AS_ATTACHMENT	NOT NULL	VARCHAR2(1)	When set to Y, the report is sent as an email attachment. When set to N, it is not sent as an email attachment. The fefault value is N.

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_NOTIFICATIONS_N1	NONUNIQUE	1	NOTIFICATION_TYPE_ID
KNTA_NOTIFICATIONS_N2	NONUNIQUE	1	CONDITION_VALUE
KNTA_NOTIFICATIONS_N3	NONUNIQUE	1	NOTIFICATION_SET_ID
KNTA_NOTIFICATIONS_U1	UNIQUE	1	NOTIFICATION_ID
SYS_C00109352451	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.