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