fctlogins

Fact table delivering detailed insight and events associated with Vocera Voice Server logins.

Table 1. fctlogins table
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.
DeviceID	`varchar` Displays, as a hexadecimal number, the id of the device used by the user that is logging in.	`0009ef11039f`
DeviceType	`varchar` Displays the device type.	`Badge`
DeviceVersion	`varchar` Displays the version of the device.	`B3000`
UserName	`varchar` Displays the user name.	`u-jsmith`
UserDisplayName	`varchar` Displays the user display name in "Lastname, Firstname" format.	`Smith, John`
Site	`varchar` Displays the site.	`MySiteName`
LoggedInAt	`timestamp` Displays date and time at which the login occurred.	`2017-12-13 13:39:34`
LoggedOutAt	`timestamp` Displays the date and time that the user logged out.	`2017-12-13 13:40:03`
SimultaneousUsersLoggedIn	`int` This field is for future use only, and is currently set to 0.
SimultaneousUsersLoggedInBySite	`int` This field is for future use only, and is currently set to 0.
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`
DeviceSite	`varchar` Displays the device's home site.	`MyDeviceSite`
DeviceSerialNo	`varchar` Displays, as a hexadecimal number, the device serial number.	`E6ED13115482`
UserSite	`varchar` Displays the user's home site.	`MyUserSite`
AccessPoint	`varchar` Displays, as a hexadecimal number, the site access point.	`707db996322e`
Location	`varchar` Displays the location of the site access point.	`Second Floor`
userDepartments	`varchar` A comma-separated list of internal department ids.	`g-daisy,g-engineering`