Share this page

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

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: