Contents
- Introduction
- Statistical Data
- General Information About Statistical Data
- agent_performance
- team_performance
- service_in_time_counters
- service_performance
- overflow_counters
- disposition_counters
- callback_counters
- requested_skills
- scenario_step_counters
- concurrent_users
- Detailed Records
- 1 General Information About Detailed Records
- agent_activity
- call_detail
- interaction_step_skills
- interaction_quality_monitoring
- interaction_quality_monitoring_grades
General Information About Detailed Records
The tables specified in this section contain detailed information about all agent activities and all interactions that either entered, or were initiated from, the ServicePattern system. The data in these tables can be used, for example, for quality management tasks, which require searching for specific interactions based on combinations of specific criteria. These data can also be used for development of custom metrics that are not available from the aggregation tables specified in the previous sections.
Detailed records are created from the raw event data that is initially written to the collector database (DB1) in real-time by various ServicePattern components. This raw data is periodically extracted by the Aggregator component, transformed into records, and loaded into the tables of the Reporting Database (DB2). The standard aggregation period is 15 minutes; therefore, under normal circumstances, the data in the detailed records for completed interactions and agent activities appear in these tables with a maximum delay of 15 minutes.