Contents

CallRecordSchedule Table

The CallRecordSchedule table maintains the list of parties that are scheduled for callbacks. Although this table does collect data on both the agent and the customer, this table is not intended to act as historical data. Entries are removed from the CallRecordSchedule table when they are passed to the Dialer Server.

Interaction Dialer automatically creates a CallRecordSchedule table (I3_<ContactList>_CS) for each call list. No customer maintenance is required.

CallRecordSchedule Schema

Column	Details	Description
CAMPAIGNNAME	varchar(255), not null	Name of the Campaign.
SITEID	varchar(80), null	Name of the Outbound Dialer server that will call back the party.
I3_IDENTITY	PK, bigint, not null	An integer value that uniquely identifies each row in the contact list. This field is managed for the customer by Dialer. Customers may continue to insert records that contain I3_ROWID, but they should not populate I3_IDENTITY fields.
SCHEDTIME	datetime, not null	The scheduled callback date and time.
AGENTID	varchar(80), null	This field contains the name of an agent if an agent owns the callback; otherwise the AGENTID is blank.
SCHEDPHONE	varchar(50), not null	This column contains the phone number that will be dialed when this contact is called back. It stores the last phone number dialed to reach the contact—the number that reached a contact who asked to be called back at a later time, or the last number dialed when the system auto-scheduled the callback, due to no answer, busy, or another condition. When the scheduled call matures, the number in this field is always called, even if there are multiple phone numbers per contact. If there is no specific phone number to dial, then this field can be an empty string and the entire contact will be scheduled. Each contact number will be called per the same rules used when a contact comes up for normal calling (for example phone number order, and so on)
SCHEDCCID	bigint, not null	The default is -1, which indicates that 'schedphone' is not in the PND table. Otherwise, this column contains a valid ccid from the Phone Number Detail (PND) table. 'ccid' stands for Contact Column ID—the unique id of the corresponding contact phone number in the Contact list.

Columns that do not allow NULL values must have a value when records are added or inserted.