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