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.