From Bright Pattern Documentation
(Marked this version for translation) |
(Updated via BpDeleteTranslateTags script) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | = requested_skills= | |
The ''requested_skills'' table contains metrics for interactions that requested a specific skill. | The ''requested_skills'' table contains metrics for interactions that requested a specific skill. | ||
| − | |||
Unless noted otherwise with respect to a particular metric, any ''call'' mentioned in this table shall be interpreted as a call that requested the skill specified in the ''skill_name'' field. | Unless noted otherwise with respect to a particular metric, any ''call'' mentioned in this table shall be interpreted as a call that requested the skill specified in the ''skill_name'' field. | ||
| − | == 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 ''requested_skills'' 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 ''requested_skills'' table. | ||
| − | |||
{|border="1" style="border-collapse:collapse" cellpadding="5" | {|border="1" style="border-collapse:collapse" cellpadding="5" | ||
|'''Column Name''' | |'''Column Name''' | ||
| Line 36: | Line 34: | ||
|This is the interaction media type. | |This is the interaction media type. | ||
| − | |||
Possible values include VOICE, CHAT, and EMAIL. | Possible values include VOICE, CHAT, and EMAIL. | ||
| − | |||
If set to CHAT, any ''call'' mentioned in this table shall be interpreted as a service chat interaction in the same context. | If set to CHAT, any ''call'' mentioned in this table shall be interpreted as a service chat interaction in the same context. | ||
|- | |- | ||
| Line 54: | Line 50: | ||
|This is the skill type. | |This is the skill type. | ||
| − | |||
Possible values include the following: | Possible values include the following: | ||
* SERVICE – Primary service skill (a skill that is created automatically for each new service) | * SERVICE – Primary service skill (a skill that is created automatically for each new service) | ||
| Line 79: | Line 74: | ||
|Number of calls that were distributed to overflow destinations | |Number of calls that were distributed to overflow destinations | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 04:03, 29 May 2024
• 日本語
requested_skills
The requested_skills table contains metrics for interactions that requested a specific skill.
Unless noted otherwise with respect to a particular metric, any call mentioned in this table shall be interpreted as a call that requested the skill specified in the skill_name 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 requested_skills table.
| Column Name | Data Type | Description |
| id | BINARY (16) | Primary key |
| start_time | DATETIME | Start time of the aggregation interval; time is given in Universal Coordinated Time (UTC) |
| end_time | DATETIME | End time of the aggregation interval; time is given in Universal Coordinated Time (UTC) |
| agg_run_id | BINARY (16) | Aggregator run that produced this record |
| media_type | ENUM | This is the interaction media type.
Possible values include VOICE, CHAT, and EMAIL. If set to CHAT, any call mentioned in this table shall be interpreted as a service chat interaction in the same context. |
| skill_name | VARCHAR | Skill name as defined in configuration |
| skill_group_name | VARCHAR | Name of the skill group that the skill belongs to as defined in configuration |
| skill_type | ENUM | This is the skill type.
Possible values include the following:
|
| total_answer_time | BIGINT | Total answer time (the sum of times between the moments the calls entered queue and were answered by agents) |
| num_calls_received | BIGINT | Total number of received calls |
| num_calls_queued | BIGINT | Number of calls that were queued |
| num_calls_answered | BIGINT | Number of calls that were answered |
| num_calls_overflow | BIGINT | Number of calls that were distributed to overflow destinations |