KCRT_FG_PROJ_SCOPE_CHANGE_INT

This table is used for importing Project Scope Changes into the KCRT_FG_PROJ_SCOPE_CHANGE 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

IMPACT_SEVERITY_CODE

NULLABLE

VARCHAR2(200)

Specifies the severity code for the impact of the scope change

IMPACT_SEVERITY_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the severity impact of the scope change

CR_LEVEL_CODE

NULLABLE

VARCHAR2(200)

Specifies the code for the change request importance level of the scope change

CR_LEVEL_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the change request importance level of the scope change

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PROJ_SC_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_PROJ_SC_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.