(Created new topic from branched topic Documentation:ServicePattern:reporting-database-specification:interaction_step_skills:5.1)
|Line 52:||Line 52:|
Latest revision as of 21:39, 3 August 2018
Each row of the interaction_step_skills table specifies a skill requested during an interaction referred to in the interaction_step_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 interaction_step_skills table.
|Column Name||Data Type||Description|
|id||BINARY (16)||Primary key|
|interaction_step_id||BINARY (16)||interaction_step_id is the identifier of the interaction during which this skill was requested. Typically, this is the identifier for the interaction segment of the party that originated this interaction (field caller_interaction_step_id of the call_detail table).|
|name||VARCHAR||Skill name as defined in configuration|
|group_name||VARCHAR||Name of the group that this skill is assigned to as defined in configuration|
|type||ENUM||type is the skill type.
Possible values include the following:
|service_level||INT||Target percentage of calls that shall be answered within the time specified in the service_level_threshold field as defined in configuration|
|service_level_threshold||INT||Service level threshold as defined in configuration|