KCRT_FG_CMDB_APPLICATION_INT

This table stores information for importing requests that have information about a corresponding CMDB entry into the KCRT_FG_CMDB_APPLICATION table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUESTS

REQUEST_ID

REQUEST_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KCRT_REQUESTS_INT

TRANSACTION_ID

PARENT_TRANSACTION_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

Links this information with KCRT_REQUESTS

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID of this request

CMDB_ID

NULLABLE

VARCHAR2(32)

ID of the CMDB

CMDB_DISPLAY_LABEL

NULLABLE

VARCHAR2(255)

Display label for the CMDB

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_CMDB_APP_INT_N1

NONUNIQUE

1

GROUP_ID

KCRT_FG_CMDB_APP_INT_N1

NONUNIQUE

2

TRANSACTION_ID

Sequences

This table uses no sequences.