anl_dim_device_status

Stores a distinct set of device statuses.

Table 1. anl_dim_device_status table
Column Description Example
status_id

bigint

The unique device status id.

2
source_id

bigint

The source id of the appliance providing data.

1
status_name

varchar

The device status (Registered, Disconnected, Delivery, UnRegistered).

Registered
created_at

datetime

The creation date.

2017-12-06 04:32:31.069000
updated_at

datetime

The last updated date.

2017-12-06 04:32:31.069000
control_id

bigint

The control id, indicating when the record was loaded or updated.

12637