Disputes Basic View

Name	DisputesBasic
Type	View
Description	A lighter weight version of the Disputes View for basic calculations and aggregations.

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value	Notes

Data Category	Event Field/Column Name	Data Type	Applicability	Sample Value
Key	TenantId	VARCHARVisa	ALWAYS	qvo-stg
Key	Tenant	VARCHAR	ALWAYS	Default
Key	ClientId	VARCHAR	ALWAYS	Default
Key	Client	VARCHAR	ALWAYS	Default
Claim Details	Type	VARCHAR	CONDITIONAL	Card-Pinless
Claim Details	Category	VARCHAR	CONDITIONAL	Fraud
Claim Details	Reason	VARCHAR	CONDITIONAL	Stolen
Compliance Details	RegulatoryCoverage	VARCHAR	CONDITIONAL	Reg E
Dispute Details	Network	VARCHAR		Visa, Mastercard
Claim Details	Channel	VARCHAR	ALWAYS	Online Banking
Card Details	CardType	VARCHAR(16)	CONDITIONAL	Debit
Transaction Details	TransactionType	VARCHAR	ALWAYS	ATM
Card Details	BIN	VARCHAR	CONDITIONAL	412356, 41235678
Key	ClaimId	VARCHAR(32)	ALWAYS	2306060014C
Key	DisputeId	VARCHAR(32)	ALWAYS	2306060014D
Claim Details	ClaimStatus	VARCHAR(64)	ALWAYS	RESOLVED-PAID
Dispute Details	DisputeStatus	VARCHAR(64)	ALWAYS	RESOLVED-PAID
Dispute Details	DisputeStatusType	VARCHAR(64)	ALWAYS
Dispute Details	DenyReason	VARCHAR	CONDITIONAL	No Error
Claim Details	ContactDate	DATE	CONDITIONAL	2023-09-09
Claim Details	CreateDate	DATE	CONDITIONAL	2023-09-09
Claim Details	ResolvedDate	TIMESTAMP_NTZ(9)	CONDITIONAL	2023-09-09 21:00:00
Transaction Details	AuthorizationStatus	VARCHAR	ALWAYS	Pending, Posted
Transaction Details	MerchantCategoryCode	VARCHAR(6)	CONDITIONAL	4829
Dispute Details	DisputeAmount	NUMBER(20,2)	CONDITIONAL	123.59