PM_TASK_NS_MS_PARTICIPANTS

This table stores the recipients for the "milestone is complete" 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_C005201570	UNIQUE	1	TASK_NOTIFICATION_SETUP_ID
SYS_C005201570	UNIQUE	2	SEQ

Sequences

This table uses no sequences.