Share this page

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

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: