Copyright © Cloud Software Group, Inc. All Rights Reserved

leavers

The leavers table stores information about the recently deleted users.

Structure

The leavers table has the following structure:

TABLE leavers (
node_id number(5) NOT NULL,
user_name varchar2(64) NOT NULL,
destination varchar2(64) NOT NULL,
timestamp number(20) NOT NULL,
status number(2) NOT NULL)

Column	Description
node_id	ID of the node that this (user or group) queue is registered on, as defined in the nodes table.
user_name	Name of this deleted user.
destination	Description of this deleted user.
timestamp	When the current status is set.
status	Status of the redirection performed on the leaver. One of the following values: • 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.

Key Name	Column(s)	Index Tablespace
pk_leavers	user_name node_id	MEDIUMINDEXSPACE

Foreign Keys

None.

 

Indexes

None.

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MEDIUMTABLESIZE
Percentage Increase	MEDIUMTABLEPCTINCREASE
Tablespace	MEDIUMTABLESPACE

Table Activity

The leavers table contains one row for each recently deleted user.

Rows are added, updated, and deleted in the following situations.

A row is...	When...
added	a user is deleted.
updated	one of the following conditions is met: • the iProcess Engine is started, • the status of the deleted user is changed.
deleted	all of the following conditions are met: • 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, • the iProcess Engine is shut down, or a Move System Information operation is performed.

Copyright © Cloud Software Group, Inc. All Rights Reserved