KCRT_FG_IMPACT_ANALYSIS_INT

This table is used for importing uCMDB-integrated requests.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUESTS_INT

TRANSACTION_ID

PARENT_TRANSACTION_ID

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

GROUP_ID

NULLABLE

NUMBER

System-generated identifier

TRANSACTION_ID

NULLABLE

NUMBER

Provides a unique identifier for each transaction

PARENT_TRANSACTION_ID

NULLABLE

NUMBER

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

REQUEST_ID

NOT NULL

NUMBER

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

REQUEST_TYPE_ID

NOT NULL

NUMBER

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

MAM_RFC_ID

NULLABLE

VARCHAR2(64)

uCMDB RFC identifier

IMPACT_RESULT_VALUE

NULLABLE

NUMBER

uCMDB Impact analysis result

IMPACT_RESULT_MEANING

NULLABLE

VARCHAR2(20)

uCMDB Impact analysis result meaning

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_IMPACT_ANALYSIS_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_IMPACT_ANALYSIS_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.