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.