Share this page

# KCRT_REQUEST_DETAILS_INT

This is a child table of KCRT_REQUESTS_INT. The KCRT_REQUEST_DETAILS_INT corresponds to KCRT_REQUEST_DETAILS tables. This table is processed through the java report that calls a PL/SQL package that can be run either from the command line or through the report job scheduler. This allows the user to immediately run the interface while allowing for scheduled processing. PL/SQL package will query this table, validate against appropriate tables and imports into the production tables. It can also release the request, depending on its status, by calling the Workflow APIs.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | PARAMETER_SET_CONTEXT_ID
KCRT_REQUESTS_INT | TRANSACTION_ID | PARENT_TRANSACTION_ID
KCRT_REQUEST_DETAILS | REQUEST_DETAIL_ID | REQUEST_DETAIL_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
GROUP_ID | NOT NULL | NUMBER | System-generated identifier
TRANSACTION_ID | NOT NULL | NUMBER | System-generated record identifier
PARENT_TRANSACTION_ID | NOT NULL | NUMBER | Transaction ID of the parent table being imported
REQUEST_DETAIL_ID | NULLABLE | NUMBER | Refers to the request_detail_id in KCRT_REQUEST_DETAILS table
REQUEST_ID | NULLABLE | NUMBER | Refers to the request_id in KCRT_REQUESTS table
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID used by this request
PARAMETER_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the configurable parameters of the request
BATCH_NUMBER | NULLABLE | NUMBER | Batch number of the request detail where this PARAMETER field is found
PARAMETER1-40 | NULLABLE | VARCHAR2(200) | Request Detail Parameter
VISIBLE_PARAMETER1-40 | NULLABLE | VARCHAR2(200) | Request Detail Parameter
PARAMETER41-50 | NULLABLE | VARCHAR2(4000) | Request Detail Parameter
VISIBLE_PARAMETER41-50 | NULLABLE | VARCHAR2(4000) | Request Detail Parameter
LOOKUP_TYPE1-50 | NULLABLE | VARCHAR2(80) | Refers to the LOOKUP_TYPE in KNTA_LOOKUPS
VALIDATION_TYPE_CODE1-50 | NULLABLE | VARCHAR2(30) | Refers to the VALIDATION_TYPE_CODE in KNTA_VALIDATIONS

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_REQUEST_DETAILS_INT_N1 | NONUNIQUE | 1 | GROUP_ID
KCRT_REQUEST_DETAILS_INT_N1 | NONUNIQUE | 2 | TRANSACTION_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: