Share this page

# RPT_DIM_PM_HDR_CSTPARMS_IRS_MV

This is a materialized view that holds the header 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 | Request ID for this issue or risk or scope change request
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 header parameters used by the customer for issue, risk or scope change request
VISIBLE_PARAMETER1-40 | NULLABLE | VARCHAR2(200) | Visible value of custom header parameters used by the customer for issue, risk or scope change request.
PARAMETER41-50 | NULLABLE | VARCHAR2(4000) | Value of custom header parameters used by the customer for issue, risk or scope change request.
VISIBLE_PARAMETER41-50 | NULLABLE | VARCHAR2(4000) | Visible value of custom header parameters used by the customer for issue, risk or scope change request.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_PM_HDR_CSTPARMS_IRS_MV_N12 | NONUNIQUE | 1 | REQUEST_ID
RPT_PM_HDR_CSTPARMS_IRS_MV_N13 | NONUNIQUE | 1 | REQUEST_TYPE_ID

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: