From Bright Pattern Documentation
(Created page with "<translate> = teams = QQQ The ''teams'' table contains QQQ == Description of Data == The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DA...") |
|||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
= teams = | = teams = | ||
| − | + | The ''teams'' table contains metrics that describe the team(s) defined in contact center configuration. | |
| − | The ''teams'' 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 ''agent_performance'' table. | 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_performance'' table. | ||
| + | |||
{|border="1" style="border-collapse:collapse" cellpadding="5" | {|border="1" style="border-collapse:collapse" cellpadding="5" | ||
| Line 14: | Line 13: | ||
|- | |- | ||
|'''name''' | |'''name''' | ||
| − | | | + | |VARCHAR |
| − | | | + | |Team name as defined in configuration |
|- | |- | ||
|'''start_time''' | |'''start_time''' | ||
| − | | | + | |DATETIME |
| − | | | + | |Activity start time. |
| + | |||
| + | Time is given in the Coordinated Universal Time (UTC) time zone. | ||
|- | |- | ||
|'''end_time''' | |'''end_time''' | ||
| − | | | + | |DATETIME |
| − | | | + | |Activity end time. |
| + | |||
| + | Time is given in the Coordinated Universal Time (UTC) time zone. | ||
|- | |- | ||
|} | |} | ||
Revision as of 19:12, 12 September 2018
<translate>
teams
The teams table contains metrics that describe the team(s) defined in contact center configuration.
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_performance table.
| Column Name | Data Type | Description |
| name | VARCHAR | Team name as defined in configuration |
| start_time | DATETIME | Activity start time.
Time is given in the Coordinated Universal Time (UTC) time zone. |
| end_time | DATETIME | Activity end time.
Time is given in the Coordinated Universal Time (UTC) time zone. |
</translate>