fctdevicestatuschange

Fact table delivering detailed insight on device status changes.

Table 1. fctdevicestatuschange table
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