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) | 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.
REMINDER_FLAG | NULLABLE | VARCHAR2(1 CHAR) | Reminder flag for sending the notifications.

## 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_N4 | NONUNIQUE | 1 | NOTIFICATION_TYPE_ID
KNTA_NOTIFICATIONS_N4 | NONUNIQUE | 2 | ENABLED_FLAG
KNTA_NOTIFICATIONS_N4 | NONUNIQUE | 3 | SEND_ON_SUBMIT_FLAG
KNTA_NOTIFICATIONS_N4 | NONUNIQUE | 4 | CONDITION_VALUE
KNTA_NOTIFICATIONS_U1 | UNIQUE | 1 | NOTIFICATION_ID
SYS_C00109352451 | UNIQUE | 1 | REFERENCE_CODE

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: