Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: