Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties

Name

RecoveryDispute

Type

View

Description

Provides detailed information about every recovery attempt and outcome by dispute, 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.

Version Availability

24.02

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptTenant ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

qvo-stg

Key

Tenant

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTenant
addpanelfalse

ALWAYS

Default

Key

ClientId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

Client

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageClient
addpanelfalse

ALWAYS

Default

Claim Details

ClaimType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

ClaimReason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Stolen

Transaction Details

Network

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptNetwork
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Mastercard, Visa

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

Multiexcerpt include macro
macro_uuida3e31307-8cb9-40d8-8eef-f74f27879680
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageDispute ID
addpanelfalse

ALWAYS

2306060014D

Claim Details

CustomerContactDate

DATE

Multiexcerpt include
macro_uuidd99ef6b8-ca27-4139-8c27-79c2824a1215
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCustomer Contact Date

CONDITIONAL

2023-09-09

Dispute Details

DisputeStatus

VARCHAR

Multiexcerpt include macro
macro_uuid4d8f61f8-8517-4d47-a5e5-2ded7ebed57a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageStatus Work
addpanelfalse

ALWAYS

Pending-Response

Dispute Details

DisputeAmount

NUMBER

Multiexcerpt include macro
macro_uuid464f8016-31b8-44f7-af00-b29949a884d0
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageDispute Amount
addpanelfalse

ALWAYS

123.45

Dispute Details

Reopened

BOOLEAN

Multiexcerpt include macro
macro_uuid44a2dc9b-79dc-4d48-adae-d7f598bc7c6c
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageReasserted
addpanelfalse

CONDITIONAL

True

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

Recovery Details

Cycle1Status

Multiexcerpt include macro
macro_uuid12a69cdc-95e0-4509-96e9-d4b5dbbad7a1
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Status
addpanelfalse

ALWAYS

Completed, Pending Response, Not Attempted

Recovery Details

Cycle1ActionDate

Multiexcerpt include macro
macro_uuid62f1733e-0421-4eae-9bbe-01dce91ddb9a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action Date
addpanelfalse

CONDITIONAL

2023-09-09

Recovery Details

Cycle1Action

Multiexcerpt include macro
macro_uuida8843573-3133-4d57-a864-2993e594bd7a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action
addpanelfalse

CONDITIONAL

Chargeback, Request Submitted, Review Initiated

Recovery Details

Cycle1ActionAmount

Amount of recovery attempt.

CONDITIONAL

123.59

Recovery Details

Cycle1ResponseDate

Multiexcerpt include macro
macro_uuid86456057-d5ba-46e9-9ea7-a651d1297eb8
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Date
addpanelfalse

CONDITIONAL

2023-09-09

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle1Response

Multiexcerpt include macro
macro_uuidda6d6404-c6f9-4c91-99d8-ebab06fcbfd4
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response
addpanelfalse

CONDITIONAL

Full Amount Recovered, Partial Amount Recovered, No Funds Recovered, Acquirer Declined, Acquirer Accepted Full, Acquirer Accepted Partial, Rapid Dispute Resolution, Inbound Pre-Arbitration

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle1ResponseAmount

Amount of recovery attempt.

CONDITIONAL

123.59

Recovery Details

Cycle1Outcome

Multiexcerpt include macro
macro_uuid7daa2913-4860-4a0b-a9fa-4fbb75a44e0a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Outcome
addpanelfalse

ALWAYS

Recovered, Not Recovered, Not Attempted

Recovery Details

Cycle2Status

Multiexcerpt include macro
macro_uuid12a69cdc-95e0-4509-96e9-d4b5dbbad7a1
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Status
addpanelfalse

ALWAYS

Completed, Pending Response, Not Attempted

Recovery Details

Cycle2ActionDate

Multiexcerpt include macro
macro_uuid62f1733e-0421-4eae-9bbe-01dce91ddb9a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action Date
addpanelfalse

CONDITIONAL

2023-09-09

Recovery Details

Cycle2Action

Multiexcerpt include macro
macro_uuida8843573-3133-4d57-a864-2993e594bd7a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action
addpanelfalse

CONDITIONAL

Pre-Arbitration, Request Submitted, Review Initiated

Recovery Details

Cycle2ActionAmount

Amount of recovery attempt.

CONDITIONAL

123.59

Recovery Details

Cycle2ResponseDate

Multiexcerpt include macro
macro_uuid86456057-d5ba-46e9-9ea7-a651d1297eb8
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Date
addpanelfalse

CONDITIONAL

2023-09-09

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle2Response

Multiexcerpt include macro
macro_uuidda6d6404-c6f9-4c91-99d8-ebab06fcbfd4
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response
addpanelfalse

CONDITIONAL

Full Amount Recovered, Partial Amount Recovered, No Funds Recovered, Acquirer Declined, Acquirer Accepted Full, Acquirer Accepted Partial, Acquirer Accepted Full, Inbound Arbitration, Acquirer Declined

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle2ResponseAmount

Amount specified in response.

CONDITIONAL

123.59

Recovery Details

Cycle2Outcome

Multiexcerpt include macro
macro_uuid7daa2913-4860-4a0b-a9fa-4fbb75a44e0a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Outcome
addpanelfalse

ALWAYS

Recovered, Not Recovered, Not Attempted

Recovery Details

Cycle3Status

Multiexcerpt include macro
macro_uuid12a69cdc-95e0-4509-96e9-d4b5dbbad7a1
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Status
addpanelfalse

ALWAYS

Completed, Pending Response, Not Attempted

Recovery Details

Cycle3ActionDate

Multiexcerpt include macro
macro_uuid62f1733e-0421-4eae-9bbe-01dce91ddb9a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action Date
addpanelfalse

CONDITIONAL

2023-09-09

Recovery Details

Cycle3Action

Multiexcerpt include macro
macro_uuida8843573-3133-4d57-a864-2993e594bd7a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Action
addpanelfalse

CONDITIONAL

Pre-Arbitration, Request Submitted, Review Initiated

Recovery Details

Cycle3ActionAmount

Amount of recovery attempt.

CONDITIONAL

123.59

Recovery Details

Cycle3ResponseDate

Multiexcerpt include macro
macro_uuid86456057-d5ba-46e9-9ea7-a651d1297eb8
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Date
addpanelfalse

CONDITIONAL

2023-09-09

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle3Response

Multiexcerpt include macro
macro_uuidda6d6404-c6f9-4c91-99d8-ebab06fcbfd4
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response
addpanelfalse

CONDITIONAL

Full Amount Recovered, Partial Amount Recovered, No Funds Recovered, Arbitration Won, Arbitration Lost, Arbitration Split, Arbitration Accepted

Only applicable when a response in this cycle has been received.

Recovery Details

Cycle3ResponseAmount

Amount specified in response.

CONDITIONAL

123.59

Recovery Details

Cycle3Outcome

Multiexcerpt include macro
macro_uuid7daa2913-4860-4a0b-a9fa-4fbb75a44e0a
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Outcome
addpanelfalse

ALWAYS

Recovered, Not Recovered, Not Attempted

Recovery Details

OverallOutcome

Result of all recovery attempts.

ALWAYS

Recovered, Not Recovered, Not Attempted

...