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. |