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.