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 INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL,
destination VARCHAR(64) NOT NULL,
timestamp NUMERIC(20) NOT NULL,
status INTEGER 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)
pk_leavers	user_name node_id

Foreign Keys

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.

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.