Recovery View

Name	StickRate
Type	View
Description	Provides detailed information about every recovery attempt and outcome for all disputes where recovery has been attempted, primarily using data from the Recovery Action Table. NOTE: This view utilizes a significant number of joins and calculations. Please allow up to a few minutes load time for large sets of data.

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value	Notes
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
Transaction Details	Network	VARCHAR(64)	A network is a company that provides the communication system between a merchant and a card issuer in order to process transactions. For more details, see Acquirer Networks.	CONDITIONAL	Mastercard, Visa
Key	ClaimId	VARCHAR(32)	Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C	ALWAYS	2306060014C
Key	DisputeId	VARCHAR(32)	Unique ID associated with a disputed transaction. Format: YYMMDD#####"D"	ALWAYS	2306060014D
Claim Details	CustomerContactDate	DATE	Represents the date that the claim was received from the accountholder.	CONDITIONAL	2023-09-09
Dispute Details	DisputeStatus	VARCHAR		ALWAYS
Dispute Details	DisputeAmount	NUMBER		ALWAYS
Dispute Details	Reopened	BOOLEAN		CONDITIONAL		Only applicable when a dispute has been reopened after being denied.
	Cycle1ActionDate		Date a recovery attempt for the specified recovery cycle was executed.	ALWAYS	2023-09-09
	Cycle1Action		Type of recovery attempt made for the specified recovery cycle.	ALWAYS	Chargeback, Rapid Dispute Resolution, Request Submitted
	Cycle1ResponseDate		Date a response to the recovery attempt was received for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received.
	Cycle1Response		Response to the recovery attempt for the specified recovery cycle.	CONDITIONAL	Acquirer Declined, Acquirer Accepted Full, Acquirer Accepted Partial, Acquirer Accepted Full (RDR), Inbound Pre-Arbitration, Inbound Pre-Arbitration (Merchant Credit), Acquirer Declined (Merchant Credit)	Only applicable when a response in this cycle has been received.
	Cycle1Outcome		Result of the recovery attempt, based on the response received for the specified recovery cycle.	CONDITIONAL	Won, Lost	Only applicable when a response in this cycle has been received.
	Cycle1Status		Status of recovery attempt and response for the specified cycle ("Not Attempted", "Pending", "Completed").	ALWAYS	Completed, Pending Response, Not Attempted
	Cycle1ResponseActionDate		Date that an action was taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.
	Cycle1ResponseAction		Action taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	Write Off, Deny, Inbound Pre-Arbitration Declined, Timeframe Expired, Dispute Response Accepted - Partial,	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.
	Cycle2ActionDate		Date a recovery attempt for the specified recovery cycle was executed.
	Cycle2Action		Type of recovery attempt made for the specified recovery cycle.
	Cycle2ResponseDate		Date a response to the recovery attempt was received for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received.
	Cycle2Response		Response to the recovery attempt for the specified recovery cycle.	CONDITIONAL	Acquirer Declined, Acquirer Accepted Full, Acquirer Accepted Partial, Acquirer Accepted Full (RDR), Inbound Pre-Arbitration, Inbound Pre-Arbitration (Merchant Credit), Acquirer Declined (Merchant Credit)	Only applicable when a response in this cycle has been received.
	Cycle2Outcome		Result of the recovery attempt, based on the response received for the specified recovery cycle.	CONDITIONAL	Won, Lost	Only applicable when a response in this cycle has been received.
	Cycle2Status		Status of recovery attempt and response for the specified cycle ("Not Attempted", "Pending", "Completed").	ALWAYS	Completed, Pending Response, Not Attempted
	Cycle2ResponseActionDate		Date that an action was taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.
	Cycle2ResponseAction		Action taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	Write Off, Deny, Inbound Pre-Arbitration Declined, Timeframe Expired, Dispute Response Accepted - Partial,	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.
	Cycle3ActionDate		Date a recovery attempt for the specified recovery cycle was executed.
	Cycle3Action		Type of recovery attempt made for the specified recovery cycle.
	Cycle3ResponseDate		Date a response to the recovery attempt was received for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received.
	Cycle3Response		Response to the recovery attempt for the specified recovery cycle.	CONDITIONAL	Acquirer Declined, Acquirer Accepted Full, Acquirer Accepted Partial, Acquirer Accepted Full (RDR), Inbound Pre-Arbitration, Inbound Pre-Arbitration (Merchant Credit), Acquirer Declined (Merchant Credit)	Only applicable when a response in this cycle has been received.
	Cycle3Outcome		Result of the recovery attempt, based on the response received for the specified recovery cycle.	CONDITIONAL	Won, Lost	Only applicable when a response in this cycle has been received.
	Cycle3Status		Status of recovery attempt and response for the specified cycle ("Not Attempted", "Pending", "Completed").	ALWAYS	Completed, Pending Response, Not Attempted
	Cycle3ResponseActionDate		Date that an action was taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	2023-09-09	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.
	Cycle3ResponseAction		Action taken in QFD in response to the result of a recovery attempt for the specified recovery cycle.	CONDITIONAL	Write Off, Deny, Inbound Pre-Arbitration Declined, Timeframe Expired, Dispute Response Accepted - Partial,	Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer.