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