Share this page

# 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

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: