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