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