KCRT_REQ_HEADER_DETAILS_ARCH

This table stores information about archived request header details for Demand Management.

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

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KCRT_REQ_HEADER_DETAILS

REQ_HEADER_DETAIL_ID

REQ_HEADER_DETAIL_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQ_HEADER_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 the request header was archived

ARCHIVED_BY

NOT NULL

NUMBER

Resource that archived the request header details

REQ_HEADER_DETAIL_ID

NOT NULL

NUMBER

Unique identifier for the request header detail that was archived

REQUEST_ID

NOT NULL

NUMBER

Unique identifier for the request that the header details belong to

REQUEST_TYPE_ID

NOT NULL

NUMBER

Unique identifier for the type of request that this header details belongs to

BATCH_NUMBER

NOT NULL

NUMBER

Data batch number associated with the request

PARAMETER1-40

NULLABLE

VARCHAR2(200)

User data segment

VISIBLE_PARAMETER1-40

NULLABLE

VARCHAR2(200)

User data segment

PARAMETER41-50

NULLABLE

VARCHAR2(4000)

User data segment

VISIBLE_PARAMETER41-50

NULLABLE

VARCHAR2(4000)

User data segment

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_REQ_HEADER_DETAIL_ARCH_U1

UNIQUE

1

REQ_HEADER_DETAIL_ARCH_ID

Sequences

Sequence Name

Sequence Type

KCRT_REQ_HEADER_DETAILS_ARCH_S

REQ_HEADER_DETAIL_ARCH_ID