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.