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