From Bright Pattern Documentation
ia2_agent_slices_2
The ia2_agent_slices_2 table contains detailed information about the agents who participated in a conversation. It includes overall autoscoring and checklist results, as well as individual timing and operational metrics.
Description of Data
The following provides the column name, data type, and description for the ia2_agent_slices_2 table.
| Column Name | Data Type | Description |
| id | BINARY(16) | Primary Key, UUID - Unique identifier of the agent slice |
| customer_slice_id | BINARY(16) | Foreign Key - Reference to customer_slices.id |
| interaction_id | BINARY(16) | UUID - Interaction identifier |
| global_interaction_id | BINARY(16) | Global identifier of the interaction |
| party_type | ENUM('AGENT','SCENARIO','3RD_PARTY') | Participant type (Agent, Scenario, 3rd Party) |
| first_name | VARCHAR(100) | First name of the participant |
| last_name | VARCHAR(100) | Last name of the participant |
| phone_number | VARCHAR(255) | Phone number of the participant (if applicable) |
| VARCHAR(100) | Email address of the participant (if applicable) | |
| team_name | VARCHAR(100) | Agent's team name (if applicable) |
| login_id | VARCHAR(50) | Login ID of the participant (if applicable) |
| rank | VARCHAR(250) | Agent's rank (if applicable) |
| service_name | VARCHAR(100) | Name of the service associated with the agent’s segment |
| scenario_name | VARCHAR(100) | Name of the scenario |
| disposition | VARCHAR(225) | Disposition that agent selected |
| end_time | DATETIME(3) | Party end time (with milliseconds precision) |
| start_time | DATETIME(3) | Party start time (with milliseconds precision) |
| duration | INT(11) | Party duration in seconds |
| talk_time | INT(11) | Talk time (in focus time) in seconds |
| wrap_up_time | INT(11) | Wrap-up time in seconds (if applicable) |
| handling_time | INT(11) | Handling time in seconds (if applicable) |
| is_consult | TINYINT(1) | Indicates whether it is a consult call between two or more agents |
| autoscoring_form_name | VARCHAR(255) | Name of the autoscoring form used |
| autoscoring_value | INT(11) | Autoscoring evaluation result value (total score) |
| autoscoring_failed | TINYINT(1) | Indicates if autoscoring failed |
| custom1 | VARCHAR(255) | Custom field 1 for additional data |
| custom2 | VARCHAR(255) | Custom field 2 for additional data |
| custom3 | VARCHAR(255) | Custom field 3 for additional data |
| custom4 | VARCHAR(255) | Custom field 4 for additional data |
| custom5 | VARCHAR(255) | Custom field 5 for additional data |
| custom6 | VARCHAR(255) | Custom field 6 for additional data |
| custom7 | VARCHAR(255) | Custom field 7 for additional data |
| custom8 | VARCHAR(255) | Custom field 8 for additional data |
| custom9 | VARCHAR(255) | Custom field 9 for additional data |
| custom10 | VARCHAR(255) | Custom field 10 for additional data |
| custom11 | VARCHAR(255) | Custom field 11 for additional data |
| custom12 | VARCHAR(255) | Custom field 12 for additional data |
| custom13 | VARCHAR(255) | Custom field 13 for additional data |
| custom14 | VARCHAR(255) | Custom field 14 for additional data |
| custom15 | VARCHAR(255) | Custom field 15 for additional data |
| custom16 | VARCHAR(255) | Custom field 16 for additional data |
| custom17 | VARCHAR(255) | Custom field 17 for additional data |
| custom18 | VARCHAR(255) | Custom field 18 for additional data |
| custom19 | VARCHAR(255) | Custom field 19 for additional data |
| custom20 | VARCHAR(255) | Custom field 20 for additional data |
| custom21 | VARCHAR(255) | Custom field 21 for additional data |
| custom22 | VARCHAR(255) | Custom field 22 for additional data |
| custom23 | VARCHAR(255) | Custom field 23 for additional data |
| custom24 | VARCHAR(255) | Custom field 24 for additional data |
| custom25 | VARCHAR(255) | Custom field 25 for additional data |
| training_class_name | VARCHAR(100) | Name of the training class |
| trainer_login_id | VARCHAR(100) | Login ID of the trainer |
| trainer_first_name | VARCHAR(100) | First name of the trainer |
| trainer_last_name | VARCHAR(100) | Last name of the trainer |
| enabled_suggestion | TINYINT(1) | Indicates if AI suggestions were enabled for this segment |
| historical_interaction_id | VARCHAR(36) | Unique identifier of the conversation |
| media_type | VARCHAR(50) | Type of media channel (VOICE, CHAT or EMAIL) |
| checklist_form_name | VARCHAR(255) | Name of the checklist form used |
| checklist_form_value | INT(11) | Checklist evaluation result value (total score) |
| checklist_form_failed | TINYINT(1) | Indicates if checklist evaluation failed |