Share this page
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.
