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.