Share this page

# KDRV_ROLLUP_METHODS

This table stores Roll-up Method definitions which allow users to define Rollup Setups from.

## Foreign Keys

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

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ROLLUP_METHOD_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ROLLUP_METHOD_NAME | NOT NULL | VARCHAR2(30) | Name, which users see, representing this Roll-up Method (this row)
PROJECT_FIELD_DATA_TYPE | NOT NULL | VARCHAR2(30) | Data type of the Project field that this Roll-up Method can operate on
TASK_FIELD_DATA_TYPE | NOT NULL | VARCHAR2(30) | Data type of the Task field that this Roll-up Method can operate on
DESCRIPTION | NULLABLE | VARCHAR2(300) | Free-form description explaining the behavior of this Roll-up Method
ROLLUP_METHOD_CLASS_NAME | NOT NULL | VARCHAR2(300) | Name of a java class, including the full package path, that will execute the roll-up computations on the client side Project Plan when a Task is updated
IGNORED_STATE_ID_LIST | NULLABLE | VARCHAR2(300) | List of Project and Task states IDs that the Roll-up Method should use to ignore a Project/Task node if the node's state is in this list, both the java class and the update sql should respect this list
UPDATE_VALUES_SQL | NOT NULL | VARCHAR2(1600) | Parameterized sql update statement for executing roll-up computations when a Task is updated
SYSTEM_FLAG | NOT NULL | VARCHAR2(1) | Denote whether users can derive Roll-up Setups from this Roll-up Method. System Roll-up Methods are not displayed to the end user.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDRV_ROLLUP_METHODS_U1 | UNIQUE | 1 | ROLLUP_METHOD_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KDRV_ROLLUP_METHODS_S | ROLLUP_METHOD_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: