KCRT_FG_PROG_RISK_INT

This table is used for importing Program risks into the KCRT_FG_PROG_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 of the parent table being imported

REQUEST_ID

NULLABLE

NUMBER

Identifies the request

REQUEST_TYPE_ID

NULLABLE

NUMBER

Identifies the request type

PROG_PROBABILITY_CODE

NULLABLE

VARCHAR2(200)

Specifies the probability code of the program risk

PROG_PROBABILITY_MEANING

NULLABLE

VARCHAR2(200)

Specifies the probability description of the program risk

PROG_RISK_IMPACT_LEVEL_CODE

NULLABLE

VARCHAR2(200)

Specifies the code for the impact level of the program risk

PROG_RISK_IMPACT_LEVEL_MEANING

NULLABLE

VARCHAR2(200)

Specifies the description of the impact level of the program risk

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_PROG_RISK_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_PROG_RISK_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.