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