RPT_DIM_PM_PROJ_ISSUE_MV

This is a materialized view that holds the information of the project issues.

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

Issue Request ID associated with this project

DESCRIPTION

NULLABLE

VARCHAR2(400)

Description if this issue

REQUEST_TYPE_ID

NOT NULL

NUMBER

The request type ID for this issue request

REQUEST_TYPE_NAME

NOT NULL

VARCHAR2(80)

The request type name for this issue request

ENTITY_STATUS

NOT NULL

VARCHAR2(80)

Status (lookup value) of this issue

PRIORITY

NULLABLE

VARCHAR2(150)

Priority (lookup value) of this issue

DEPARTMENT

NULLABLE

VARCHAR2(150)

Department (lookup value) of this issue

APPLICATION

NULLABLE

VARCHAR2(150)

Application (lookup value) of this issue

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 Issue 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 issue

CONTACT_PHONE

NULLABLE

VARCHAR2(30)

Phone number of the contact person of this issue

CONTACT_EMAIL

NULLABLE

VARCHAR2(80)

Email address of the contact person of this issue

ASSIGNED_TO

NULLABLE

VARCHAR2(200)

The person to whom this issue is assigned to

USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_USER_DATA1-20

NULLABLE

VARCHAR2(200)

User data segment

ESCALATION_LEVEL_MEANING

NULLABLE

VARCHAR2(200)

Escalation level, this information is stored at Issue Field Group table

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_DIM_PM_PROJ_ISSUE_MV_N1

NONUNIQUE

1

PROJECT_ID

RPT_DIM_PM_PROJ_ISSUE_MV_N2

NONUNIQUE

1

REQUEST_ID

RPT_DIM_PM_PROJ_ISSUE_MV_N3

NONUNIQUE

1

REQUEST_TYPE_ID

Sequences

This table uses no sequences.