From Bright Pattern Documentation
(Created page with "<translate> = agents = QQQ The ''agents'' table contains QQQ == Description of Data == The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT,...") |
|||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
= agents = | = agents = | ||
| − | + | The ''agents'' table contains agent metrics. Note that interaction-related metrics are counted separately for each service that the agent provided within the aggregation interval. Thus, unless noted otherwise with respect to a particular metric, any interaction mentioned in this table shall be interpreted as an interaction associated with the service specified in the service_name field that was handled by the agent identified by the login_id field. | |
| − | The ''agents'' table contains | ||
| − | |||
== Description of Data == | == Description of Data == | ||
| − | The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the '' | + | The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the ''agent'' table. |
| + | |||
{|border="1" style="border-collapse:collapse" cellpadding="5" | {|border="1" style="border-collapse:collapse" cellpadding="5" | ||
| Line 13: | Line 12: | ||
|'''Description''' | |'''Description''' | ||
|- | |- | ||
| − | |''' | + | |'''end_time''' |
| − | | | + | |DATETIME |
| − | | | + | |End time of the aggregation interval |
|- | |- | ||
|'''first_name''' | |'''first_name''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Agent first name as defined in configuration |
|- | |- | ||
|'''last_name''' | |'''last_name''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Agent last name as defined in configuration |
|- | |- | ||
| − | |''' | + | |'''login_id''' |
| − | | | + | |VARCHAR |
| − | | | + | |Agent login as defined in configuration |
|- | |- | ||
|'''rank''' | |'''rank''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Agent rank as defined in configuration |
|- | |- | ||
|'''start_time''' | |'''start_time''' | ||
| − | | | + | |DATETIME |
| − | | | + | |Start time of the aggregation interval |
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| + | |'''team_name''' | ||
| + | |VARCHAR | ||
| + | |Name of the team that the agent is assigned to as defined in configuration | ||
|} | |} | ||
Revision as of 18:16, 11 September 2018
<translate>
agents
The agents table contains agent metrics. Note that interaction-related metrics are counted separately for each service that the agent provided within the aggregation interval. Thus, unless noted otherwise with respect to a particular metric, any interaction mentioned in this table shall be interpreted as an interaction associated with the service specified in the service_name field that was handled by the agent identified by the login_id field.
Description of Data
The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the agent table.
| Column Name | Data Type | Description |
| end_time | DATETIME | End time of the aggregation interval |
| first_name | VARCHAR | Agent first name as defined in configuration |
| last_name | VARCHAR | Agent last name as defined in configuration |
| login_id | VARCHAR | Agent login as defined in configuration |
| rank | VARCHAR | Agent rank as defined in configuration |
| start_time | DATETIME | Start time of the aggregation interval |
| team_name | VARCHAR | Name of the team that the agent is assigned to as defined in configuration |
</translate>