RPT_DIM_PM_PROJ_SCPCHG_MV

This is a materialized view that holds the information of the project Scope Change.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name	Null?	Data Type	Description
PROJECT_ID	NULLABLE	NUMBER	ID that identifies the project
REQUEST_ID	NOT NULL	NUMBER	Scope Change Request ID associated with this project
REQUEST_TYPE_ID	NOT NULL	NUMBER	The request type ID for this scope change request
REQUEST_TYPE_NAME	NOT NULL	VARCHAR2(80)	The request type name for this scope change request
DESCRIPTION	NULLABLE	VARCHAR2(400)	Description if this scope change
ENTITY_STATUS	NOT NULL	VARCHAR2(80)	Status (lookup value) of this scope change
PRIORITY	NULLABLE	VARCHAR2(150)	Priority (lookup value) of this scope change
DEPARTMENT	NULLABLE	VARCHAR2(150)	Department (lookup value) of this scope change
APPLICATION	NULLABLE	VARCHAR2(150)	Application (lookup value) of this scope change
WORKFLOW_NAME	NOT NULL	VARCHAR2(150)	This is the request workflow name
ACTIVE_WORKFLOW_STEP_NAME	NULLABLE	VARCHAR2(4000)	Name of the current active step(s) available in the workflow associated with the Scope Change request
CREATED_BY	NULLABLE	VARCHAR2(200)	Identifier for the user who created the record
CREATION_DATE	NOT NULL	DATE	Date record was created
CONTACT_NAME	NULLABLE	VARCHAR2(200)	Full name of the contact person of this scope change
CONTACT_PHONE	NULLABLE	VARCHAR2(30)	Phone number of the contact person of this scope change
CONTACT_EMAIL	NULLABLE	VARCHAR2(80)	Email address of the contact person of this scope change
ASSIGNED_TO	NULLABLE	VARCHAR2(200)	The person to whom this scope change is assigned to
USER_DATA1-20	NULLABLE	VARCHAR2(200)	User data segment
VISIBLE_USER_DATA1-20	NULLABLE	VARCHAR2(200)	User data segment
IMPACT_SEVERITY_MEANING	NULLABLE	VARCHAR2(200)	Impact severity (lookup value) of this scope change
CR_LEVEL_MEANING	NULLABLE	VARCHAR2(200)	CR Level (lookup value) of this scope change

Indexes

Index Name	Index Type	Sequence	Column Name
RPT_DIM_PM_PROJ_SCPCHG_MV_N4	NONUNIQUE	1	PROJECT_ID
RPT_DIM_PM_PROJ_SCPCHG_MV_N5	NONUNIQUE	1	REQUEST_ID
RPT_DIM_PM_PROJ_SCPCHG_MV_N6	NONUNIQUE	1	REQUEST_TYPE_ID

Sequences

This table uses no sequences.