Share this page
RPT_FCT_RM_RESOURCE_CAPACITY
This is a fact table in reporting Star schema that contains the capacity information of resources in resource pools. The capacity information is stored at day granularity.
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_RM_RSRC_CAP_ID_IDX |
NONUNIQUE |
1 |
CAPACITY_ID |
|
RPT_FCT_RM_RSRC_CPCTY_X01 |
NONUNIQUE |
1 |
RESOURCE_POOL_ID |
|
RPT_FCT_RM_RSRC_CPCTY_X03 |
NONUNIQUE |
1 |
REGION_ID |
|
RPT_FCT_RM_RSRC_CPCTY_X04 |
NONUNIQUE |
1 |
RESOURCE_ID |
|
RPT_FCT_RM_RSRC_CPCTY_X05 |
NONUNIQUE |
1 |
CALENDAR_ID |
|
RPT_FCT_RM_RSRC_CPCTY_X06 |
NONUNIQUE |
1 |
ROLE_ID |
|
RPT_FCT_RSC_CPCTY_ASS_DATE_X1 |
NONUNIQUE |
1 |
ASSIGNMENT_DATE |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
RPT_FCT_RM_RESOURCE_CAPACITY_S |
CAPACITY_ID |
