RPT_DIM_PM_DTL_CSTPARMS_IRS_MV

This is a materialized view that holds the detail custom parameters for project's issue, risk and scope change entities.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NULLABLE

NUMBER

ID of the request of this issue, risk or scope change entity

REQUEST_TYPE_ID

NULLABLE

NUMBER

Request type ID for issue, risk or scope change

BATCH_NUMBER

NULLABLE

NUMBER

This column is used when the custom parameters are more than 50 and the 50 columns provided in the table is insufficient. This corresponds to the PPM table's batch number. For example, if the BATCH_NUMBER is 2 and the parameter number is 4, it is considered as parameter 54.

REQUEST_TYPE_NAME

NULLABLE

VARCHAR2(80)

Name of the request type for issue, risk or scope change request

PARAMETER1-40

NULLABLE

VARCHAR2(200)

Value of custom detail parameters used by the customer for issue, risk or scope change request

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

Visible value of custom detail parameters used by the customer for issue, risk or scope change request.

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Value of custom detail parameters used by the customer for issue, risk or scope change request.

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Visible value of custom detail parameters used by the customer for issue, risk or scope change request.

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_PM_DTL_CSTPARMS_IRS_MV_N14

NONUNIQUE

1

REQUEST_ID

RPT_PM_DTL_CSTPARMS_IRS_MV_N15

NONUNIQUE

1

REQUEST_TYPE_ID

Sequences

This table uses no sequences.