RPT_FCT_RM_RESOURCE_DEMAND_STG

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

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 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_X2

NONUNIQUE

1

ASSIGNMENT_DATE

RPT_STG_RM_RSRC_DMND_X01

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_STG_RM_RSRC_DMND_X02

NONUNIQUE

1

ROLE_ID

RPT_STG_RM_RSRC_DMND_X03

NONUNIQUE

1

REGION_ID

RPT_STG_RM_RSRC_DMND_X04

NONUNIQUE

1

RESOURCE_ID

RPT_STG_RM_RSRC_DMND_X05

NONUNIQUE

1

STAFFING_PROFILE_ID

RPT_STG_RM_RSRC_DMND_X06

NONUNIQUE

1

RESOURCE_ASSIGNMENT_ID

RPT_STG_RM_RSRC_DMND_X07

NONUNIQUE

1

DEMAND_STATUS

RPT_STG_RM_RSRC_DMND_X08

NONUNIQUE

1

POSITION_ID

RPT_STG_RM_RSRC_DMND_X09

NONUNIQUE

1

CALENDAR_ID

Sequences

This table uses no sequences.