Share this page

# KNTA_NOTIFICATION_TYPES

This table stores the definition for each type of notification provided in PPM Center. The table stores default values as well as corresponding lookup values used in PPM Center to build the user defined notifications.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_ENTITY_GROUPS_NLS | ENTITY_GROUP_ID | DETAIL_ENTITY_GROUP_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_ENTITY_GROUPS_NLS | ENTITY_GROUP_ID | PARENT_ENTITY_GROUP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
NOTIFICATION_TYPE_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
NOTIFICATION_TYPE_NAME | NOT NULL | VARCHAR2(80) | Name of notification type
DESCRIPTION | NULLABLE | VARCHAR2(240) | Description of notification type
TABLE_NAME | NOT NULL | VARCHAR2(30) | Table that will trigger the notification to be sent. Will be either KWFL_STEP_TRANSACTIONS or KNTA_REPORT_SUBMISSIONS
CONDITION_COLUMN | NOT NULL | VARCHAR2(30) | Name of the column in the TABLE_NAME that could trigger a notification
CONDITION_SQL | NULLABLE | VARCHAR2(2000) | SQL run whose result is put in condition_value in KNTA_NOTIFICATIONS_TEMP
EVENT_COLUMN | NULLABLE | VARCHAR2(30) | A secondary column in the TABLE_NAME to further define a notification - this is the code for the status of the WF step or report submission.
VISIBLE_EVENT_COLUMN | NULLABLE | VARCHAR2(30) | Name of the column in TABLE_NAME with the visible value of the event
PARENT_GROUP_COLUMN | NULLABLE | VARCHAR2(30) | Name of the column in TABLE_NAME that is the ID of the entity to which the TABLE_NAME belongs
DETAIL_GROUP_COLUMN | NULLABLE | VARCHAR2(30) | Name of the column in TABLE_NAME (KWFL_TRANSACTION_STEPS) that is the ID of the detail entity using the workflow.
ON_INSERT_FLAG | NOT NULL | VARCHAR2(1) | Determines whether an insert in TABLE_NAME will trigger a notification
ON_UPDATE_FLAG | NOT NULL | VARCHAR2(1) | Determines whether an update to TABLE_NAME will trigger a notification
ON_DELETE_FLAG | NOT NULL | VARCHAR2(1) | Determines whether a delete to TABLE_NAME will trigger a notification
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Determine if this notification type may be used to define notifications
PARENT_ENTITY_GROUP_ID | NULLABLE | NUMBER | Entity group identifier for the header message
DETAIL_ENTITY_GROUP_ID | NULLABLE | NUMBER | Entity group identifier for the detail message

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KNTA_NOTIFICATION_TYPES_U1 | UNIQUE | 1 | NOTIFICATION_TYPE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KNTA_NOTIFICATION_TYPES_S | NOTIFICATION_TYPE_ID

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: