Share this page

# KENV_OBJECT_ATTRIBUTES

This table stores information about the specific attributes of an object; when comparing two objects, each of the attributes for those objects is compared. For database objects, the attributes are columns in a table or view (typically a data dictionary view), while for file system objects, the attributes are attributes about the file itself (for example, name and size). This table also contains information about how each of the attributes is displayed, including its datatype, length, and order.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | LAST_UPDATED_BY
KENV_OBJECTS | OBJECT_ID | OBJECT_ID
KNTA_USERS | USER_ID | CREATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
OBJECT_ATTRIBUTE_ID | NOT NULL | NUMBER | System-generated identifier
ATTRIBUTE_NAME | NOT NULL | VARCHAR2(150) | Displayed name of the attribute
COLUMN_NAME | NULLABLE | VARCHAR2(2000) | For database objects, the actual column that is queried
COLUMN_ALIAS | NOT NULL | VARCHAR2(80) | For database objects, the alias for the column that is queried
OBJECT_ID | NULLABLE | NUMBER | Identifier for the object that this attribute belongs to
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 attribute
ORIGINAL_ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Original value of Enabled Flag for seeded rows
ENABLED_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the attribute is used in comparisons
ORIGINAL_ALWAYS_DISPLAY_FLAG | NOT NULL | VARCHAR2(1) | Original value of Always Display Flag for seeded rows
ALWAYS_DISPLAY_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the attribute is displayed if there are no differences between two objects and the Only Report Differences flag on the comparison reports is set to Yes
ORIGINAL_COMPARE_FLAG | NOT NULL | VARCHAR2(1) | Original value of Compare Flag for seeded rows
COMPARE_FLAG | NOT NULL | VARCHAR2(1) | Indicates whether the attribute is compared for differences when comparing two objects
TYPE | NOT NULL | NUMBER | Data type for the attribute (number, character, date, and so on)
LENGTH | NOT NULL | NUMBER | Display length for the attribute. This value does not affect how many characters of the attribute are actually compared
SORT_ORDER | NOT NULL | NUMBER | Order that the attribute is displayed on the comparison reports

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KENV_OBJECT_ATTRIBUTES_U1 | UNIQUE | 1 | OBJECT_ATTRIBUTE_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: