Share this page

# KENV_OBJECTS

This table stores all of the objects that can be compared using the Environment Comparison Reports. Objects can either be Oracle database objects, SQL Server database objects, or file system objects. When you compare an object, you also compare all of the objects within its hierarchy; for example, when comparing tables in two environments, you also compare the columns for the tables.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KENV_OBJECTS | OBJECT_ID | PARENT_OBJECT_ID
KENV_OBJECT_ATTRIBUTES | OBJECT_ATTRIBUTE_ID | PRIMARY_KEY_ATTRIBUTE_ID
KENV_OBJECT_ATTRIBUTES | OBJECT_ATTRIBUTE_ID | USER_KEY_ATTRIBUTE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OBJECT_ID | NOT NULL | NUMBER | System-generated identifier
USER_KEY_ATTRIBUTE_ID | NOT NULL | NUMBER | Attribute identifier for the displayed unique key for the object
PRIMARY_KEY_ATTRIBUTE_ID | NOT NULL | NUMBER | Attribute identifier for the primary key for the object
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
DESCRIPTION | NULLABLE | VARCHAR2(240) | A description for the object
ORIGINAL_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Original value of Enabled Flag for seeded rows
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the object can be used in comparisons
OBJECT_LEVEL | NOT NULL | NUMBER | Level within the object hierarchy
OBJECT_SOURCE | NOT NULL | VARCHAR2(80) | Source of the object (Oracle, SQL Server, or file system)
TABLE_NAME | NULLABLE | VARCHAR2(80) | For database objects, the name of the table
PARENT_OBJECT_ID | NULLABLE | NUMBER | If the Object Level is not 0, the identifier for the parent object within the hierarchy
SELECT_CONDITION | NULLABLE | VARCHAR2(2000) | For database objects, the WHERE condition that restricts what objects are queried
SELECT_SQL | NULLABLE | CLOB | For database objects, the specific SQL used to query the objects
SELECT_ORDERBY | NULLABLE | VARCHAR2(2000) | For database objects, the ORDER BY clause used to sort the objects

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KENV_OBJECTS_U1 | UNIQUE | 1 | OBJECT_ID

## Sequences

This table uses no sequences.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: