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

Version 1 Next »

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.

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

Dispute Details

DisputeAmount

Reopened

Cycle1ActionDate

Cycle1Action

Cycle1ResponseDate

Cycle1Response

Cycle1Outcome

Cycle1Status

Cycle1ResponseActionDate

Cycle1ResponseAction

Cycle2ActionDate

Cycle2Action

Cycle2ResponseDate

Cycle2Response

Cycle2Outcome

Cycle2Status

Cycle2ResponseActionDate

Cycle2ResponseAction

Cycle3ActionDate

Cycle3Action

Cycle3ResponseDate

Cycle3Response

Cycle3Outcome

Cycle3Status

Cycle3ResponseActionDate

Cycle3ResponseAction

  • No labels