RPT_DIM_PM_WORKPLAN_MV
This is a materialized view representing work plan dimension in the Star schema.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
WORK_PLAN_ID |
NOT NULL |
NUMBER |
Unique identifier of a work plan derived from PPM PM_PROJECTS table |
PROJECT_ID |
NULLABLE |
NUMBER |
ID of the related project. It is derived from pm_projects table |
ROOT_TASK_ID |
NULLABLE |
NUMBER |
ID of the root task in the work plan |
WORKPLAN_NAME |
NULLABLE |
VARCHAR2(300) |
Name of the work plan |
DESCRIPTION |
NULLABLE |
VARCHAR2(650) |
Description of the work plan. |
CREATED_BY_FIRSTNAME |
NOT NULL |
VARCHAR2(80) |
First name of the user who creates this work plan |
CREATED_BY_LASTNAME |
NOT NULL |
VARCHAR2(80) |
Last name of the user who creates this work plan |
CREATION_DATE |
NOT NULL |
DATE |
Work plan creation date |
IS_BASELINE_FLAG |
NULLABLE |
CHAR |
A flag to indicate if a workplan is a baseline workplan. Value of 'Y' indicates it is a baseline workplan. |
WORKPLAN_SEQ |
NULLABLE |
NUMBER |
Sequence number of the work plan |
IS_ACTIVE_FLAG |
NULLABLE |
VARCHAR2(1) |
A flag to indicate if a workplan is an active baseline work plan. Value of 'Y' indicates it is an active baseline workplan. |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_DIM_PM_WORKPLAN_MV_N10 |
NONUNIQUE |
1 |
WORK_PLAN_ID |
RPT_DIM_PM_WORKPLAN_MV_N11 |
NONUNIQUE |
1 |
PROJECT_ID |
Sequences
This table uses no sequences.