sm_appl table

The sm_appl table holds the information used to produce the Application report.

Table definition

sm_appl:
  system_name varchar(15),
  appl_name varchar(15) not null,
  appl_hups int,
  caller_hups int,
  total_calls int,
  duration int,
  time_stamp timestamp

Fields

appl_hups
Number of hang-ups originated by application
appl_name
Value of first_stbl in sm_ccr.
caller_hups
Number of hang-ups originated by the caller
duration
Duration of the call in seconds
system_name
The Blueworx Voice Response system to which the data applies.
time_stamp
A 30 minute time period (date and time).
total_calls
Total calls processed by the application.