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.

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