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.