Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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 defined 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.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine