RPT_FCT_PM_AGGR_PROJ_EFFORT

This table stores all the efforts for this project at the project level.

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_PROJ_EFFORT_S

PROJECT_ID

NULLABLE

NUMBER

Unique identifier that identifies this project

WORK_PLAN_ID

NULLABLE

NUMBER

The work plan identifier of this project

ACTUAL_EFFORT

NULLABLE

FLOAT

Actual effort aggregated at the project level

ASSIGNED_SCHEDULED_EFFORT

NULLABLE

FLOAT

Assigned scheduled effort aggregated at the project level

UNASSIGNED_SCHEDULED_EFFORT

NULLABLE

FLOAT

Unassigned scheduled effort aggregated at the project level

ESTIMATED_REMAINING_EFFORT

NULLABLE

FLOAT

The estimated remaining effort aggregated at the project level

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_PM_AGGR_PRJ_EFRT_N1

NONUNIQUE

1

PROJECT_ID

RPT_FCT_PM_AGGR_PRJ_EFRT_N2

NONUNIQUE

1

WORK_PLAN_ID

Sequences

This table uses no sequences.