Database Schema Tables / Database View Tables |
This view gets information on calls and broadcasts with their required fields.
Column | Description | Example |
---|---|---|
TenantID | int This field is for future use only, and is currently set to 0. |
|
TenantName | varchar This field is for future use only, and is currently set to blank. |
|
CallerDeviceID | varchar Displays the MAC address of the calling device. For telephone calls, this may be the name or extension of the caller. |
ddd01fbf328c |
CallerDeviceType | varchar Displays the device type. |
Android |
CallerDeviceVersion | varchar Displays the device version. |
Android VCS |
CallerId | varchar Displays the internal caller id. If the caller is a telephone or extension, this displays the calling number. |
u-jsmith |
CallerDisplayName | varchar Displays the caller display name in "Lastname, Firstname" format. For a telephone, this displays the calling number. |
Smith, John |
CallerUserSite | varchar Displays the user site of the caller. |
MyCallerSite |
CallType | varchar Displays the call type (for example: Unicast, Multicast, Broadcast). |
Unicast |
CallToType | varchar Displays the entity that the call is going to (for example: User, Telephone, Address Book). |
Address Book |
CallId | bigint Displays the call id. |
85390967418 |
PartyNumber | int When calling to a group, this field displays the order in which members of the group are called. The first member called will have a party number of 1, the second will be 2, and so on. |
1 |
LastParty | tinyint Indicates whether this group member being called is the last party involved in a group call. Set to 1 if the user received the call, and 0 otherwise. |
0 |
ReceiverDeviceId | varchar The MAC address of the receiver. In telephone calls, this can be the name or extension number. |
0009ef345661 |
ReceiverDeviceType | varchar Displays the device type for the receiver. |
Badge |
ReceiverDeviceVersion | varchar Displays the device version for the receiver. |
B3000N |
ReceiverId | varchar Displays the internal Vocera Voice Server id of the receiver user. |
u-jsmith |
ReceiverDisplayName | varchar Displays the display name for the receiver in the format "Lastname, Firstname". |
Smith, John |
ReceiverUserSite | varchar Displays the user site for the receiver. |
MyReceiverSite |
ReceiverGroupId | varchar Displays the group id for the receiver. This field is used in group calls and broadcasts only. |
g-engineering |
ReceiverGroupName | varchar Displays the group name for the receiver. This field is used in group calls and broadcasts only. |
Engineering |
CallDurationSS | int Displays the call duration in seconds. |
92 |
TalkingDurationSS | int Displays the talking duration in seconds, or null if there was no talking in the call. |
89 |
DialingDuration | int Displays the dialing duration. This field is currently not used in any dashboards. |
|
InitiatedAcceptedDuration | int Displays the initiation accepted duration in seconds. |
2 |
InitiatedAt | timestamp Displays the date and time on which the call was initiated. |
2017-11-17 17:12:53 |
StartedAt | timestamp Displays the date and time at which the server interrupted the user. |
2017-11-17 17:12:54 |
ReachedAt | timestamp Displays the date and time at which the receiver was reached. This is normally the time in the InitiatedAt field plus the number of seconds specified in the InitiatedAcceptedDuration field. |
2017-11-17 17:14:53 |
UnavailableAt | timestamp If the caller is unavailable or has rejected the call, the date and time at which the receiver was unavailable. If the caller is available, this field is null. |
2017-11-17 17:14:53 |
UnavailableReason | varchar Displays the reason for unavailability. Examples: Call rejected, Not online. If the receiver is available, this field is set to Available. |
Not online |
AcceptedAt | timestamp The date and time at which the call was accepted. If the receiver was not available, this field is null. |
2017-11-17 17:14:53 |
AbortedAt | timestamp If the call was aborted, the date and time at which this happened. If the call was not aborted, this field is null. |
2017-11-17 17:14:53 |
AbortReason | varchar Displays the reason why the call was aborted. |
Canceled |
FinishedAt | timestamp The date and time at which the call was finished. |
2017-11-17 17:14:53 |
BatchId | int This field is for future use only, and is currently set to 0. |
|
RowCreatedTS | timestamp The date and time when this table row was created. |
2017-12-06 00:16:35 |
RowUpdatedTS | timestamp The date and time when this table row was updated, or null if it has not been updated. |
2017-12-06 00:16:35 |
TotalOnHoldCount | int Displays the number of times that the call was put on hold. |
1 |
TotalOnHoldDuration | int Displays the total amount of on hold time in seconds. |
13 |
CallerDeviceSite | varchar Displays the site of the caller device. |
MyDeviceSite |
CallerDeviceSerialNo | varchar Displays the serial number of the caller device. |
K5EB16313222 |
ReceiverDeviceSite | varchar Displays the site of the receiver device. |
MyReceiverSite |
ReceiverDeviceSerialNo | varchar Displays the serial number of the receiver device. |
H4AA15300EF4 |
DisconnectedAt | timestamp The date and time that the call was disconnected. |
2017-12-06 00:16:35 |
CallerSite | varchar Displays the caller site. |
MyCallerSite |
CallerAccessPoint | varchar Displays the caller access point. |
707db95e2461 |
CallerLocation | varchar Displays the caller location. |
Operations |
CallerDepartments | varchar Displays a comma-separated list of caller departments. |
g-operations |
ReceiverSite | varchar Displays the receiver site. |
MyReceiverSite |
ReceiverAccessPoint | varchar Displays the receiver access point. |
707db9767761 |
ReceiverLocation | varchar Displays the receiver location. |
Engineering |
callerGenericDeviceTypeId | varchar The caller's generic device type id (for example: badge, telephone). |
badge |
severity | varchar Displays the severity (normal or urgent). |
normal |
callerGenericDeviceType | varchar The caller's generic device type (for example: Badge, Telephone). |
Badge |
receiverGenericDeviceTypeId | varchar The receiver's generic device type id (for example: badge, telephone). |
badge |
callerGenericDeviceType | varchar The receiver's generic device type (for example: Badge, Telephone). |
Badge |
callerdepartments | varchar The caller's departments. |
g-engineering0 |
receiverdepartments | varchar The departments of the receiver's group. |
g-order_admin |
ReceiverGroupDepartments | varchar Displays the receiver location. |
Engineering |