Event and archive tables

The connector uses the event table to poll events for pickup. For each event, the connector gets the business object's name, verb, and key from the event table. The connector uses this information to retrieve the entire entity from the application. If the entity was changed after the event was first logged, the connector gets the initial event and all subsequent changes. In other words, if an entity is created and updated before the connector gets it from the event table, the connector gets both data changes in the single retrieval.

The following three outcomes are possible for each event processed by a connector:

If events are not deleted from the event table after the connector picks them up, they occupy unnecessary space there. However, if they are deleted, all events that are not processed are lost and event-processing cannot be audited. Therefore, the adapter provides the archive table to store events deleted from the event table.

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

Table 3. Event and archive table schema
Name Description Type Constraint
CW_EVENT_ID Internal identifier of the event A unique key field that identifies each event generated from within PeopleSoft NUMBER Primary key
CW_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
CW_OBJ_KEYS Keys of the business object, specified in name-value format. When defining parameters for a function call (such as cw_publish_events), the name consists of the table name and field name separated by a period. Multiple keys are separated with a colon or other configurable delimiter, for example: DEPT_TBL.SetId:DEPT_TBL.DeptIdFor more information, see EventKeyDelimiter. VARCHAR Not null
CW_OBJ Name of the business object VARCHAR Not null
CW_VERB Verb associated with the event. A PeopleCode function included with the adapter determines the value (Create, Retrieve, Update, Delete) based upon the %Mode system variable used by PeopleSoft VARCHAR Not null
CW_PRIORITY Not used.
CW_DTTM Date and time the event or archiving occurred STRING Default current date/time (for archive table, actual event time). PeopleSoft treats the datatype for DATE fields as STRING and returns the same.
CW_STATUS -2 (Error sending event to integration broker) VARCHAR Not null
-1 (Error processing event)
0 (Ready for poll)
1 (Sent to 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.
99 (Future effective-dated events) This status is used only in the event table and not in the archive table.

Copyright IBM Corporation 1997, 2004. All Rights Reserved.