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 |