PM_TASK_NS_EXCEPTION_RSCS

This table stores the recipients for the "task has exception" notification.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	NOTIFY_ON_EXCP_RESOURCES
PM_TASK_NOTIFICATION_SETUPS	TASK_NOTIFICATION_SETUP_ID	TASK_NOTIFICATION_SETUP_ID

Column Descriptions

Column Name	Null?	Data Type	Description
TASK_NOTIFICATION_SETUP_ID	NOT NULL	NUMBER	System-generated identifier
NOTIFY_ON_EXCP_RESOURCES	NOT NULL	NUMBER	Identifies the user ID of the recipient. This is a foreign key to the KNTA_USERS table
SEQ	NOT NULL	NUMBER	Specifies the ordering within the list of users

Indexes

Index Name	Index Type	Sequence	Column Name
FKAE0FDA634B3DC8DB_I	NONUNIQUE	1	NOTIFY_ON_EXCP_RESOURCES
SYS_C005201563	UNIQUE	1	TASK_NOTIFICATION_SETUP_ID
SYS_C005201563	UNIQUE	2	SEQ

Sequences

This table uses no sequences.