This guide last modified:
2021-04-23 06:46.
.
| Database Schema Tables / Vocera Voice Server Dimension Tables | |
Dimension table delivering details for devices (badges) and smartphones on which the VCS client is installed. These details include the MAC address, serial number, label, status tracking time, owning group, site id, whether the device is shared, and the internal name.
| Column | Description | Example |
|---|---|---|
| TenantID | int This field is for future use only, and is currently not defined. |
|
| InternalName | varchar Displays the unique internal name of the device. |
d-0009ef00009e |
| MACAddress | varchar Displays the MAC address of the device. |
0009ef00009e |
| SerialNo | varchar Displays the serial number of the device. |
A00983XA0400437 |
| Label | varchar Displays the label if it exists. |
SER-07-CG |
| Status | varchar Displays the device status (for example: Active, Secondary, Unregistered, Testing). If device management is not used, this status is always Unregistered. |
Active |
| TrackingTime | varchar Displays the device tracking time. |
2008-10-30 |
| OwningGroup | varchar Displays the group that owns the device. This is populated from the Vocera Voice Server administration console's device management. |
g-services |
| SiteId | varchar Displays the home site id for the device. |
s-mysitename |
| Shared | tinyint Displays 1 if the device is shared or else 0. |
1 |
| Notes | nvarchar Displays the device notes, if any. |
John Smith testing badge |
| Color | varchar Displays color of badge. Applies to badges only. |
|
| LastUpdateDate | timestamp Displays the date and time that the device was last updated. |
2018-01-01 19:15:47 |
| DeviceVersion | varchar Displays the device version. |
B1000 |
| DeviceType | varchar Displays the device type. |
Badge |
| DeletedFlag | tinyint Displays 1 if deleted or else 0. |
0 |
This guide last modified:
2021-04-23 06:46.
.