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.