Event and archive table schema

Table 3 describes the columns in the event and archive tables.

Table 3. Event and archive table schema
Name Description Type Constraint
event_id Internal identifier of the event NUMBER Primary key
connector_id Unique ID of the connector for which the event is destined. This value is important when multiple connectors poll the same table. VARCHAR
object_key Primary key of the business object. The key can be represented as a name_value pair, or as a set of keys delimited by a colon or other configurable delimiter (for example, 1000065:10056:2333). See the EventKeyDel property for more information. VARCHAR Not null
object_name Name of the business object VARCHAR Not null
object_verb Verb associated with the event VARCHAR Not null
event_priority Event priority (0 is highest, n is lowest), which the connector uses to get events on a priority basis. The connector does not use this value to lower or raise priorities. NUMBER Not null
event_time Date and time the event occurred DATETIME Default current date/time (for archive table, actual event time)
archive_time Date and time the event was archived (applies only to the archive table) DATETIME Archive date/time
event_status -2 (Error sending event to the integration broker) NUMBER Not null

-1 (Error processing event)


0 (Ready for poll)


1 (Sent to the integration broker)


2 (No Subscriptions for the business object)


3 (In Progress). This status is used only in the event table and not in the archive table.

event_comment Description of the event or error string VARCHAR

Copyright IBM Corp. 1997, 2003