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