Share this page
RPT_FCT_RM_RESOURCE_EFFORT
This table stores the actual effort information of a resource in hours, person days and FTE unit pre-aggregated by different period granularity, for example, week, month, quarter, half year or year.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
RESOURCE_EFFORT_ID |
NOT NULL |
NUMBER |
System-generated identifier using RPT_FCT_RM_RESOURCE_EFFORT_S |
|
PERIOD_TYPE |
NULLABLE |
NUMBER |
Indicates whether the period is a week, month, quarter, half year or year. |
|
PERIOD_START_DATE |
NULLABLE |
DATE |
Start date of a period derived from PPM PPM_FISCAL_PERIODS_NLS table. |
|
PERIOD_END_DATE |
NULLABLE |
DATE |
End date of a period derived from PPM PPM_FISCAL_PERIODS_NLS table. |
|
PERIOD_EFFORT_HRS |
NULLABLE |
NUMBER |
Aggregated actual effort information for a period expressed in hours. |
|
PERIOD_EFFORT_PERSON_DAYS |
NULLABLE |
NUMBER |
Aggregated actual effort information for a period expressed in person days. |
|
PERIOD_EFFORT_FTE |
NULLABLE |
NUMBER |
Aggregated actual effort information for a period expressed in FTE. |
| PROGRAM_ID | NULLABLE | NUMBER | ID of the program against which actual effort is logged. It is derived from PPM PM_PROGRAMS table and refers to RPT_DIM_PROGRAMS_MV materialized view |
|
PROJECT_ID |
NULLABLE |
NUMBER |
ID of the project against which actual effort is logged. It is derived from PPM PM_PROJECTS table and refers to RPT_DIM_PROJECTS_MV materialized view. |
|
REQUEST_ID |
NULLABLE |
NUMBER |
ID of the request against which actual effort is logged. It is derived from PPM KCRT_REQUESTS table and refers to RPT_DIM_REQUESTS dimension table. |
|
RESOURCE_ID |
NULLABLE |
NUMBER |
ID of resource derived from PPM RSC_RESOURCES table. This ID refers to RPT_DIM_RM_RESOURCES 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. This represents task's role, if the task against which time logged has role associated otherwise it refers to the resource's primary role. |
|
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. |
|
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. This represents region the resource logging time belongs to. |
|
CALENDAR_ID |
NULLABLE |
NUMBER |
ID of calendar derived from PPM KDRV_CALENDARS table. This represents the resource's regional calendar. |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
RPT_IDX_RM_FCT_EFFRT_CAL_ID |
NONUNIQUE |
1 |
CALENDAR_ID |
|
RPT_IDX_RM_FCT_EFFRT_END_DATE |
NONUNIQUE |
1 |
PERIOD_END_DATE |
|
RPT_IDX_RM_FCT_EFFRT_ID |
NONUNIQUE |
1 |
RESOURCE_EFFORT_ID |
|
RPT_IDX_RM_FCT_EFFRT_PROJ_ID |
NONUNIQUE |
1 |
PROJECT_ID |
|
RPT_IDX_RM_FCT_EFFRT_REGN_ID |
NONUNIQUE |
1 |
REGION_ID |
|
RPT_IDX_RM_FCT_EFFRT_REQ_ID |
NONUNIQUE |
1 |
REQUEST_ID |
|
RPT_IDX_RM_FCT_EFFRT_RESRC_ID |
NONUNIQUE |
1 |
RESOURCE_ID |
|
RPT_IDX_RM_FCT_EFFRT_ROLE_ID |
NONUNIQUE |
1 |
ROLE_ID |
|
RPT_IDX_RM_FCT_EFFRT_RP_ID |
NONUNIQUE |
1 |
RESOURCE_POOL_ID |
|
RPT_IDX_RM_FCT_EFFRT_SP_ID |
NONUNIQUE |
1 |
STAFFING_PROFILE_ID |
|
RPT_IDX_RM_FCT_EFFRT_STRT_DATE |
NONUNIQUE |
1 |
PERIOD_START_DATE |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
RPT_FCT_RM_RESOURCE_EFFORT_S |
RESOURCE_EFFORT_ID |
