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.

Last edited on September 13th, 2017