Share this page

# RPT_FCT_PM_TASK_UNASSGN_EFFORT

This table stores the unassigned scheduled effort at the task level without aggregation. There is a column RESOURCE_ID, which always contains NULL value and acts as a dummy column to help align this fact table with all other effort information facts which are available at the resource granularity.

## 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_TASK_UNASG_EFRT_S
PROJECT_ID | NULLABLE | NUMBER | ID of a PPM project
WORK_PLAN_ID | NULLABLE | NUMBER | ID of a work plan of a project
TASK_ID | NULLABLE | NUMBER | ID of a task of a work plan
REGION_ID | NULLABLE | NUMBER | ID of the region unassigned scheduled effort is associated with. This is derived from project's region ID.
ROLE_ID | NULLABLE | NUMBER | ID of the task's role (if configured for the task), otherwise NULL
RESOURCE_ID | NULLABLE | NUMBER | This is a dummy column kept for aligning this fact table with all other effort fact information table at resource granularity. It always contains NULL value.
UNASSIGNED_SCHEDULED_EFFORT | NULLABLE | FLOAT | Unassigned effort in hours

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_FCT_PM_TASK_UNASSG_EFRT_N1 | NONUNIQUE | 1 | TASK_ID
RPT_FCT_PM_TASK_UNASSG_EFRT_N2 | NONUNIQUE | 1 | PROJECT_ID
RPT_FCT_PM_TASK_UNASSG_EFRT_N3 | NONUNIQUE | 1 | WORK_PLAN_ID
RPT_FCT_PM_TASK_UNASSG_EFRT_N4 | NONUNIQUE | 1 | REGION_ID
RPT_FCT_PM_TASK_UNASSG_EFRT_N5 | NONUNIQUE | 1 | ROLE_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: