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.