SMO_EVENT_ATTRIBUTE_VALUES

The table stores the attributes values of the incoming events. Each row represents the value of a single attribute from the event.

Details

• Schema: FUSION

• Object owner: SMO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
SMO_EVENT_ATTR_VALUES_PK	EVENT_TIME, BO_ID, EVENT_TYPE_ID, BO_TYPE_ID, BO_KIND_ID, ATTRIBUTE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EVENT_TIME	TIMESTAMP			Yes	Indicates date and time when the event occurred.
BO_ID	NUMBER		18	Yes	Indicates the business object identifier.
EVENT_TYPE_ID	NUMBER		18	Yes	Indicates the event type identifier.
BO_TYPE_ID	NUMBER		18	Yes	Indicates the system business object type identifier.
BO_KIND_ID	NUMBER		18	Yes	Identifier of the root type in the business object hierarchy.
ATTRIBUTE_ID	NUMBER		18	Yes	Indicates attribute identifier from the event.
ORGANIZATION_ID	NUMBER		18		Identifier of the organization to which this event belongs.
NUMERIC_VALUE	NUMBER				Indicates the attribute numeric value.
STRING_VALUE	VARCHAR2	4000			Indicates the attribute string value.
DATE_VALUE	TIMESTAMP				Indicates the attribute date value.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
SMO_EVENT_ATTR_VALUES_U01	Unique	Default	EVENT_TIME, BO_ID, EVENT_TYPE_ID, BO_TYPE_ID, BO_KIND_ID, ATTRIBUTE_ID