Share this page

# 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.

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: