Schema and table detail

Here is schema used before CIC 4.0.
In 4.0 GA and later, CIC captures the interaction detail data in four tables
These tables use an identical composite key: InteractionIDKey, SiteID, and SeqNo. You use this primary key to link the data in these tables.

Note: For more information about the attributes for these tables, see the PureConnect Data Dictionary Technical Reference in the PureConnect Documentation Library.

Table	Description
Interaction Summary	This table replaces our previous Calldetail table. It includes all the interaction attributes previously captured in the Calldetail table. In addition, it includes high-level summary data about the interaction. For example, you can determine how many times participants put the interaction on hold (nHeld). It also includes the total hold time (tHeld) for the interaction during its entire life cycle.
Interaction Segment Detail	This table captures interaction history in predefined segments.
Interaction Wrap-up	If the interaction has an associated wrap-up code, this table captures all the related wrap-up code statistics.
Interaction Custom Attributes	This table replaces the custom attributes in the previous Calldetail table. It includes 10 custom columns: five number columns and five string columns. The customer can define their custom attributes just as they did before CIC 4.0. This table captures the data.