User Actions View

Name	ActionsUser
Type	View
Description	A normalized version of the Completed Actions table that includes only back office actions, claim and dispute attributes for filtering/analysis, and actual user names from the User Profile table.

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value
Key	TenantId	VARCHAR(32)	Unique ID associated with each Quavo client.	ALWAYS	qvo-stg
Key	Tenant	VARCHAR(64)	A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID.	ALWAYS	Default
Key	ClientId	VARCHAR(64)	A unique ID representing a single client.	ALWAYS	Default
Key	Client	VARCHAR(64)	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
Claim Details	ClaimType	VARCHAR(64)	See Transaction Type.	CONDITIONAL	Card-Pinless
Claim Details	ClaimCategory	VARCHAR(64)	General categorization of the claim. For a more precise description, see Claim Reason.	CONDITIONAL	Fraud
Claim Details	ClaimReason	VARCHAR(64)	Identifies the specific reason associated with the claim.	CONDITIONAL	Stolen
Compliance Details	RegulatoryCoverage	VARCHAR	Identifies the specific reason associated with the claim.	CONDITIONAL	Reg E
Task Details	Flow	VARCHAR	Name of flow where assignment is generated.	CONDITIONAL	Manual Fraud Reporting
Task Details	Assignment	VARCHAR	Name of the task associated with the action.	CONDITIONAL	Manual Fraud Reporting
Action Details	Action	VARCHAR	Name of the action that was completed.	ALWAYS	Report Fraud
Action Details	CompletedBy	VARCHAR	First initial and last name of the user that completed the action.	ALWAYS	D. Robertson
Action Details	ActionDateTime	DATE	Datetime that the action was completed.	ALWAYS	2023-09-09
Task Details	Parent	VARCHAR	Identifies a relationship to a claim or a dispute.	ALWAYS	OPEN