EGP_IC_ITEM_ATTRIBUTES_
Contains Item attributes Data Quality SetUp Data
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGP_IC_ITEM_ATTRIBUTES_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, ITEM_CLASS_ID, ATTR_TYPE, ATTR_GROUP_INTERNAL_NAME, ATTR_INTERNAL_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ITEM_CLASS_ID | NUMBER | 18 | Yes | Provides metadata common to all items that share the category. For example, the item catalog category "Engine" describes attributes, functions and other characteristics common to several item numbers, such as Engine M10000 and Engine M20000. | |
| ATTR_GROUP_INTERNAL_NAME | VARCHAR2 | 80 | Yes | Internal name of the attribute group. | |
| ATTR_INTERNAL_NAME | VARCHAR2 | 80 | Yes | Internal name of the attribute. | |
| ATTR_TYPE | VARCHAR2 | 20 | Yes | Indicates the type of the Attribute. | |
| MATCHING | VARCHAR2 | 1 | Indicates whether the Item's attribute value is identical with any other Item attribute value. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Stores the original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_DATA_QUALITYN1_ | Non Unique | Default | ITEM_CLASS_ID, ATTR_TYPE, ATTR_GROUP_INTERNAL_NAME, ATTR_INTERNAL_NAME |
| EGP_DATA_QUALITYN2_ | Non Unique | Default | AUDIT_ACTION_TYPE_ |
| EGP_IC_ITEM_ATTRIBUTES_U1_ | Unique | FUSION_TS_TX_DATA | LAST_UPDATE_DATE, LAST_UPDATED_BY, ITEM_CLASS_ID, ATTR_TYPE, ATTR_GROUP_INTERNAL_NAME, ATTR_INTERNAL_NAME |