Contents

I3_ContactListName_PEN Schema

This table stores the numerator used to calculate penetration rate. It contains one row for each completed call of the corresponding contact list table.

Column	Details	Description
UPLOADID	int, not null	A sequential number created every time a new contact list is uploaded or contacts are added to an existing contact list via the Import Contact List Wizard. This new Upload ID is then assigned to the new contacts.
I3_IDENTITY	bigint, null	An integer value that uniquely identifies each row in the contact list.
CONTACTSTATUS	nchar(1), null	One-character alphabetical flag that indicates the status of this contact.
PHONENUMBERCOL	nvarchar(80), null	Name of the contact list column that stored this contact.
PHONENUMBERSTATUS	nchar(1), null	Stores Phone Number Detail (PND) status, duplicating the I3_STATUS field in the PND table (which contains call completion codes ‘U', ‘C' and so on.)
CAMPAIGN	nvarchar(80), null	Campaign that dialed this contact.
CALLID	nvarchar(80), null	The callid number of this call attempt. For more information, see the discussion of callid in the Reporting Data Dictionary.
WRAPUPCATEGORY	nvarchar(80), null	Wrap-up Categories generically classify the result of a campaign call for reporting purposes.
WRAPUPCODE	nvarchar(80), null	Wrap-up Codes are strings that indicate the completion status of a call step. Wrap-up codes are the disposition options that agents see in a script. <more…>
CALLINGMODE	nvarchar(80), null	Indicates the dialing mode.
CALLPLACEDTIMEUTC	datetime, null	Time when call was placed.
SUCCESSRESULT	float, null	SUCCESSRESULT is a customer-managed column. Customers can use this column to maintain running counters, such as a money counter for example. SUCCESSRESULT in a row will contain whatever was in the SUCCESSRESULT column of the associated contact.