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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: