From Bright Pattern Documentation
Jump to: navigation, search
• 3.10 • 3.11 • 3.12 • 3.13 • 3.14 • 3.15 • 3.16 • 3.17 • 3.18

interaction_step_skills

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 – Primary service skill (a skill that is created automatically for each new service)
  • SKILL – Auxiliary skill (a skill that is not directly associated with any particular service)
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
short_abandonment_threshold INT Reserved



[[reporting-database-specification/call_detail< Previous]] | Next >