Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 12 Users and Work Queues : leavers

leavers
The leavers table stores information about the recently deleted users.
Structure
The leavers table has the following structure:
TABLE leavers (
node_id INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL,
destination VARCHAR(64) NOT NULL,
timestamp NUMERIC(20) NOT NULL,
status INTEGER NOT NULL)
0 (LEAVER_WILL_BE_REDIRECTED)  The leaver will be redirected.
1 (LEAVER_IS_BEING_REDIRECTED)  The leaver is being redirected.
2 (LEAVER_FINISH_REDIRECTION)  The leaver has been redirected.
Primary Key
The following primary key is defined for this table.
 
Triggers
None.
Indexes
None.
Table Activity
The leavers table contains one row for each recently deleted user.
Rows are added, updated, and deleted in the following situations.
the status field is set to 2 (LEAVER_FINISH_REDIRECTION),
the time length definied by the WQS_LEAVER_PERIOD process attribute has passed since the status field was set to 2,

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved