PM_TASK_NS_EXCEPTION_GROUPS
This table stores the recipients for the task has exception notification. The recipients are a list of security groups.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
PM_TASK_NOTIFICATION_SETUPS |
TASK_NOTIFICATION_SETUP_ID |
TASK_NOTIFICATION_SETUP_ID |
KNTA_SECURITY_GROUPS_NLS |
SECURITY_GROUP_ID |
NOTIFY_ON_EXCP_SGS |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
TASK_NOTIFICATION_SETUP_ID |
NOT NULL |
NUMBER |
System-generated identifier |
NOTIFY_ON_EXCP_SGS |
NOT NULL |
NUMBER |
Identifies the security group. This column is a foreign key to the KNTA_SECURITY_GROUPS table |
SEQ |
NOT NULL |
NUMBER |
Specifies the ordering within the list |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
FK56B4F146729B8029_I |
NONUNIQUE |
1 |
NOTIFY_ON_EXCP_SGS |
SYS_C005201562 |
UNIQUE |
1 |
TASK_NOTIFICATION_SETUP_ID |
SYS_C005201562 |
UNIQUE |
2 |
SEQ |
Sequences
This table uses no sequences.