PM_EXCEPTION_RULE_RESULTS

This table stores the results of the rule evaluations performed on a task

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

WP_TASKS

TASK_ID

NEW_TASK_ID

WP_TASKS

TASK_ID

TARGET_TASK_ID

Column Descriptions

Column Name

Null?

Data Type

Description

EXCEPTION_RULE_RESULT_ID

NOT NULL

NUMBER

System-generated identifier.

HIB_CLASS

NOT NULL

VARCHAR2(255)

Classifies the exceptions into two types: Base and MT. The Base exceptions are simple exceptions, which means you need to evaluate only one task to create this exception. Whereas the MT refers to Multi-Task, this means that multiple tasks need to be evaluated to create a single exception.

VERSION

NOT NULL

NUMBER

System-generated version for the entity. Do not update this column manually.

NEW_TASK_ID

NOT NULL

NUMBER

Identifies the task that has this exception. This is a foreign key to the TASK_ID column in the WP_TASKS table

EXCEPTION_NAME

NULLABLE

VARCHAR2(255)

Name of the exception.

EXCEPTION_SUB_TYPE

NULLABLE

VARCHAR2(255)

Further classification of the exception type. For example, SCHEDULE and COST.

EXCEPTION_TYPE

NULLABLE

VARCHAR2(255)

Indicates the type of the exception. Currently the values EXCEPTION and NOTIFICATION are supported. The notification results are moved to a different table starting from PPM 7.5.

AFFECTS_SCHEDULE_HEALTH

NULLABLE

NUMBER

Indicates whether this exception influences the health calculation.

DESCRIPTION_TYPE

NULLABLE

VARCHAR2(255)

The description for the exception.

DETAILS

NULLABLE

VARCHAR2(255)

A place where additional information can be stored.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record.

CREATION_DATE

NOT NULL

DATE

The date when the record was created.

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record.

LAST_UPDATE_DATE

NOT NULL

DATE

The date when the record was last updated.

TARGET_TASK_ID

NULLABLE

NUMBER

Some exceptions (for example, predecessor/external predecessor has exception) can be created on the summary tasks. But according to the functional design only a leaf task can be associated with an exception. So this column is used to refer to the summary task. The leaf task is then referenced from the NEW_TASK_ID column.

Indexes

Index Name

Index Type

Sequence

Column Name

FKC9BDF4258A8A928_I

NONUNIQUE

1

TARGET_TASK_ID

FKC9BDF425B2766237_I

NONUNIQUE

1

NEW_TASK_ID
PM_EXCEPTION_IDX_1 NONUNIQUE   EXCEPTION_TYPE

SYS_C005201550

UNIQUE

1

EXCEPTION_RULE_RESULT_ID

Sequences

Sequence Name

Sequence Type

PM_EXCEPTION_RULE_RESULTS_S

EXCEPTION_RULE_RESULT_ID