Share this page

# RPT_FCT_RM_RESOURCE_DEMAND

This is a fact table in reporting Star schema that contains the demand information of positions in staffing profile. The demand information is stored at day granularity.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
DEMAND_ID | NOT NULL | NUMBER | System-generated identifier using RPT_FCT_RM_RESOURCE_DEMAND_S
POSITION_ID | NULLABLE | NUMBER | ID of the position, derived from the PPM RSC_POSITIONS table. This ID refers to the RPT_DIM_RM_POSITIONS materialized view.
RESOURCE_ASSIGNMENT_ID | NULLABLE | NUMBER | ID of resource assignment derived from PPM RSC_RESOURCE_ASSIGNMENT table
RESOURCE_ID | NULLABLE | NUMBER | ID of resource derived from PPM RSC_RESOURCES table. This ID refers to RPT_DIM_RM_RESOURCES materialized view
RESOURCE_POOL_ID | NULLABLE | NUMBER | ID of resource pool derived from PPM RSC_RESOURCE_POOLS table. This ID refers to RPT_DIM_RM_RESOURCEPOOLS materialized view
STAFFING_PROFILE_ID | NULLABLE | NUMBER | ID of staffing profile derived from PPM RSC_STAFFING_PROFILES table. This ID refers to RPT_DIM_RM_STAFF_PROFILES materialized view
ASSIGNMENT_DATE | NULLABLE | DATE | Date against which demand is stored
DEMAND_STATUS | NULLABLE | VARCHAR2(200) | Status of demand, can be 'Committed', 'Softbooked' or 'Unmet'
DEMAND | NULLABLE | NUMBER | Demand of a position expressed in hours
DEMAND_PERS_DAYS | NULLABLE | NUMBER | Demand of a position expressed in person days
ROLE_ID | NULLABLE | NUMBER | ID of role derived from PPM RSC_ROLES_NLS table. This ID refers to RPT_DIM_RM_ROLES materialized view.
REGION_ID | NULLABLE | NUMBER | ID of region derived from PPM KNTA_REGIONS_NLS table. This ID refers to RPT_DIM_RM_REGIONS_MV materialized view.
CALENDAR_ID | NULLABLE | NUMBER | ID of calendar derived from PPM KDRV_CALENDARS table. This represents the resource pool's regional calendar for Softbooked and Committed demand or staffing profile's regional calendar for Unmet demand.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_FCT_RM_DMND_ASS_DATE_X1 | NONUNIQUE | 1 | ASSIGNMENT_DATE
RPT_FCT_RM_RSRC_DMND_ID_IDX | NONUNIQUE | 1 | DEMAND_ID
RPT_FCT_RM_RSRC_DMND_X01 | NONUNIQUE | 1 | RESOURCE_POOL_ID
RPT_FCT_RM_RSRC_DMND_X02 | NONUNIQUE | 1 | ROLE_ID
RPT_FCT_RM_RSRC_DMND_X03 | NONUNIQUE | 1 | REGION_ID
RPT_FCT_RM_RSRC_DMND_X04 | NONUNIQUE | 1 | RESOURCE_ID
RPT_FCT_RM_RSRC_DMND_X05 | NONUNIQUE | 1 | STAFFING_PROFILE_ID
RPT_FCT_RM_RSRC_DMND_X06 | NONUNIQUE | 1 | RESOURCE_ASSIGNMENT_ID
RPT_FCT_RM_RSRC_DMND_X07 | NONUNIQUE | 1 | DEMAND_STATUS
RPT_FCT_RM_RSRC_DMND_X08 | NONUNIQUE | 1 | POSITION_ID
RPT_FCT_RM_RSRC_DMND_X09 | NONUNIQUE | 1 | CALENDAR_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
RPT_FCT_RM_RESOURCE_DEMAND_S | DEMAND_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: