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 according to two types. Base and MT. The Base exceptions are simple exceptions, i.e., we need to evaluate only 1 task to create this exception. Whereas the MT signifies 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. This column must not be updated 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 from 7.5

AFFECTS_SCHEDULE_HEALTH

NULLABLE

NUMBER

Indicates whether this exception influences the health calculation

DESCRIPTION_TYPE

NULLABLE

VARCHAR2(255)

Indicates 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

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

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