RPT_FCT_PM_TASK_ASSIGNMENTS

This table stores the actual effort, assigned schedule effort and estimated remaining effort information of tasks by individual resource level.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

ASSIGNMENT_ID

NOT NULL

NUMBER

System-generated identifier by the sequence RPT_FCT_PM_TASK_ASSIGNMENT_S

PROJECT_ID

NOT NULL

NUMBER

ID of the project to which all these assignment records belong to

WORK_PLAN_ID

NOT NULL

NUMBER

ID of the workplan to which all these assignment records belong to

TASK_ID

NOT NULL

NUMBER

ID of the task to which all these assignment records belong to

ACT_REGION_ID

NULLABLE

NUMBER

ID of the region the actual effort is associated with. This is derived from the resource's region ID if the actual effort is logged by an assigned resource or contributor. If the actual effort is logged with null resource ID, the region is derived from Project's region ID

SCHED_REGION_ID

NULLABLE

NUMBER

Project's region ID to which the scheduled effort belongs to

ROLE_ID

NULLABLE

NUMBER

ID of the role associated with task (if any), otherwise the primary role of the assigned resource. This can be null when neither task has a role assigned to it or the assigned resource does not have a primary role configured.

RESOURCE_ID

NULLABLE

NUMBER

The resource against whom the efforts are assigned/logged. Resource ID can be null.

ACT_START_DATE

NULLABLE

DATE

Actual start date of the task by this resource

ACT_FINISH_DATE

NULLABLE

DATE

Actual finish date of the task by this resource

ACT_DURATION

NULLABLE

FLOAT

Actual duration is number of days to complete this task

ACT_EFFORT

NULLABLE

FLOAT

Actual number of hours for this task by this resource

SCHED_EFFORT

NULLABLE

FLOAT

The scheduled effort in hours for this task and this resource. Scheduled effort is null when the resource ID is null

EST_FINISH_DATE

NULLABLE

DATE

The estimated finish date of this task for this resource

EST_REM_EFFORT

NULLABLE

FLOAT

The estimated remaining effort of this task for this resource

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_FCT_PM_TASK_ASSIGNMENTS_B1

NONUNIQUE

1

PROJECT_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_B2

NONUNIQUE

1

WORK_PLAN_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_B3

NONUNIQUE

1

ACT_REGION_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_B4

NONUNIQUE

1

SCHED_REGION_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_B5

NONUNIQUE

1

ROLE_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_B6

NONUNIQUE

1

RESOURCE_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_N1

NONUNIQUE

1

ASSIGNMENT_ID

RPT_FCT_PM_TASK_ASSIGNMENTS_N2

NONUNIQUE

1

TASK_ID

Sequences

This table uses no sequences.