Versions Compared

Key

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

Name

StickRateRecovery

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.

...

macro_uuid

Cycle Response Date

Only applicable when a response in this cycle has been received and further actions have been taken on behalf of the issuer

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

Cycle1ActionDateActionDate

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

ALWAYS

2023-09-09

Recovery Details

Cycle1ActionAction

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

ALWAYS

Chargeback, Rapid Dispute Resolution, Request Submitted

Recovery Details

Cycle1ResponseDateResponseDate

Multiexcerpt include macro

Recovery Details

Cycle1Outcome

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

CONDITIONAL

Won, Lost

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

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

Cycle1ResponseActionDate

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

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.

macro_uuidd2ed5cf4-6242-4747-97c9-26284221282d
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action Date
addpanelfalse

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.

Recovery Details

Cycle1ResponseAction

Multiexcerpt include macro
macro_uuide7e45f7a-336a-48b5-b838-5c9a44a854cc
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action
addpanelfalse

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.

Recovery Details

Cycle2ActionDate

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

CONDITIONAL

2023-09-09

Only applicable when recovery is pursued beyond cycle 1.

Recovery Details

Cycle2Action

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

CONDITIONAL

Pre-Arbitration Submitted, Inbound Pre-Arbitration Declined, Arbitration Chargeback Submitted

Only applicable when recovery is pursued beyond cycle 1.

Recovery Details

Cycle2ResponseDate

Multiexcerpt include macro
86456057-d5ba-46e9-9ea7-a651d1297eb8

nameglossary_description
templateDataeJyLjgUAARUAuQ==
page
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

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

Cycle2OutcomeActionOutcome

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

CONDITIONAL

Won, Lost

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

Recovery Details

Cycle2StatusActionStatus

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

ALWAYS

Completed, Pending Response, Not Attempted

Recovery Details

Cycle2ResponseActionDate

Multiexcerpt include macro
macro_uuidd2ed5cf4-6242-4747-97c9-26284221282d
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action Date
addpanelfalse

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.

Recovery Details

Cycle2ResponseAction

Multiexcerpt include macro
macro_uuide7e45f7a-336a-48b5-b838-5c9a44a854cc
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action
addpanelfalse

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.

Recovery Details

Cycle3ActionDate

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

CONDITIONAL

2023-09-09

Only applicable when recovery is pursued beyond cycle 2.

Recovery Details

Cycle3Action

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

CONDITIONAL

Arbitration Submitted, Pre-Arbitration Escalated

Only applicable when recovery is pursued beyond cycle 2.

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

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

Cycle3Outcome

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

CONDITIONAL

Won, Lost

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

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

Cycle3ResponseActionDate

Multiexcerpt include macro
macro_uuidd2ed5cf4-6242-4747-97c9-26284221282d
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action Date
addpanelfalse

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.

Recovery Details

Cycle3ResponseAction

Multiexcerpt include macro
macro_uuide7e45f7a-336a-48b5-b838-5c9a44a854cc
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCycle Response Action
addpanelfalse

CONDITIONAL

Write Off, Deny, Inbound Pre-Arbitration Declined, Timeframe Expired, Dispute Response Accepted - Partial,

Change Log

Date

Change Summary

12/10/2024

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