Share this page

# KCRT_REQUEST_TYPES

This table stores all the available request types in the system.

A Request Type is comprised of a collection of Fields. Request types define the following:

a) Custom fields and their layout for a given request;

b) Application statuses and their dependencies to the custom fields;

c) Defaults to be used in the request header section;

d) Set of commands;

e) Sub-Type that is used to further categorize the request type.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KACC_ACCELERATORS_NLS | ACCELERATOR_ID | ACCELERATOR_ID
KNTA_USERS | USER_ID | CREATED_BY
KCRT_STATUSES_NLS | STATUS_ID | INIT_STATUS_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KCRT_REQUEST_HEADER_TYPES_NLS | REQUEST_HEADER_TYPE_ID | REQUEST_HEADER_TYPE_ID
KNTA_PARAMETER_SET_CONTEXTS | PARAMETER_SET_CONTEXT_ID | USER_DATA_SET_CONTEXT_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REQUEST_TYPE_ID | NOT NULL | NUMBER | System-generated identifier
CREATION_DATE | NOT NULL | DATE | Date record was created
CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the record
LAST_UPDATE_DATE | NOT NULL | DATE | Date record was last updated
LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the record
ENTITY_LAST_UPDATE_DATE | NOT NULL | DATE | Date a record in the entity was last updated
REQUEST_TYPE_NAME | NOT NULL | VARCHAR2(80) | Name of the request type
CREATION_ACTION_NAME | NULLABLE | VARCHAR2(80) | Action name for creating this record
REQUEST_HEADER_TYPE_ID | NOT NULL | NUMBER | ID of the request header type
ACCELERATOR_ID | NULLABLE | NUMBER | Accelerator ID
CATEGORY_CODE | NULLABLE | VARCHAR2(30) | Category it belongs to, for example, DM
DESCRIPTION | NULLABLE | VARCHAR2(400) | Description
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Flag to enable or disable this request type
WORKBENCH_ONLY_FLAG | NOT NULL | VARCHAR2(1) | If used only by workbench
MAX_PARAMETER_FIELDS_CODE | NULLABLE | VARCHAR2(30) | Max number of parameters that can be used
MAX_BATCH_NUMBER_USED | NULLABLE | NUMBER | Max batch size
INCLUDE_ALL_WORKFLOWS_FLAG | NOT NULL | VARCHAR2(1) | If all workflows are included
INIT_STATUS_ID | NOT NULL | NUMBER | Initial status
USER_DATA_SET_CONTEXT_ID | NULLABLE | NUMBER | Parameter set context identifier for the user data fields
USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
VISIBLE_USER_DATA1-20 | NULLABLE | VARCHAR2(200) | User data segment
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(30) | Source type if created through interface or externally
SOURCE | NULLABLE | VARCHAR2(100) | Additional information about the source if created externally or through the interface
MDL_VIEW_NAME_ROOT | NULLABLE | VARCHAR2(20) | Model view name
SHOW_FIELD_HELP_FLAG | NOT NULL | VARCHAR2(1) | Show field help
DEFINITION_LANGUAGE | NOT NULL | VARCHAR2(40) | Language in which the record was created
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Reference code to uniquely identify the record across systems
DASHBOARD_ENABLED_FLAG | NOT NULL | VARCHAR2 (1 Char) | Flag to enable or disable the dashboard in the request type
ENABLED_COPY_REQUEST_FLAG | NOT NULL | VARCHAR2 (1 Char) | Flag to enable or disable the copy request button in request detail page
TABS_ENABLED_FLAG | NULLABLE | VARCHAR2 (1 Char) | Flag to indicate whether to use tab layout in request details page

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_REQUEST_TYPES_U1 | UNIQUE | 1 | REQUEST_TYPE_ID
KCRT_REQUEST_TYPES_U2 | UNIQUE | 1 | REQUEST_TYPE_NAME
SYS_C005197135 | UNIQUE | 1 | REFERENCE_CODE

## Sequences

Sequence Name | Sequence Type
--- | ---
KCRT_REQUEST_TYPES_S | REQUEST_TYPE_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: