Share this page

# PM_TASK_NOTIFICATION_SETUPS

This table stores the notification definitions for tasks.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KNTA_USERS | USER_ID | CREATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TASK_NOTIFICATION_SETUP_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
NOTIFY_IF_LATE_FLAG | NULLABLE | VARCHAR2(1) | Indicates that a notification should be sent when a task is running late. This column represents a boolean value. The value 'Y' is used for true and 'N' is used for false.
NOTIFY_IF_LATE_BY_DAYS | NULLABLE | NUMBER | Indicates the threshold in days. When the time exceeds this threshold then a notification will be sent.
NOTIFY_IF_LATE_FREQ | NULLABLE | NUMBER | Indicates the frequency with which a notification should be sent as long as the condition for the task running late is met. Currently 3 values are supported: 1 - The notification will be sent once 2 - The notification will be sent daily 3 - The notification will be sent weekly
NOTIFY_ON_EXCEPTION_FLAG | NULLABLE | VARCHAR2(1) | Indicates that a notification should be sent when a task has exceptions. This column represents a boolean value. The value 'Y' is used for true and 'N' is used for false.
NOTIFY_ON_MILESTONE_FLAG | NULLABLE | VARCHAR2(1) | Indicates that a notification should be sent when the milestone is complete. This flag makes sense only for tasks that are milestones.
NOTIFY_RSC_BEFORE_START_FLAG | NULLABLE | VARCHAR2(1) | Indicates that a notification be sent to the resources assigned to the task. This notification will be sent just before a task is about to start.
NOTIFY_RSC_DAYS_BEFORE_START | NULLABLE | NUMBER | Indicates the threshold in days. If the time is equal to or less than this threshold then the notification is triggered.
NOTIFY_RSC_IF_LATE_FLAG | NULLABLE | VARCHAR2(1) | Indicates that a notification should be sent when a task is running late. This notification will be sent to the resources assigned to that task.
NOTIFY_RSC_IF_LATE_FREQ | NULLABLE | NUMBER | Indicates the frequency with which a notification should be sent as long as the condition for the task running late is met. Currently 3 values are supported: 1 - The notification will be sent once 2 - The notification will be sent daily 3 - The notification will be sent weekly
SOURCE | NULLABLE | VARCHAR2(255) | Specifies the source of the information. This information is not validated during an import. For example the name of the third part application.
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(255) | Specifies the type of external update. This should be a specific interface or migrator name.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C005201561 | UNIQUE | 1 | TASK_NOTIFICATION_SETUP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PM_TASK_NOTIFICATION_SETUPS_S | TASK_NOTIFICATION_SETUP_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: