KNTA_NOTIF_TXN_RECIPIENTS

This table stores a list of recipients for each detail. The email addresses have been resolved from tokens, user names, or security groups.

Foreign keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY
KNTA_NOTIF_TXN_DETAILS	NOTIF_TXN_DETAIL_ID	NOTIF_TXN_DETAIL_ID

Back to top

Column descriptions

Column Name	Null?	Data Type	Description
NOTIF_TXN_RECIPIENT_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_DETAIL_ID	NOT NULL	NUMBER	Foreign Key to the KNTA_NOTIF_TXN_DETAILS table
EMAIL_ADDRESS	NOT NULL	VARCHAR2(80)	Email address of the recipient
DISTRIBUTION_TYPE_CODE	NOT NULL	VARCHAR2(30)	Email distribution type such as To, Cc, Bcc
SENT_FLAG	NULLABLE	VARCHAR2 (1)	A flag to indicate whether the chatbot notification was sent.
STATUS	NULLABLE	VARCHAR2 (10)	The status of sending a chatbot notification.
INFO	NULLABLE	VARCHAR2 (1000)	More info for sending a chatbot notification, such as the reason of failure.

Back to top

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_NOTIF_TXN_RECIPIENTS_N1	NONUNIQUE	1	NOTIF_TXN_DETAIL_ID
KNTA_NOTIF_TXN_RECIPIENTS_U1	UNIQUE	1	NOTIF_TXN_RECIPIENT_ID

Back to top

Sequences

Sequence Name	Sequence Type
KNTA_NOTIF_TXN_RECIPIENTS_S	NOTIF_TXN_RECIPIENT_ID

Back to top