PM_TASK_NS_LATE_RSCS

This table stores the recipients for the "task running late" notification.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

RESOURCE_USER_ID

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

RESOURCE_USER_ID

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

FK933D2928E34A13C9_I

NONUNIQUE

1

RESOURCE_USER_ID

SYS_C005201567

UNIQUE

1

TASK_NOTIFICATION_SETUP_ID

SYS_C005201567

UNIQUE

2

SEQ

Sequences

This table uses no sequences.