RPT_FCT_RM_RSC_DEMAND_AGGR

This is an aggregate table which stores the demand 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

DEMAND_ID

NOT NULL

NUMBER

System-generated identifier using RPT_FCT_RM_RSC_DEMAND_AGGR_S

NUM_WRK_DAYS

NULLABLE

NUMBER

Number of working days in a period for example, week, month, quarter, half year or year

PERIOD_FTE

NULLABLE

NUMBER

Aggregated demand information for a period expressed in FTE.

PERIOD_PERS_DAYS

NULLABLE

NUMBER

Aggregated demand information for a period expressed in person days.

PERIOD_HOURS

NULLABLE

NUMBER

Aggregated demand information for a period expressed in hours.

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

DEMAND_STATUS

NULLABLE

VARCHAR2(200)

Status of demand, can be 'Committed', 'Softbooked' or 'Unmet'

ASSIGNMENT_ID

NULLABLE

NUMBER

ID of resource assignment derived from PPM RSC_RESOURCE_ASSIGNMENT table

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_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.

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_RSC_DEM_AGGR_U1

UNIQUE

1

DEMAND_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X01

NONUNIQUE

1

RESOURCE_POOL_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X02

NONUNIQUE

1

ROLE_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X03

NONUNIQUE

1

REGION_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X04

NONUNIQUE

1

RESOURCE_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X05

NONUNIQUE

1

STAFFING_PROFILE_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X06

NONUNIQUE

1

ASSIGNMENT_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X07

NONUNIQUE

1

DEMAND_STATUS

RPT_FCT_RM_RSRC_DMND_AGGR_X08

NONUNIQUE

1

POSITION_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X09

NONUNIQUE

1

CALENDAR_ID

RPT_FCT_RM_RSRC_DMND_AGGR_X10

NONUNIQUE

1

START_DATE

Sequences

Sequence Name

Sequence Type

RPT_FCT_RM_RSC_DEMAND_AGGR_S

DEMAND_ID