sm_ccr table

The sm_ccr table is used to store the call detail record if the Call Detail Record Logging parameter is set to DB2 or Both (see Table 1). (Note that standard reports can always be generated regardless of the setting of the Call Detail Record Logging parameter.)

Table definition

sm_ccr:

  system_name varchar(15)

  calling_no varchar(20)

  called_no varchar(20)

  asi_no smallint

  trunk_no smallint

  line_no smallint

  last_state_label varchar(15)

  setup_time smallint

  time_offhook int

  first_stbl varchar(15)

  duration smallint

  in_call char

  appl_hups int

  caller_hups int

  transfer int

  call_seq_no int

  user_key varchar(10)

  time_stamp timestamp

Fields

appl_hups: Number of hang-ups originated by application.
asi_no: A system identifier. The source of the SYS value in the call detail record in cdr.log.
caller_hups: Number of hang-ups originated by the caller.
calling_no: Calling number for this call. The source of the CGN value in the call detail record in cdr.log.
called_no: Called number for this call. The source of the CDN value in the call detail record in cdr.log.
call_seq_no: Device driver call record sequence number.
duration: Duration of the call, from off-hook to on-hook, in seconds.
first_stbl: Application name.
in_call: Incoming or outgoing call flag. The source of the CLT value in the call detail record in cdr.log.
last_state_label: The label of the state executed before CloseEverything or TerminateCall action.
line_no: The number of the channel on which the call was placed. The source of the CHN value in the call detail record in cdr.log.
setup_time: Call setup duration in seconds. This is the length of time that elapses from the detection of an incoming call until the caller is connected to a voice application, or the time that elapses from the beginning of outbound dialing until the called party answers. The source of the CSD value in the call detail record in cdr.log.
system_name: The Blueworx Voice Response system to which the data applies.
time_offhook: The time at which the call started (the time at which Blueworx Voice Response went off-hook). This is recorded as the number of seconds that have elapsed since 1 January 1970.
time_stamp: Time stamp based on time_offhook. The source of the DAT value in the call detail record in cdr.log.
transfer: Not currently used.
trunk_no: The number of the trunk on which the call was placed. The source of the TNK value in the call detail record in cdr.log.
user_key: A user-defined key set in state tables using the System : Reports : CDR user key system variable (SV240).