Share this page

# KCRT_RT_REQUEST_RESOURCES

This table is used for storing the resources assigned to a request.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_FG_SLA | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_ADMIN | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_ASSET | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_APP_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_RESOURCE_REQ | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_PROJECT | REQUEST_ID | REQUEST_ID
KCRT_FG_CMDB_APPLICATION | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_SCOPE_CHANGE | REQUEST_ID | REQUEST_ID
KCRT_FG_PROG_ISSUE | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_TEST_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_PFM_PROPOSAL | REQUEST_ID | REQUEST_ID
KCRT_FG_DEMAND_SCHEDULE | REQUEST_ID | REQUEST_ID
KCRT_FG_MASTER_PROJ_REF | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_PROJECT_STATUS | REQUEST_ID | REQUEST_ID
KCRT_FG_PROJ_RISK | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_QC_DEFECT_INFO | REQUEST_ID | REQUEST_ID
KCRT_FG_WORK_ITEMS | REQUEST_ID | REQUEST_ID
KCRT_REQUESTS | REQUEST_ID | REQUEST_ID
KCRT_FG_CMQC_QC_INSTANCE | REQUEST_ID | REQUEST_ID
KCRT_FG_IMPACT_ANALYSIS | REQUEST_ID | REQUEST_ID
KCRT_REQUEST_RSC_ACTUALS | REQUEST_RSC_ACTUALS_ID | REQUEST_RSC_ACTUALS_ID
RSC_RESOURCE_ROLES | RESOURCE_ID | RESOURCE_ID
RSC_RESOURCES | RESOURCE_ID | RESOURCE_ID
KNTA_I18N_RESOURCES_NLS | RESOURCE_ID | RESOURCE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
RESOURCE_REQUEST_ID | NULLABLE | NUMBER | System-generated identifier
RESOURCE_ID | NULLABLE | NUMBER | For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update
REQUEST_ID | NULLABLE | NUMBER
REQUEST_RSC_ACTUALS_ID | NULLABLE | NUMBER

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_RT_REQUEST_RESOURCES_N1 | NONUNIQUE | 1 | RESOURCE_ID
KCRT_RT_REQUEST_RESOURCES_N2 | NONUNIQUE | 1 | REQUEST_ID
KCRT_RT_REQUEST_RESOURCES_U1 | NONUNIQUE | 1 | RESOURCE_ID
KCRT_RT_REQUEST_RESOURCES_U1 | NONUNIQUE | 2 | REQUEST_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
KCRT_RT_REQUEST_RESOURCES_S | RESOURCE_REQUEST_ID

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: