Share this page
KNTA_PENDING_ROLLUPS
This table stores a list of entities which need its values to be rolled up. Mainly used for calculations for resource pool rollups, and ties between actuals for Time Management, Project Plans, Budgets, and Staffing Profiles. Rows are deleted after rollup services process them.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
PPM_FISCAL_PERIODS_NLS |
FISCAL_PERIOD_ID |
PERIOD_ID |
|
KNTA_USERS |
USER_ID |
RESOURCE_USER_ID |
|
KNTA_ENTITIES_NLS |
ENTITY_ID |
SOURCE_ENTITY_ID |
|
KNTA_ENTITIES_NLS |
ENTITY_ID |
TARGET_ENTITY_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
PENDING_ROLLUP_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 |
|
SOURCE_ENTITY_ID |
NOT NULL |
NUMBER |
Entity ID of the source triggering the rollup |
|
SOURCE_ENTITY_PRIMARY_KEY |
NOT NULL |
NUMBER |
Primary key of the source triggering the rollup |
|
TARGET_ENTITY_ID |
NULLABLE |
NUMBER |
Entity ID of the target whose values need to be recalculated |
|
TARGET_ENTITY_PRIMARY_KEY |
NULLABLE |
NUMBER |
Primary key of the target whose values need to be recalculated |
|
FISCAL_PERIOD_ID |
NULLABLE |
NUMBER |
Period in which the rollup needs to be recalculated. Can be null. |
|
RESOURCE_USER_ID |
NULLABLE |
NUMBER |
User for which the rollup needs to be recalculated. Can be null. |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KNTA_PENDING_ROLLUPS_N1 |
NONUNIQUE |
1 |
SOURCE_ENTITY_ID |
|
KNTA_PENDING_ROLLUPS_N2 |
NONUNIQUE |
1 |
SOURCE_ENTITY_PRIMARY_KEY |
|
KNTA_PENDING_ROLLUPS_N3 |
NONUNIQUE |
1 |
TARGET_ENTITY_ID |
|
KNTA_PENDING_ROLLUPS_N4 |
NONUNIQUE |
1 |
TARGET_ENTITY_PRIMARY_KEY |
|
KNTA_PENDING_ROLLUPS_U1 |
UNIQUE |
1 |
PENDING_ROLLUP_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KNTA_PENDING_ROLLUPS_S |
PENDING_ROLLUP_ID |
