KNTA_NOTIFICATIONS_TEMP
This table stores information about email notifications that are triggered by database events.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_NOTIFICATION_TYPES |
NOTIFICATION_TYPE_ID |
NOTIFICATION_TYPE_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
SOURCE_KEY_ID |
KCRT_REQUEST_DETAILS |
REQUEST_ID |
DETAIL_GROUP_ID |
KDLV_PACKAGE_LINES |
PACKAGE_LINE_ID |
DETAIL_GROUP_ID |
KNTA_REPORT_SUBMISSIONS |
REPORT_SUBMISSION_ID |
PARENT_GROUP_ID |
KCRT_REQUESTS |
REQUEST_ID |
PARENT_GROUP_ID |
KDLV_PACKAGES |
PACKAGE_ID |
PARENT_GROUP_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
SOURCE_KEY_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
NOTIFICATION_TEMP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
SESSION_ID |
NOT NULL |
NUMBER |
database session ID |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
NOTIFICATION_TYPE_ID |
NOT NULL |
NUMBER |
Foreign key to the notification type |
CONDITION_VALUE |
NULLABLE |
VARCHAR2(80) |
Value that the condition SQL evaluates to or the value in the condition_column |
CONDITION_SQL_EXISTS_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag that determines if there is SQL code in the CONDITION_SQL column in KNTA_NOTIFICATIONS_TYPES |
EVENT_COLUMN |
NULLABLE |
VARCHAR2(30) |
EVENT_COLUMN in the TABLE_NAME specified in KNTA_NOTIFICATION_TYPES |
OLD_EVENT_VALUE |
NULLABLE |
VARCHAR2(200) |
Value in the column (specified in EVENT_COLUMN) before it changed. |
NEW_EVENT_VALUE |
NULLABLE |
VARCHAR2(200) |
Value in the column (specified in EVENT_COLUMN) after it changed |
VISIBLE_EVENT_COLUMN |
NULLABLE |
VARCHAR2(30) |
VISIBLE_EVENT_COLUMN in the TABLE_NAME specified in KNTA_NOTIFICATION_TYPES |
OLD_VISIBLE_EVENT_VALUE |
NULLABLE |
VARCHAR2(200) |
Visible value of the old event value |
NEW_VISIBLE_EVENT_VALUE |
NULLABLE |
VARCHAR2(200) |
Visible value of the new event value |
PARENT_GROUP_ID |
NULLABLE |
NUMBER |
FK to the parent table. The parent table is LCRT_ISSUES, KDLV_REQUESTS or KNTA_REPORT_SUBMISSIONS |
DETAIL_GROUP_ID |
NULLABLE |
NUMBER |
FK to the detail table. The detail table is KDLV_REQUEST_LINES or KCRT_ISSUES_DETAILS |
SOURCE_KEY_ID |
NULLABLE |
NUMBER |
Primary key of the row of the table that triggered the event. |
PARAMETER_SET_FIELD_ID |
NULLABLE |
NUMBER |
Identifier of the field in the header type that the notification is tied to |
SUBMISSION_NOTIF_FLAG |
NOT NULL |
VARCHAR2(1) |
Flag to determine whether to send the notification on submit |
CONTEXT1-40 |
NULLABLE |
VARCHAR2(300) |
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. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KNTA_NOTIFICATIONS_TEMP_N1 |
NONUNIQUE |
1 |
NOTIFICATION_TYPE_ID |
KNTA_NOTIFICATIONS_TEMP_N2 |
NONUNIQUE |
1 |
SESSION_ID |
KNTA_NOTIFICATIONS_TEMP_U1 |
UNIQUE |
1 |
NOTIFICATION_TEMP_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KNTA_NOTIFICATIONS_TEMP_S |
NOTIFICATION_TEMP_ID |