KCRT_REQUEST_DETAILS

This table is used to store the details of a request. A request has only one active detail at any one time.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_DETAIL_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

REQUEST_ID

NOT NULL

NUMBER

Request identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifier for the request type chosen for this request

BATCH_NUMBER

NOT NULL

NUMBER

Batch the parameter fields belong to

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Parameter set context associated with the request type chosen for this request

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

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQUEST_DETAILS_N1

NONUNIQUE

1

REQUEST_ID

KCRT_REQUEST_DETAILS_N2

NONUNIQUE

1

REQUEST_TYPE_ID

KCRT_REQUEST_DETAILS_N3

NONUNIQUE

1

REQUEST_ID

KCRT_REQUEST_DETAILS_N3

NONUNIQUE

2

BATCH_NUMBER

KCRT_REQUEST_DETAILS_U1

UNIQUE

1

REQUEST_DETAIL_ID

Sequences

Sequence Name

Sequence Type

KCRT_REQUEST_DETAILS_S

REQUEST_DETAIL_ID