KCRT_REQUEST_DETAILS_ARCH

This table stores the backup KCRT_REQUEST_DETAILS data. The request backs up the REQUEST_DETAILS data when a user changes the request type of the request.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_PARAMETER_SET_CONTEXTS

PARAMETER_SET_CONTEXT_ID

PARAMETER_SET_CONTEXT_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_USERS

USER_ID

ARCHIVED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_DETAIL_ARCH_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

ARCHIVE_DATE

NOT NULL

DATE

Date record was archived

ARCHIVED_BY

NOT NULL

NUMBER

Identifies the user who archived the record

REQUEST_ID

NOT NULL

NUMBER

Request identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifies the original request type chosen for this request

BATCH_NUMBER

NOT NULL

NUMBER

Defines which batch the parameter fields belong to

PARAMETER_SET_CONTEXT_ID

NULLABLE

NUMBER

Identifies the parameter set context associated with the original request type chosen for this request

PARAMETER1-40

NULLABLE

VARCHAR2(200)

REQUEST_DETAILS_ARCH parameter

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

REQUEST_DETAILS_ARCH parameter

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

REQUEST_DETAILS_ARCH parameter

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

REQUEST_DETAILS_ARCH parameter

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQUEST_DETAILS_ARCH_N1

NONUNIQUE

1

REQUEST_ID

KCRT_REQUEST_DETAILS_ARCH_N1

NONUNIQUE

2

REQUEST_TYPE_ID

KCRT_REQUEST_DETAILS_ARCH_U1

UNIQUE

1

REQUEST_DETAIL_ARCH_ID

Sequences

Sequence Name

Sequence Type

KCRT_REQUEST_DETAILS_ARCH_S

REQUEST_DETAIL_ARCH_ID