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