Share this page
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) |
|
|
NOTIFICATION_TYPE_ID |
NOT NULL |
NUMBER |
|
|
CONDITION_VALUE |
NULLABLE |
VARCHAR2(80) |
|
|
EVENT_VALUE |
NULLABLE |
VARCHAR2(80) |
|
|
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 |
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.
