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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: