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.