KNTA_NOTIF_TXN_DETAILS

This table stores one row for each request or report submission in the KNTA_NOTIF_TXN_PARENTS table, or one line for each package line that has caused a notification for a package in the KNTA_NOTIF_TXN_PARENTS table. Each detail has one or more recipients.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KDLV_PACKAGE_LINES	PACKAGE_LINE_ID	DETAIL_KEY_ID
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_NOTIF_TXN_PARENTS	NOTIF_TXN_PARENT_ID	NOTIF_TXN_PARENT_ID
KNTA_REPORT_SUBMISSIONS	REPORT_SUBMISSION_ID	SOURCE_KEY_ID
KWFL_STEP_TRANSACTIONS	STEP_TRANSACTION_ID	SOURCE_KEY_ID

Column Descriptions

Column Name	Null?	Data Type	Description
NOTIF_TXN_DETAIL_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
NOTIF_TXN_PARENT_ID	NOT NULL	NUMBER	Foreign Key to KNTA_NOTIF_TXN_PARENTS
DETAIL_KEY_ID	NOT NULL	NUMBER	Foreign Key to the KDLV_PACKAGE_LINES table if notification is for a package. Otherwise value is -1.
SOURCE_KEY_ID	NULLABLE	NUMBER	Foreign key to the table that triggered the event
REMINDER_DATE	NULLABLE	DATE	Date that the reminder should be sent

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_NOTIF_TXN_DETAILS_N1	NONUNIQUE	1	NOTIF_TXN_PARENT_ID
KNTA_NOTIF_TXN_DETAILS_N2	NONUNIQUE	1	REMINDER_DATE
KNTA_NOTIF_TXN_DETAILS_U1	UNIQUE	1	NOTIF_TXN_DETAIL_ID

Sequences

Sequence Name	Sequence Type
KNTA_NOTIF_TXN_DETAILS_S	NOTIF_TXN_DETAIL_ID