Share this page

# RPT_FCT_PM_AGGR_TASK_EFFORT

This table stores the effort information in a workplan aggregated by task hierarchy. Effort information at a summary task level is an aggregated value of all tasks below it in the hierarchy and its own value (if there is any). At leaf task level effort information is non aggregated.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
EFFORT_ID | NOT NULL | NUMBER | System-generated identifier by the sequence RPT_FCT_PM_AGGR_TASK_EFFORT_S
TASK_ID | NULLABLE | NUMBER | Unique identifier of the task in a project
PROJECT_ID | NULLABLE | NUMBER | ID that identifies the project to which this task belongs to
WORK_PLAN_ID | NULLABLE | NUMBER | ID that identifies the workplan to which this task belongs to
ACTUAL_EFFORT | NULLABLE | FLOAT | Actual effort aggregated at the task level according to task hierarchy. For leaf task the effort information is non aggregated value
ASSIGNED_SCHEDULED_EFFORT | NULLABLE | FLOAT | Assigned scheduled effort aggregated at the task level according to task hierarchy. For leaf task the effort information is non aggregated value.
UNASSIGNED_SCHEDULED_EFFORT | NULLABLE | FLOAT | Unassigned scheduled effort aggregated at the task level according to task hierarchy. For leaf task the effort information is non aggregated value.
ESTIMATED_REMAINING_EFFORT | NULLABLE | FLOAT | The estimated remaining effort aggregated at the task level according to task hierarchy. For leaf task the effort information is non aggregated value.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_FCT_PM_AGGR_TASK_EFRT_N1 | NONUNIQUE | 1 | PROJECT_ID
RPT_FCT_PM_AGGR_TASK_EFRT_N2 | NONUNIQUE | 1 | WORK_PLAN_ID
RPT_FCT_PM_AGGR_TASK_EFRT_N3 | NONUNIQUE | 1 | TASK_ID

## Sequences

This table uses no sequences.

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: