Share this page
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 |
