KNTA_UCMDB_CI_SETS

This table stores information about a set of configuration items. This table is used by PPM-uCMDB integration. A PPM entity may have only one set of zero or more configuration items.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_ENTITIES_NLS

ENTITY_ID

ENTITY_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

UCMDB_CI_SET_ID

NOT NULL

NUMBER

System-generated identifier

UCMDB_SERVER_NAME

NOT NULL

VARCHAR2(200)

uCMDB server name (free form string)

ENTITY_TYPE_ID

NOT NULL

VARCHAR2(200)

PPM entity type identifier (request, task, project, and so on)

ENTITY_ID

NOT NULL

NUMBER

PPM entity identifier. This is the entity that has a set of configuration items attached/associated with it.

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_SETS_PK

UNIQUE

1

UCMDB_CI_SET_ID

Sequences

Sequence Name

Sequence Type

KNTA_UCMDB_CI_SETS_S

UCMDB_CI_SET_ID