McDewey

DialingList Database table name: DialingList The DialingList table contains the outbound contacts that need to be dialed for a particular campaign. This table is populated when a text file containing the outbound contacts is imported from the Campaigns configuration page in the Unified CCX Administration. When the outbound contacts are imported into the database from the Unified CCX Administration, the callStatus field has the default value of 1 (Pending); that is, the contacts are yet to be dialed. Table 43: DialingList Table Fields Storage Description Field Name int NOT NULL Primary Key A unique identifier for the record. recordid int NOT NULL Primary Key A unique identifier for a contact. dialinglistid int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileid int NULL Campaign identifier campaignid datetime year to second NULL Default -CURRENT_TIMESTAMP createdatetime nvarchar(25, 0) NULL The account number of the contact (from the imported file). This field is sent to the agent desktop. accountnumber nvarchar(50, 0) NULL The first name of the contact (from the imported file). firstname nvarchar(50,0) NULL The last name of the contact (from the imported file). lastname varchar(28,0) NOT NULL Primary phone number of the contact (from the imported file). phone01 Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 61 Database Schema DialingList