This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Vocera Voice Server Fact Tables | |
Fact table delivering detailed insight associated with device activity.
| 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. |
|
| DeviceOnlineSessionId | int A unique integer that identifies this device activity session. |
|
| DeviceId | varchar Displays, as a hexadecimal number, the id of the device used by the user that is logging in. |
ddd01fbf328e |
| DeviceType | varchar Displays the device type. |
Android |
| DeviceVersion | varchar Displays the device version. |
Android VCS |
| Site | varchar The name of the site where the device is currently located. |
MySiteName |
| StartedAt | timestamp Displays the date and time at which the device activity started. |
2017-11-18 09:04:11 |
| FinishedAt | timestamp Displays the date and time at which the device activity ended. |
2017-11-18 09:06:11 |
| OnlineSeconds | int Displays the online duration time in seconds. |
120 |
| BatchId | int This field is for future use only, and is currently set to 0. |
|
| RowCreatedTS | timestamp Displays the row creation timestamp. |
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. |
H4ZK14300B7F |
| AccessPoint | varchar Displays, as a hexadecimal number, the site access point. |
707db9767761 |
| Location | varchar Displays the location of the site access point. |
Second Floor |
| UserName | varchar Displays the Vocera Voice Server internal user id of the user who is using the device. |
u-jsmith |
| PingState | varchar Displays the ping/UI state of the device. This can be either Active or Standby. |
Standby |
| OwningGroupName | varchar Displays the name of the device owning group, or null if it does not exist. |
Engineering |
| OwningGroupDepartments | varchar Specifies a comma-separated list of the internal department ids of the owning group. If the owning group is not assigned, this is null. |
g-engineering |
| UserDisplayName | varchar Specifies the user display name in "Lastname, Firstname" format. |
Smith, John |
| UserDepartments | varchar Specifies a comma-separated list of the user's internal department ids. |
g-logistics |
| UserSite | varchar Displays the user's home site. |
MyUserSite |
| Label | varchar Displays the label that appears when the user performs an activity. |
|
| Status | varchar Displays the device status. |
Unregistered |
| TrackingTime | varchar Displays the device tracking time. |
|
| Notes | nvarchar Displays notes about the device activity, if any. |
Test Message |
| OwningGroupSite | varchar Displays the site name of the device's owning group, if any. |
MyGroupSite |
| OwningGroupID | varchar Displays the internal group id of the device's owning group, if any. |
g-engineering |
This guide last modified:
2021-04-23 06:46.
.