RPT_FCT_RM_RSC_CAPACITY_AGGR
This is an aggregate table which stores the capacity information in hours, person days and FTE unit pre-aggregated by different period granularity, for example, week, month, quarter, half year and year.
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_RSC_CAPACITY_AGGR_S sequence |
NUM_WRK_DAYS |
NULLABLE |
NUMBER |
Number of working days in a period for example, week, month, quarter, half year or year |
PERIOD_HOURS |
NULLABLE |
NUMBER |
Aggregated capacity information for a period expressed in hours. |
PERIOD_PERS_DAYS |
NULLABLE |
NUMBER |
Aggregated capacity information for a period expressed in person days. |
PERIOD_FTE |
NULLABLE |
NUMBER |
Aggregated capacity information for a period expressed in FTE. |
PERIOD_TYPE |
NULLABLE |
NUMBER |
Indicates whether the period is a week, month, quarter, half year or year. |
START_DATE |
NULLABLE |
DATE |
Start date of a period derived from PPM PPM_FISCAL_PERIODS_NLS table. |
END_DATE |
NULLABLE |
DATE |
End date of a period derived from PPM PPM_FISCAL_PERIODS_NLS table |
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. |
RESOURCE_ID |
NULLABLE |
NUMBER |
ID of the resource derived from RSC_RESOURCES table. This ID refers to the RESOURCE_ID column in RPT_DIM_RM_RESOURCES materialized view. |
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. |
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. |
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. |
ETL_DATETIME |
NULLABLE |
DATE |
The timestamp when the row was inserted or updated |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_FCT_RM_RSC_CAP_AGGR_U1 |
UNIQUE |
1 |
CAPACITY_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X01 |
NONUNIQUE |
1 |
RESOURCE_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X02 |
NONUNIQUE |
1 |
RESOURCE_POOL_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X03 |
NONUNIQUE |
1 |
ROLE_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X04 |
NONUNIQUE |
1 |
REGION_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X05 |
NONUNIQUE |
1 |
CALENDAR_ID |
RPT_FCT_RM_RSRC_CPCTY_AGGR_X06 |
NONUNIQUE |
1 |
START_DATE |
Sequences
Sequence Name |
Sequence Type |
---|---|
RPT_FCT_RM_RSC_CAPACITY_AGGR_S |
CAPACITY_ID |