RPT_DIM_PM_PROJ_RISK_MV
This is a materialized view that holds the information of the project risks.
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 |
Risk Request ID associated with this project |
DESCRIPTION |
NULLABLE |
VARCHAR2(400) |
Description of this risk |
REQUEST_TYPE_ID |
NOT NULL |
NUMBER |
The request type ID for this risk request |
REQUEST_TYPE_NAME |
NOT NULL |
VARCHAR2(80) |
The request type name for this risk request |
ENTITY_STATUS |
NOT NULL |
VARCHAR2(80) |
Status (lookup value) of this risk |
PRIORITY |
NULLABLE |
VARCHAR2(150) |
Priority (lookup value) of this risk |
DEPARTMENT |
NULLABLE |
VARCHAR2(150) |
Department (lookup value) of this risk |
APPLICATION |
NULLABLE |
VARCHAR2(150) |
Application (lookup value) of this risk |
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 Risk 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 risk |
CONTACT_PHONE |
NULLABLE |
VARCHAR2(30) |
Phone number of the contact person of this risk |
CONTACT_EMAIL |
NULLABLE |
VARCHAR2(80) |
Email address of the contact person of this risk |
ASSIGNED_TO |
NULLABLE |
VARCHAR2(200) |
The person to whom this risk is assigned to |
USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
VISIBLE_USER_DATA1-20 |
NULLABLE |
VARCHAR2(200) |
User data segment |
PROBABILITY_MEANING |
NULLABLE |
VARCHAR2(200) |
Probability (lookup value) of this risk |
RISK_IMPACT_LEVEL_MEANING |
NULLABLE |
VARCHAR2(200) |
Impact level (lookup value) of this risk |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
RPT_DIM_PM_PROJ_RISK_MV_N7 |
NONUNIQUE |
1 |
PROJECT_ID |
RPT_DIM_PM_PROJ_RISK_MV_N8 |
NONUNIQUE |
1 |
REQUEST_ID |
RPT_DIM_PM_PROJ_RISK_MV_N9 |
NONUNIQUE |
1 |
REQUEST_TYPE_ID |
Sequences
This table uses no sequences.