Event table structure

When an event occurs in the PeopleSoft application, the event is placed in an event queue table named XR_EVENT. The connector polls this table at a configurable interval and processes the events sequentially.

The event queue table and archive queue table have the following structure. However, only the archive table has the PROCESS_KEY field.

Table 3. Event queue and archive queue table structure

Name Type Constraint Description
PROCESS_KEY Datetime Not NULL Unique key for the event result set. The key is the date and time stamp when the event was processed. Used by the archive table only.
CWPRIORITY char 3
Event priority.
EVENT_KEY Datetime Not NULL Unique key for the event. The key is the date and time stamp when the event was processed.
OBJ_SETID char 5
TableSetID for the PeopleSoft object.
OBJECT_ID char 18
Unique ID for the PeopleSoft object.
OBJECT char 18
Name of the PeopleSoft object.
DOVERB char 15
Name of the action taken on the PeopleSoft object.
KEYLIST char 51
List of non-primary object keys. Keys are listed in name=value format and delimited by a colon (:).
PRCS_FLG char 3
Process flag to indicate the state of the event. The values can be:
  • N = Not processed
  • P = Successfully processed
  • NS = Event not subscribed to
  • E = Error

Copyright IBM Corp. 1997, 2003