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 |
