View Data

For every graph, you can see the data that the graph is built upon. Click the “View data” under the graph to see the relevant data for the graph.

View data – description of columns

• ID

  Database record id. Internal use only.

• Start, End

  Start and end time of call.

• Direction

  The direction of the call. OutgoingExternal, IncomingExternal, Internal or Unknown.

• Call Length

  The length of the call in seconds.

• Of Established

  Number of established events. I.e. the number of times the call has been answered by a device in the lifetime of the call.

• Created Time

  Date and time of the creation of the record. Internal use only.

• Initiating Device

  The device where the call initiated. In case of an incoming external call the initiating device is an external trunk. Otherwise it’s the local device starting the call.

• Calling Device

  ID or A-no of the calling device.

• Called Device

  ID or A-no of the called device

• Called device Res. ID

  In case the called device is attached to a Totalview user, the ID points to the users reservation record at the time the device was called.

• Called device State ID

  In case the called device is attached to a Totalview user, the ID points to the users state at the time the device was called.

• Called device Com. State

  In case the called device is attached to a Totalview user, this holds the users current mobile phone state at the time the device was called.

• First Queue device

  The ID of the device where the call was first queued or null if the call was never queued.

• First Queue time

  Time when the call was first queued. The value is in no of seconds from the start of the call.

• First Delivered device

  The ID of the device where the call was first delivered (alerting) or null if the call was never delivered to any device.

• First Delivered time

  Time when the call was first delivered (alerting). The value is in no of seconds from the start of the call.

• First Established device

  The ID of the device where the call was first established (answered) or null if the call was never established.

• First Established time

  Time when the call was first established (answered). The value is in no of seconds from the start of the call.

• Second Established device

  The ID of the device where the call was established (answered) the second time or null if the call was answered only once.

• Second Established time

  Time when the call was established (answered) the second time. The value is in no of seconds from the start of the call.

• Last Established device

  The ID of the device where the call was finally established (answered) or null if the call was never established.

  If the call was established once, the value is the same as FirstEstablished.

  If the call was established twice, the value is the same as SecondEstablished.

  There is no log of devices answering the call between the second and last establish.

• Last Established time

  Time when the call was established (answered) the last time. The value is in no of seconds from the start of the call.

  The LastEstablishedTime can be used to determine if the call was answered after the last transfer. If LastEstablishedTime is greater than LastTransferredTime, then the call was answered after the transfer and the LastEstablishedDevice was the answering device.

• Last Transferring device

  The ID of the device doing the last transfer of the call or null if the call was never transferred.

  There is no log of devices doing transfer of the call prior to the last transfer.

• Last Transferred time

  Time when the call was transferred for the last time. The value is in no of seconds from the start of the call.

• Last Transferred to device

  ID or A-no of the device the call is transferred to.

• Last Transferred to Res. ID

  In case the transferred to device is attached to a Totalview user, the ID points to the users reservation record at the time the call was transferred.

• Last Transferred to State ID

  In case the transferred to device is attached to a Totalview user, the ID points to the users state at the time the call was transferred.

• Last Transferred to Com. State

  In case the transferred to device is attached to a Totalview user, this holds the users current mobile phone state at the time the call was transferred.

• Failed cause, Call ended OK, Debug ID

  Debug fields. Internal use only.