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