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.