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