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

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: