Share this page

# ITG_PENDING_ROLLUPS

This table stores entries that will be used by asynchronous PPM Center services such as the cost rollup service. The entries are deleted once the services successfully 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
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
ROLLUP_TYPE_CODE | NOT NULL | VARCHAR2(255) | Indicates which service this entry is intended for. Possible values are: 'COST' for Cost Rollup 'ACTUAL' for Task Actuals Rollup 'SP_PERIOD_SUM' for Staffing Profile Period Sum
SOURCE_ENTITY_ID | NULLABLE | NUMBER | Indicates the entity (for example, project, budget) creating the entry.
SOURCE_ENTITY_PRIMARY_KEY | NULLABLE | NUMBER | Primary key of the creating entity
TARGET_ENTITY_ID | NULLABLE | NUMBER | Target entity which the entry is intended for.
TARGET_ENTITY_PRIMARY_KEY | NULLABLE | NUMBER | Primary key of the target entity which the entry is intended for.
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
CREATION_DATE | NOT NULL | DATE | Date record was created
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
IN_PROCESS | NULLABLE | VARCHAR2(1) | Indicates if this row is currently being processed by a background service. Possible values: Y, N
ATTEMPT_COUNT | NULLABLE | NUMBER | Times of the Cost Rollup Service attempting to process the pending record
CONDITIONS | NULLABLE | NUMBER | Stores the Cost Rollup Service running condition.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
ITG_PENDING_ROLLUPS_N1 | NONUNIQUE | 1 | SOURCE_ENTITY_ID
ITG_PENDING_ROLLUPS_N2 | NONUNIQUE | 1 | TARGET_ENTITY_ID
SYS_C005201541 | UNIQUE | 1 | PENDING_ROLLUP_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
ITG_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: