Database Schema Tables / Vocera Voice Server Fact Tables |
Stores data about adding or removing users from a group.
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. |
1512166469296 |
TxDateTime | datetime Stores the date and time of an event, accurate to the second. |
2017-12-01 14:14:29 |
TxDate | date Stores the date of an event, accurate to the day. |
2017-12-01 |
UserType | varchar Specifies which type of user initiated the group action. Example values: User, Phone. |
User |
UserID | varchar Specifies the user ID of the person who initiated the group action. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Voice Server. |
jsmith |
UserSite | varchar In a multi-site installation, the UserSite column specifies the Vocera site with which the user is associated. In a single-site installation, this value is null. |
MyRemoteLocation |
Operation | varchar Specifies the operation, either AddToGroup or RemoveFromGroup. |
AddToGroup |
GroupName | varchar Specifies the Vocera group to which the party was added or from which the party was removed. |
MyGroupName |
GroupSite | varchar In a multi-site installation, the GroupSite column specifies the Vocera site associated with the group to which the party was added or removed to/from. In a single-site installation, this value is null. |
MyGroupSiteLocation |
PartyID | varchar Specifies the user ID of the party (person/entity) who was added or removed to/from the group. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Voice Server. |
jsmith |
PartySite | varchar In a multi-site installation, the UserSite column specifies the Vocera site with which the party is associated. In a single-site installation, this value is null. |
MyPartySiteLocation |
IdGenie | bigint An 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 caller's badge. |
125 |
modifierDisplayName | varchar Specifies the user Display Name of the person who initiated the group operation. This value corresponds to a LastName, FirstName pair specified via the Administration Console or the User Console on the Vocera Voice Server. |
Smith, John |
modifierUID | varchar Specifies the Vocera Voice Server internal user id of the person who initiated the "add to group" or "remove from group" operation. |
u-jsmith |
groupId | varchar Specifies the Vocera internal group ID to which the party was added, or from which the party was removed. |
g-qa |
partyUID | varchar Specifies the Vocera Voice Server of the party who was added to or removed from the group. |
u-jdoe |
partyDisplayName | varchar Specifies the user Display Name of the party who was added to or removed from the group. This value corresponds to a LastName,FirstName specified via the Administration Console or the User Console on the Vocera Server. |
Doe, Jane |