Database Schema Tables / Vocera Voice Server Fact Tables |
Stores data about Vocera Voice Server message activity in Vocera.
Column | Description | Example |
---|---|---|
TxMillis | bigint Gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date |
1507565242852 |
TxDateTime | datetime Stores the date and time of an event, accurate to the second. |
2017-10-09 09:07:22 |
TxDate |
Stores the date of an event, accurate to the day. |
2017-10-09 |
SenderType | varchar Specifies which type of user initiated the message activity. Example values: User, Phone. |
User |
SenderID | varchar Specifies the user ID of the person who initiated the message activity. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Voice Server. |
jsmith |
SenderSite | varchar Displays site details for the sender. |
MySenderSite |
Operation | varchar Specifies the operation. |
LeaveMessage |
ReceiverType | varchar Specifies which type of user received the message activity. Example values: User, Phone, Group. |
Group |
ReceiverID | varchar Specifies the Vocera user/group ID of the receiver. |
IT |
ReceiverSite | varchar Displays site details for the receiver. |
MyReceiverSite |
Duration | bigint Specifies the duration of the voice message in seconds. |
41 |
IdMsgActivity | bigint Identifies a voice message activity. However, this value is not guaranteed to be unique. Any given message activity could have the same IdMsgActivity value as another Message Activity that took place earlier or later. |
|
IdGenie | bigint A unique integer that identifies a Genie session. A single Genie session may comprise several events. For example, a Genie session for a badge-to-badge call may include the "Vocera" prompt played on the calling party's badge and the "Can you talk to ..." prompt played on the called party's badge. |
8107 |
senderName | varchar Displays the sender's display name in "Lastname, Firstname" format. |
Smith, John |
receiverName | varchar Displays the receiver's display name in "Lastname, Firstname" format. |
Doe, Jane |
receiverU_Id | varchar Specifies the Vocera user internal id or group id of the receiver. |
u-jdoe |
senderU_Id | varchar Specifies the Vocera user internal id or group id of the sender. |
u-jsmith |