User Actions View

Name	ActionsUser
Type	View
Description	A normalized version of the Completed Actions table that includes only user 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	Notes

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value
Key	TenantId	VARCHAR(32)		ALWAYS	qvo-stg
Key	Tenant	VARCHAR(64)		ALWAYS	Default
Key	ClientId	VARCHAR(64)		ALWAYS	Default
Key	Client	VARCHAR(64)		ALWAYS	Default
Claim Details	ClaimType	VARCHAR(64)		CONDITIONAL	Card-Pinless
Claim Details	ClaimCategory	VARCHAR(64)		CONDITIONAL	Fraud
Claim Details	ClaimReason	VARCHAR(64)		CONDITIONAL	Stolen
Compliance Details	RegulatoryCoverage	VARCHAR		CONDITIONAL	Reg E
Task Details	Parent	VARCHAR		ALWAYS	Claim, Dispute
Key	ClaimId	VARCHAR		ALWAYS	2306060014C
Claim Details	ClaimStatus	VARCHAR(64)		ALWAYS	RESOLVED-PAID
Claim Details	ClaimResolvedDateTime	TIMESTAMP_NTZ(9)		CONDITIONAL	2023-09-09 21:00:00
Key	DisputeId	VARCHAR		ALWAYS	2306060014C
Task Details	FlowType	VARCHAR	Differentiates between Front Office and Back Office actions.	ALWAYS	Front Office, Back Office
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

Change Log

Date	Change Summary

Date	Change Summary
12/10/2024	Timestamp columns converted from NTZ to TZ format for compatibility.
12/11/2024	Added FlowType column
12/18/2024	Added ClaimResolvedDate column