anl_dim_user_devices

Stores users and device use over time (use start, use end).

Table 1. anl_dim_user_devices table
Column Description Example
user_device_id

bigint

The unique id of the device user.

1
source_id

bigint

The source id of the appliance providing the data.

1
device_id

bigint

The device id.

13
device_identifier

varchar

The device identifier.

02af6b70-ba1b-423b-a3d5-0b001c1430c3
user_id

bigint

The user id.

82
user_login

varchar

The user login name.

johnsmith
device_use_started

datetime

The time of the first activity of the user and device (Registered, Disconnected, Deliver).

2017-11-14 10:03:38.444000
device_use_ended

datetime

The time of the last activity of the user and device (Disconnected, UnRegistered).

2017-11-15 08:29:56.570000
created_at

datetime

The creation date.

2017-12-06 04:34:26.899000
updated_at

datetime

The last updated date.

2017-12-06 04:34:26.899000
control_id

bigint

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

12637