Recycle Table

At runtime, Dialer creates a recycle table that helps it select the next batch of ContactList records for processing. The recycle table holds sequencing for the current recycle. Recycle tables are named as follows: I3_ CampaignName_RE0. For example, the recycle table for a GlobeNews campaign might be named: I3_GlobeNews_RE0.

Recycle Table Schema

The Recycle table consists of only two fields, one of which (i3_Identity) is used as the join with the ContactList. The second field, i3_SeqNo, stores the processing sequence number of each specific record within the recycle. i3_SeqNo reflects the processing order of records within the ContactList based on filter and sort criteria provided by the customer.

The sequence id is a unique number that identifies the order in which records should be processed. Each sequence number indicates where each record falls in the recycle based on the current filter and sort criteria.

A recycle table is automatically created by the system when you create a campaign. The table is named I3_<CampaignName>_RE0. 

Record Selection Process

Dialer invokes a stored procedure to select contact list records for processing.  It preps the contact list before every recycle.  The procedure runs quickly since it is precompiled and resides in the database.  When a campaign is started, reset, or recycled, the conceptual process is as follows:

1. The procedure clears the contents of the recycle table.

2. It reorders the contact list to apply sort criteria defined for the campaign.

3. It queries the contact list to obtain a list of all contacts that can be called, based upon the Status of each record and the Campaign filter.

4. The resulting row IDs are stored in the status table.  The order in which the records are returned is used to populate the sequence ID field. 

5. Records are processed in i3_seqno order.  Only records that are not blocked by Zones at this point are pulled.  As records are pulled for processing, they are removed from the recycle table.  The recycle table contains only records that are left to process in the current recycle. 

6. When a contact list record is routed to an Outbound Dialer server, its status is set to "I" to indicate that the record is in-process (for example: the record is being dialed or awaiting completion from the agent.)  This prevents future selects from pulling the record and double-dialing a contact.  The Status field is updated again when the contact record is dispositioned.  This eliminates the need to maintain a cache of records that are currently active within the system.