RPT_RSC_RPDE_DELETES

This is a staging table used in incremental ETL process for storing the delete candidates which will be deleted from the RPT_FCT_RM_RESOURCE_CAPACITY fact table due to changes occurred in the RSC_RP_DISTRIBUTION_ENTRIES table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

CAPACITY_ID

NULLABLE

NUMBER

CAPACITY_ID derived from RPT_FCT_RM_RESOURCE_CAPACITY table

RESOURCE_POOL_ID

NULLABLE

NUMBER

ID of the resource pool derived from RSC_RP_DISTRIBUTION_ENTRIES table

RESOURCE_ID

NULLABLE

NUMBER

ID of the resource derived from RSC_RP_DISTRIBUTION_ENTRIES table

Indexes

This table uses no indexes.

Sequences

This table uses no sequences.