PM_TASK_NS_EXCP_PARTICIPANTS

This table stores the recipients for the "task has exception" notification. The recipients are the members of the chosen participant group(s).

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

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_IF_LATE_PARTICIPANTS

NULLABLE

NUMBER

Indicates the participant group. The value is an integer and represents the following: 1 - Stakeholders 2 - Project Managers 4 - Summary Task owners

SEQ

NOT NULL

NUMBER

Specifies the ordering within the list of participants

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201564

UNIQUE

1

TASK_NOTIFICATION_SETUP_ID

SYS_C005201564

UNIQUE

2

SEQ

Sequences

This table uses no sequences.