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.