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 |
|