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 |