RPT_FCT_RM_RESRCE_CAPACITY_STG

This is a staging table used for holding the changed capacity fact information during incremental ETL process and used to merge the changes to the capacity fact table RPT_FCT_RM_RESOURCE_CAPACITY. This table has the same structure as the RPT_FCT_RM_RESOURCE_CAPACITY table.

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_RSC_CPCTY_ASS_DATE_X2

NONUNIQUE

1

ASSIGNMENT_DATE

RPT_STG_RM_RSRC_CPCTY_X01

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_STG_RM_RSRC_CPCTY_X03

NONUNIQUE

1

REGION_ID

RPT_STG_RM_RSRC_CPCTY_X04

NONUNIQUE

1

RESOURCE_ID

RPT_STG_RM_RSRC_CPCTY_X05

NONUNIQUE

1

CALENDAR_ID

RPT_STG_RM_RSRC_CPCTY_X06

NONUNIQUE

1

ROLE_ID

Sequences

This table uses no sequences.