RPT_DIM_REQ_DTL_CUSTOM_PARAMS

This table holds detail custom parameters for request entity.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

Request ID of the request

REQUEST_TYPE_ID

NOT NULL

NUMBER

The request type ID for this request

BATCH_NUMBER

NOT NULL

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 this request type

PARAMETER1-40

NULLABLE

VARCHAR2(200)

Value of custom detail parameters used by the customer for this request

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

Visible value of custom detail parameters used by the customer for this request

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Value of custom detail parameters used by the customer for this request

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

Visible value of custom detail parameters used by the customer for this request

Indexes

Index Name

Index Type

Sequence

Column Name

RPT_REQ_DTL_CSTM_PARAMS_N1

NONUNIQUE

1

REQUEST_ID

RPT_REQ_DTL_CSTM_PARAMS_N2

NONUNIQUE

1

REQUEST_TYPE_ID

Sequences

This table uses no sequences.