Database Schema Tables / Vocera Voice Server Fact Tables |
Fact table delivering detailed insight on calls.
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 Vocera Voice Server caller user id. If the caller is a telephone or extension, this displays the calling number. |
u-jsmith |
CallerName | varchar Displays the caller name specified in the Vocera Voice Server. For a telephone, this displays the calling number. |
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 home site of the caller. |
MyCallerSite |
CallType | varchar Displays the call type (for example: Unicast, Multicast). |
Unicast |
CallToType | varchar Displays the entity that the call is going to (for example: Address Book, Broadcast, Buddy, Group, Telephone, User). |
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 is last party involved. For others, it will be set to 0. If CallToType is Broadcast this will be set to 0 for all users. If CallToType is User, it will be 1. |
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 receiver userid. |
u-jsmith |
ReceiverName | varchar Displays the receiver user name specified in the Vocera Voice Server. |
JSmith |
ReceiverDisplayName | varchar Displays the display name for the receiver in the format "Lastname, Firstname". |
Smith, John |
ReceiverUserSite | varchar Displays the user home site for the receiver. |
MyReceiverSite |
ReceiverGroupId | varchar Displays the internal group id for the receiver. This field is used in group calls and multicasts only. |
g-engineering |
ReceiverGroupName | varchar Displays the group name for the receiver. This field is used in group calls and multicasts 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 by the caller, 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 |
Priority | varchar Specifies the call priority (for example: normal, urgent). |
normal |
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 receiver disconnected the call or broadcast. |
2017-12-06 00:16:35 |
CallerSite | varchar Displays the site where the caller placed the call or broadcast. |
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 department ids. Set to Unknown if the caller is not part of any department. |
g-operations |
ReceiverSite | varchar Displays the site where the receiver received the call. |
MyReceiverSite |
ReceiverAccessPoint | varchar Displays the receiver access point. |
707db9767761 |
ReceiverLocation | varchar Displays the receiver location. |
Engineering |
ReceiverDepartments | varchar Displays a comma-separated list of receiver department ids. Set to Unknown if the receiver is not part of any department. |
g-tech_support |
ReceiverGroupDepartments | varchar For group calls and broadcasts, displays a comma-separated list of receiver group departments, or Unknown if there are no departments. For other calls, this is null. |
g-tech_support |