Database Schema Tables / Vocera Voice Server Fact Tables |
Fact table delivering detailed insight on device status changes.
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. |
1510749827261 |
TxDateTime | datetime Stores the date and time of an event, accurate to the second. |
2017-11-15 04:43:47 |
TxDate | date Specifies the date the device status was changed. |
2017-11-15 |
DeviceID | varchar Specifies the device id as the device MAC address. |
ddd01fbf328e |
DeviceSite | varchar Specifies the home site to which the device is mapped. |
MyDeviceSite |
Status | varchar Specifies the device status. |
Sent for Repair |
Notes | text Specifies the notes that the user has entered. |
Analytics testing |
DeviceType | varchar Displays the device type. |
iOS |
DeviceVersion | varchar Displays the device version. |
Apple VCS |
OwningGroupID | varchar Displays the id of the group that owns the device. |
g-engineering |
OwningGroupSite | varchar Displays the site of the group that owns the device. |
MyGroupSite |
OwningGroupName | varchar Displays the name of the group that owns the device. |
Engineering |
SerialNo | varchar Displays the serial number of the device. |
Analytics testing |
Label | varchar The label for the device. |
Vocera analytics |