Business Intelligence (BI) Interface Guide › Business Intelligence Interface › SQL Interfaces › Service Level Interface

Service Level Interface

The Service Level Interface is the main reporting interface. They provide access to the calculated service level data.

The interface is made up of the following fourteen views:

• Seven basic views containing the most commonly used fields:
  • v_psl_1_all - Basic view of tracking period calculations.
  • v_psl_0_hour - Basic view of hourly calculations.
  • v_psl_0_day - Basic view of daily calculations.
  • v_psl_0_week - Basic view of weekly calculations.
  • v_psl_0_month - Basic view of monthly calculations.
  • v_psl_0_quarter - Basic view of quarterly calculations.
  • v_psl_0_year - Basic view of yearly calculations.
• Seven views containing additional fields for more complex usage:
  • v_psl_all_extended - Enhanced view of tracking period calculations.
  • v_psl_hour_extended - Enhanced view of hourly calculations.
  • v_psl_day_extended - Enhanced view of daily calculations.
  • v_psl_week_extended - Enhanced view of weekly calculations.
  • v_psl_month_extended - Enhanced view of monthly calculations.
  • v_psl_quarter_extended - Enhanced view of quarterly calculations.
  • v_psl_year_extended - Enhanced view of yearly calculations.

The views expose only records in the PSL tables that are relevant for reporting, meaning only records that meet the following criteria:

• Contain calculations of complete periods or incomplete periods, but not records that contain predictions ("best/worse").
• Contain calculations of reportable metrics.