KCRT_FG_PROJ_SCOPE_CHANGE

If the "Project Scope Change" field group is linked to a request's request header type, a row will exist in this table for the request.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

System-generated identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Identifies the request type

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_SCOPE_CHANGE_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.