Share this page

# KDRV_ROLLUP_SETUPS

This table stores the Roll-up Setup for roll-up execution, which are derived from Roll-up Methods.

## 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_SETUP_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
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Denote whether this Roll-up Setup should be run when a Task is updated
DESCRIPTION | NULLABLE | VARCHAR2(300) | Free-form description for this Roll-up Setup
ROLLUP_METHOD_ID | NOT NULL | NUMBER | Identifier of the Roll-up Method that this Roll-up Setup is derived from
ROLLUP_ORDER | NOT NULL | NUMBER | Execution order of this Roll-up Setup with respect to the other Roll-up Setups, a lower numbered order gets executed first
PROJECT_COLUMN_NAME | NULLABLE | VARCHAR2(80) | Name of the data column to store the roll-up result in a Project node
TASK_COLUMN_NAME | NULLABLE | VARCHAR2(80) | Name of the data column to read values from Task nodes for computing the roll-up result
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
RESOLVED_UPDATE_SQL | NOT NULL | VARCHAR2(2000) | Sql update statement with Project column name, Task column name and ignored state ID list parameters resolved for executing roll-up computations when a Task is updated

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KDRV_ROLLUP_SETUPS_U1 | UNIQUE | 1 | ROLLUP_SETUP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KDRV_ROLLUP_SETUPS_S | ROLLUP_SETUP_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: