- Contents
Interaction Dialer Manager Help
Contact Column Details Table
Dialer generates a Contact Column Details (CCD) table for each contact list in use. This table represents the relationship between the call list table and the PND table with respect to the CCID.
The CCD table tracks the contact columns chosen for a contact list and the contact column ids assigned to those contact columns. The contact column ids tracked in the contact column details tables correspond to the i3_ccid field in the phone number details (PND) table, making the new table useful when customizing the PND table.
Tables are named using this convention: I3_<ContactList>_CCD.
Contact Column Details Table Schema
The contact column details table that is generated contains two columns, which track the contact columns chosen for a contact list and the contact column ids assigned to those contact columns. The contact column ids tracked in the contact column details tables correspond to the i3_ccid field in the phone number details (PND) table, making the new table useful when customizing the PND table.
|
I3_<ContactList>_CCD |
||
|
Column |
Details (SQL Server) |
Details (Oracle) |
|
column_name |
Sysname |
Nvarchar2(30) |
|
ccid |
Bigint |
Number(20) |
The primary key on the table is column_name. Neither column allows nulls.