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 |