RPT_DIM_PM_PROJ_SETTINGS_MV

This is a materialized view representing the Project Setting dimension in the Star schema.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

PROJECT_ID

NOT NULL

NUMBER

Unique identifier of a project derived from PPM PM_PROJECTS table

CE_ERE

NULLABLE

NUMBER

It provides Estimated Remaining Effort setting for the project. Value is 1 if checkbox is checked in PPM, otherwise 0

CE_USETM

NULLABLE

NUMBER

It provides Use TM setting for the project. Value is 1 if checkbox is checked in PPM, otherwise 0

Indexes

Index Name

Index Type

Sequence

Column Name

I_SNAP$_RPT_DIM_PM_PROJ_SE

UNIQUE

1

SYS_NC00004$

Sequences

This table uses no sequences.