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.