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.