Approvals View

Name	Approvals
Type	View
Description	Includes all approval actions from the Approval Table , as well as additional columns from the Claim and User Profile tables to improve usability.

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
Key	ClaimId	VARCHAR(32)		ALWAYS	2306060014C
Key	DisputeId	VARCHAR(32)		ALWAYS	2306060014D
Approval Details	DisputeAmount	NUMBER(9,2)		CONDITIONAL	99.95
Approval Details	ApprovalType	VARCHAR(64)		ALWAYS	Write Off, Provisional Credit, Deny
Approval Details	CreatedByUserID	VARCHAR(64)	ID of the user that performed the action that led to the approval requirement.	ALWAYS	devan.robertson@quavo.com
Approval Details	CreatedBy	VARCHAR	First initial and last name of user that performed the action requiring approval.	ALWAYS	D. Robertson, System
Approval Details	PerformedByUserID	VARCHAR(64)	ID of the user, typically a manager, that completed the approval task.	ALWAYS	devan.robertson@quavo.com
Accounting Details	PerformedBy	VARCHAR	First initial and last name of user that completed the approval task.	ALWAYS	D. Robertson
Approval Details	Outcome	VARCHAR(32)	Outcome of the review: "Approve" or "Deny"	ALWAYS	Approve
Approval Details	ApprovalInfo	VARCHAR(64)	Additional details of the approval, such as the name of the letter being sent.	CONDITIONAL	Additional Information

Change Log

Date	Change Summary

Date	Change Summary
12/10/2024	Timestamp columns converted from NTZ to TZ format for compatibility.