From Bright Pattern Documentation
ia2_customer_slices_2
The ia2_customer_slices_2 table is the primary table for interaction data, containing one record per customer conversation. It includes overall autosurvey results, interaction dispositions, total interaction durations, and customer satisfaction scores.
Description of Data
The following provides the column name, data types, and description for the ia2_customer_slices_2 table.
| Column Name | Data Type | Description |
| id | BINARY(16) | Primary Key, UUID - Unique identifier of the customer slice |
| media_type | VARCHAR(50) | Media type, one of:
|
| service_name | VARCHAR(100) | Name of the service (identifies the form for autosurveys and the template for histortical summaries)
If the conversation involved multiple services, this will be either the first service or the last service associated with the conversation, depending on the setting Service for Autosurvey and Historical AI Summary. |
| disposition | VARCHAR(225) | Disposition of the conversation. If multiple agents participated in the conversation, contains the final disposition. |
| first_name | VARCHAR(100) | First name of the participant |
| last_name | VARCHAR(100) | Last name of the participant |
| phone_number | VARCHAR(255) | Phone number (if applicable) |
| VARCHAR(100) | Email (if applicable) | |
| start_time | DATETIME(3) | Start time of the conversation |
| end_time | DATETIME(3) | End time of the conversation |
| total_duration | INT(11) | Total duration of the conversation (in seconds) |
| total_talk_time | INT(11) | Talk time (in seconds) |
| autosurvey_form_name | VARCHAR(255) | Name of the autosurvey form |
| autosurvey_value | INT(11) | Autosurvey evaluation result value (total score) |
| autosurvey_failed | TINYINT(1) | Indicates if autosurvey failed |
| global_interaction_id | BINARY(16) | Global identifier (GIID) (of the first interaction - for cases) |
| historical_interaction_id | VARCHAR(36) | Unique identifier of the conversation |
| case_number | VARCHAR(255) | Case number associated with the conversation |
| case_title | VARCHAR(255) | Title or subject of the case |
| case_status | VARCHAR(255) | Current status of the case |
| case_category | VARCHAR(255) | Category or type of the case |
| case_pending_reason | VARCHAR(255) | Reason why the case is pending |