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.