Skip to end of banner
Go to start of banner

Recovery View

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 4 Next »

Name

Recovery

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

Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute.

ALWAYS

Pending-Response

Dispute Details

DisputeAmount

NUMBER

The current amount in dispute, accounting for any recoveries or adjustments.

ALWAYS

123.45

Dispute Details

Reopened

BOOLEAN

Identifies if the claim or dispute was reopened for an additional investigation with "True" or "False" 

CONDITIONAL

True

Only applicable when a dispute has been reopened after being denied.

Recovery Details

ActionDate

Date a recovery attempt for the specified recovery cycle was executed.

ALWAYS

2023-09-09

Recovery Details

Action

Type of recovery attempt made for the specified recovery cycle.

ALWAYS

Chargeback, Rapid Dispute Resolution, Request Submitted

Recovery Details

ResponseDate

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.

Recovery Details

Response

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.

Recovery Details

ActionOutcome

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.

Recovery Details

ActionStatus

Status of recovery attempt and response for the specified cycle ("Not Attempted", "Pending", "Completed").

ALWAYS

Completed, Pending Response, Not Attempted

Change Log

Date

Change Summary

12/10/2024

StickRate view deprecated in favor of Recovery view for performance optimization.

  • No labels