KCRT_FG_PROJ_ISSUE_INT

This table is used for importing Project issues into the KCRT_FG_PROJ_ISSUE table.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NOT NULL

NUMBER

System-generated identifier

TRANSACTION_ID

NOT NULL

NUMBER

Provides a unique identifier for each transaction

PARENT_TRANSACTION_ID

NOT NULL

NUMBER

Provides the transaction ID (from KCRT_REQUESTS_INT) of the parent table being imported

REQUEST_ID

NULLABLE

NUMBER

Identifies the request. This is normally left blank and is derived from the KCRT_REQUESTS_S sequence

REQUEST_TYPE_ID

NULLABLE

NUMBER

Identifies the request type. This is normally left blank and is derived from REQUEST_TYPE_NAME

ESCALATION_LEVEL_CODE

NULLABLE

VARCHAR2(200)

Specifies the code for the escalation level

ESCALATION_LEVEL_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the escalation level

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PROJ_ISSUE_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_PROJ_ISSUE_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.