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.
