Share this page

# KCRT_REQ_TYPE_ACTIVITY_LIST

This table stores the list of valid activities for a specific request type. This table is only used when the TM_SETTING_ALL_ACT column in the PPM_RESOURCE_SETTINGS table is set to N.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID
ITG_ACTIVITIES_NLS | ACTIVITY_ID | ACTIVITY_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REQUEST_TYPE_ACTIVITY_ID | NULLABLE | NUMBER | System-generated identifier
REQUEST_TYPE_ID | NULLABLE | NUMBER | Request type ID. Primary key from the KCRT_REQUEST_TYPES_NLS table.
ACTIVITY_ID | NULLABLE | NUMBER | Activity ID. Primary key from the ITG_ACTIVITY_NLS table.

## Indexes

This table does not use any Indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
KCRT_REQ_TYPE_ACTIVITY_LIST_S | REQUEST_TYPE_ACTIVITY_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: