KCRT_FG_PROJ_RISK_INT

This table is used for importing Project risks into the KCRT_FG_PROJ_RISK 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

PROBABILITY_CODE

NULLABLE

VARCHAR2(200)

Specifies the probability code of the project risk

PROBABILITY_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the project risk

RISK_IMPACT_LEVEL_CODE

NULLABLE

VARCHAR2(200)

Specifies the code for the impact level of the project risk

RISK_IMPACT_LEVEL_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the impact level of the project risk

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PROJ_RISK_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_PROJ_RISK_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.