RPT_RM_RSC_RP_ENTRIES

This table stores some temporary information needed during RM incremental etl processing. When the delete events happen on PPM RSC_RP_DISTRIBUTION_ENTIRES table, during the incremental etl we track RESOURCE_POOL_ID and resource_id in this table, and later this data is used to delete the combination of the same entries from aggregated fact tables.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

RESOURCE_POOL_ID

NULLABLE

NUMBER

The RESOURCE_POOL_ID with the combination of RESOURCE_ID that are deleted.

RESOURCE_ID

NULLABLE

NUMBER

The RESOURCE_ID with the combination of RESOURCE_POOL_ID that are deleted.

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.