User Active Intervials View

Name	UserActiveIntervals
Type	View
Description	A count of actions completed by users in 30 minute intervals. Only intervals with at least one completed action are included and these are considered active intervals.

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value
Key	TenantId	VARCHAR	Unique ID associated with each Quavo client.	ALWAYS	qvo-stg
Key	Tenant	VARCHAR	A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID.	ALWAYS	Default
Key	ClientId	VARCHAR	A unique ID representing a single client.	ALWAYS	Default
Key	Client	VARCHAR	A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant. Each client is assigned a unique Client ID.	ALWAYS	Default
Activity Details	PerformedByUserName	VARCHAR	Username of the user that completed the action.	ALWAYS	devan.robertson@quavo.com
Activity Details	PerformedBy	VARCHAR	First initial and last name of the user that completed the action.	ALWAYS	D. Robertson
Activity Details	Interval	DATE	Datetime that represents the start time of a 30 minute activity interval.	ALWAYS	2024-11-23 00:00:00.000
Activity Details	Actions	Number	Count of actions completed during interval.	ALWAYS	3