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.