groupactivity

The groupactivity table stores data about changes to Vocera groups when members are added or removed. This table has a primary key based on the TxMillis column.

Table 1. groupactivity table
Column Description
TxMillis

bigint(15) unsigned NOT NULL default '0'

The TxMillis column 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 and time of the event. See TxDateTime.

TxMillis

datetime NOT NULL default '0000-00-00 00:00:00'

The TxDateTime column stores the date and time of an event, accurate to the second.

TxDate

date NOT NULL default '0000-00-00'

The TxDate column stores the date of an event, accurate to the day.

UserType

varchar(20) NOT NULL default ''

Specifies which type of user who initiated AddToGroup and RemoveFromGroup. Example values: User, Phone

UserID

varchar(70) default NULL

Specifies the user ID of the person who initiated AddToGroup and RemoveFromGroup. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server.

UserSite

varchar(50) default NULL

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.

Operation

varchar(64) NOT NULL default ''

Specifies the operation, either addtogroup or removefromgroup.

GroupName

varchar(50) default NULL

Specifies the Vocera group to which the party was added ot from which the party was removed.

GroupSite

varchar(50) default NULL

In a multi-site installation, the GroupSite column specifies the Vocera site associated with the group whose membership was modified. In a single-site installation, this value is null.

PartyID

varchar(70) default NULL

Specifies the user ID of the person who was added to or removed from the group. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server.

PartySite

varchar(50) default NULL

In a multi-site installation, the PartySite column specifies the Vocera site with which the user who was added to or removed from the group is associated. In a single-site installation, this value is null.

IdGenie

bigint(15) unsigned NOT NULL default '0'

The IdGenie column identifies a Genie session. A single Genie session may comprise several events. For example, a Genie session for a badge-tobadge 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.

In the table, rows for events in the same Genie session have the same value in the IdGenie column. However, this value is not guaranteed to be unique. Any given Genie session could have the same IdGenie value as another Genie session that took place earlier or later. One way to distinguish Genie sessions is to compare values in the TxMillis column.