Recovery View
- Devan Robertson
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) | ALWAYS | qvo-stg |
| |
Key | Tenant | VARCHAR(64) |
| ALWAYS | Default |
|
Key | ClientId | VARCHAR(64) | ALWAYS | Default |
| |
Key | Client | VARCHAR(64) |
| ALWAYS | Default |
|
Claim Details | ClaimType | VARCHAR(64) | CONDITIONAL | Card-Pinless |
| |
Claim Details | ClaimCategory | VARCHAR(64) | CONDITIONAL | Fraud |
| |
Claim Details | ClaimReason | VARCHAR(64) | CONDITIONAL | Stolen |
| |
Transaction Details | Network | VARCHAR(64) | CONDITIONAL | Mastercard, Visa |
| |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C |
| |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306060014D |
| |
Claim Details | CustomerContactDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Dispute Details | DisputeStatus | VARCHAR | ALWAYS | Pending-Response |
| |
Dispute Details | DisputeAmount | NUMBER | ALWAYS | 123.45 |
| |
Dispute Details | Reopened | BOOLEAN | CONDITIONAL | True | Only applicable when a dispute has been reopened after being denied. | |
Recovery Details | ActionDate |
| ALWAYS | 2023-09-09 |
| |
Recovery Details | Action |
| ALWAYS | Chargeback, Rapid Dispute Resolution, Request Submitted |
| |
Recovery Details | ResponseDate |
| CONDITIONAL | 2023-09-09 | Only applicable when a response in this cycle has been received. | |
Recovery Details | Response |
| 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 |
| CONDITIONAL | Won, Lost | Only applicable when a response in this cycle has been received. | |
Recovery Details | ActionStatus |
| 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. |