RPT_DIM_PROJECTS_MV
This is a materialized view representing the Project 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 |
NULLABLE |
NUMBER |
Unique identifier of a project derived from PPM PM_PROJECTS table |
REQUEST_ID |
NULLABLE |
NUMBER |
ID of the request associated with the project |
PROJECT_NAME |
NULLABLE |
VARCHAR2(300) |
Name of the project |
PROJECT_DESCRIPTION |
NULLABLE |
VARCHAR2(650) |
Description of the project |
DIRECT_PORTFOLIO_ID | NULLABLE | NUMBER | ID of the portfolio this project directly belongs to |
DIRECT_PORTFOLIO_NAME | NULLABLE | VARCHAR2(1500 CHAR) | Name of the portfolio this project directly belongs to |
REGION_ID |
NULLABLE |
NUMBER |
ID of the associated region with the project |
ASSOCIATED_MSP_PROJECT |
NULLABLE |
VARCHAR2(255) |
The file name and path of the microsoft project if the project is integrated with any MSP file |
PROJECT_MANAGER |
NULLABLE |
VARCHAR2(4000) |
Name of the managers of the project. Names are separated by comma for two or more project managers for the project |
START_DATE_PERIOD |
NULLABLE |
VARCHAR2(100) |
Start period name of the project |
FINISH_DATE_PERIOD |
NULLABLE |
VARCHAR2(100) |
Finish period name of the project |
START_DATE_PERIOD_ID |
NULLABLE |
NUMBER |
ID of the Start period of the project |
FINISH_DATE_PERIOD_ID |
NULLABLE |
NUMBER |
ID of the end period of the project |
PROJECT_TYPE_ID |
NULLABLE |
NUMBER |
ID of the Project type this project is created from. It is derived from PROJECT_TYPE_ID of PPM PM_PROJECT_TYPES table. |
PROJECT_DISPLAY_STATUS |
NULLABLE |
VARCHAR2(255) |
Status of the project |
PROJECT_STATUS |
NULLABLE |
NUMBER |
Internal status code of the project |
PROJECT_ACCESS_ID |
NULLABLE |
NUMBER |
Provides project access control information. It is derived from SECURITY_ENTITY_ID of PPM ITG_SECURABLE_ENTITIES table. |
PROJECT_COST_ACCESS_ID |
NULLABLE |
NUMBER |
Provides project cost access control information. It is derived from SECURITY_ENTITY_ID of ITG_SECURABLE_ENTITIES table. |
PROJECT_CREATED_BY |
NULLABLE |
VARCHAR2(200) |
ID of the user who created the project |
PROJECT_CREATION_DATE |
NULLABLE |
DATE |
Project creation date |
ACTUAL_START_DATE |
NULLABLE |
DATE |
Actual start date of the project |
ACTUAL_FINISH_DATE |
NULLABLE |
DATE |
Actual finish date of the project |
LAST_UPDATE_DATE |
NULLABLE |
DATE |
Date record was last updated |
PROJECT_TYPE_NAME |
NULLABLE |
VARCHAR2(255) |
Name of the project type |
SCHEDULE_HEALTH_INDICATOR |
NULLABLE |
VARCHAR2(255) |
A flag for schedule health of the project |
ISSUE_HEALTH_INDICATOR |
NULLABLE |
VARCHAR2(255) |
A flag for issue health of the project |
COST_HEALTH_INDICATOR |
NULLABLE |
VARCHAR2(255) |
A flag for cost health of the project |
OVERALL_HEALTH_INDICATOR |
NULLABLE |
VARCHAR2(255) |
A flag for overall health of the project |
PERCENT_COMPLETE |
NULLABLE |
FLOAT |
Percent complete |
ACT_DURATION |
NULLABLE |
FLOAT |
Actual duration of the project |
SCHED_DURATION |
NULLABLE |
FLOAT |
Schedule duration of the project |
EST_FINISH_DATE |
NULLABLE |
DATE |
Estimated finish date of the project |
SCHED_START_DATE |
NULLABLE |
DATE |
Scheduled start date of the project |
SCHED_FINISH_DATE |
NULLABLE |
DATE |
Scheduled finish date of the project |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.