RPT_FCT_RM_RESRCE_CAPACITY_STG
This is a staging table used for holding the changed capacity fact information during incremental ETL process and used to merge the changes to the capacity fact table RPT_FCT_RM_RESOURCE_CAPACITY. This table has the same structure as the RPT_FCT_RM_RESOURCE_CAPACITY table.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
CAPACITY_ID |
NOT NULL |
NUMBER |
System-generated identifier using RPT_FCT_RM_RESOURCE_CAPACITY_S sequence |
RESOURCE_POOL_ID |
NULLABLE |
NUMBER |
ID of the resource pool the capacity information belongs to, derived from PPM RSC_RESOURCE_POOLS table. This ID refers to the RESOURCE_POOL_ID column in RPT_DIM_RM_RESOURCEPOOLS materialized view. |
CAPACITY |
NULLABLE |
NUMBER |
Capacity of a resource expressed in hours. |
CAPACITY_PERS_DAYS |
NULLABLE |
NUMBER |
Capacity of a resource expressed in person days. |
CALENDAR_ID |
NULLABLE |
NUMBER |
ID of the resource's regional calendar for capacity of named resources and ID of the resource pool's regional calendar for capacity of unnamed resources. This ID is derived from PPM KDRV_CALENDARS table. |
ROLE_ID |
NULLABLE |
NUMBER |
ID of the resource's primary role derived from PPM RSC_ROLES_NLS table. This ID refers to the ROLE_ID column in RPT_DIM_RM_ROLES materialized view |
REGION_ID |
NULLABLE |
NUMBER |
ID of the region the resource pool belongs to derived from PPM KNTA_REGIONS_NLS table. This ID refers to the REGION_ID column of RPT_DIM_REGIONS_MV materialized view |
ASSIGNMENT_DATE |
NULLABLE |
DATE |
Date against which capacity of a resource is stored. |
RESOURCE_ID |
NULLABLE |
VARCHAR2(260) |
ID of the resource derived from RSC_RESOURCES table. This ID refers to the RESOURCE_ID column in RPT_DIM_RM_RESOURCES materialized view. |
STAFFING_PROFILE_ID |
NULLABLE |
NUMBER |
ID of the Staffing profile. This column always has the value -1. It is used for querying resource capacity and resource demand fact together against the staffing profile dimension. |
DATA_ORIGIN |
NULLABLE |
VARCHAR2(256) |
This column indicates whether the capacity information was populated in this table during FULL ETL process or incremental ETL process. |
ETL_DATETIME |
NULLABLE |
DATE |
The timestamp when the row was inserted or updated |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_FCT_RSC_CPCTY_ASS_DATE_X2 |
NONUNIQUE |
1 |
ASSIGNMENT_DATE |
RPT_STG_RM_RSRC_CPCTY_X01 |
NONUNIQUE |
1 |
RESOURCE_POOL_ID |
RPT_STG_RM_RSRC_CPCTY_X03 |
NONUNIQUE |
1 |
REGION_ID |
RPT_STG_RM_RSRC_CPCTY_X04 |
NONUNIQUE |
1 |
RESOURCE_ID |
RPT_STG_RM_RSRC_CPCTY_X05 |
NONUNIQUE |
1 |
CALENDAR_ID |
RPT_STG_RM_RSRC_CPCTY_X06 |
NONUNIQUE |
1 |
ROLE_ID |
Sequences
This table uses no sequences.