KNTA_UCMDB_CI_ENTRIES

This table contains entries created by PPM-uCMDB integration. Each entry represents a configuration item (CI), retrieved from uCMDB. An entity in PPM (for example, request) may have a set of configuration items.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_UCMDB_CI_ENTRIES

CI_ID

CI_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_UCMDB_CI_SETS

UCMDB_CI_SET_ID

UCMDB_CI_SET_ID

KRML_VIEWS

VIEW_ID

VIEW_ID

Column Descriptions

Column Name

Null?

Data Type

Description

UCMDB_CI_ENTRY_ID

NOT NULL

NUMBER

System-generated identifier

UCMDB_CI_SET_ID

NOT NULL

NUMBER

Identifier for CI set foreign key to KNTA_UCMDB_CI_SETS

VIEW_ID

NULLABLE

VARCHAR2(200)

CI View identifier from uCMDB

VIEW_NAME

NULLABLE

VARCHAR2(1024)

CI View name from uCMDB

VIEW_TYPE

NULLABLE

VARCHAR2(200)

CI View Type from uCMDB

VIEW_TQL_NAME

NULLABLE

VARCHAR2(200)

CI View TQL Name from uCMDB

VIEW_TREE_VIEW_NAME

NULLABLE

VARCHAR2(200)

CI View name in Tree View from uCMDB

CI_ID

NOT NULL

VARCHAR2(200)

System-generated identifier

CI_NAME

NULLABLE

VARCHAR2(1024)

CI name from uCMDB

CI_TYPE

NULLABLE

VARCHAR2(200)

CI Type from uCMDB

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_UCMDB_CI_ENTRIES_PK

UNIQUE

1

UCMDB_CI_ENTRY_ID

Sequences

Sequence Name

Sequence Type

KNTA_UCMDB_CI_ENTRIES_S

UCMDB_CI_ENTRY_ID