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