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 |