Share this page
PPM_NOTIFICATION_RULE_RESULTS
This table stores the results of a notification rule processing.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
PPM_NOTIFICATION_DETAILS |
NOTIF_DETAILS_ID |
NOTIF_DETAILS_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
NOTIFICATION_RULE_RESULT_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
HIB_CLASS |
NOT NULL |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
VERSION |
NOT NULL |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
SOURCE_ID |
NOT NULL |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
SOURCE_ENTITY_ID |
NOT NULL |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
NAME |
NULLABLE |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
SUB_TYPE |
NULLABLE |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
TYPE |
NULLABLE |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
DESCRIPTION |
NULLABLE |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
DETAILS |
NULLABLE |
VARCHAR2(255) |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
NOTIF_DETAILS_ID |
NULLABLE |
NUMBER |
For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update |
|
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 |
Indexes
Index Name | Index Type | Sequence | Column Name |
|---|---|---|---|
PPM_NOTIF_RULE_RESULTS_N1 | NONUNIQUE | 1 | SOURCE_ID |
SYS_C005200733 | UNIQUE | 1 | NOTIF_DETAILS_ID |
SYS_C005201624 | UNIQUE | 1 | NOTIFICATION_RULE_RESULT_ID |
Sequences
This table uses no sequences.
