Pre-Arbitration View
- Devan Robertson
Name | Pre-Arbitration |
|---|---|
Type | View |
Description | A normalized view of all pre-arbitration cases, based on the Recovery Action table, including various claim and dispute attributes for filtering/analysis. |
Version Availability | 25.01 |
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR | ALWAYS | qvo-stg |
| |
Key | Tenant | VARCHAR |
| ALWAYS | Default |
|
Key | ClientId | VARCHAR | ALWAYS | Default |
| |
Key | Client | VARCHAR |
| ALWAYS | Default |
|
Claim Details | ClaimType | VARCHAR | CONDITIONAL | Card-Pinless |
| |
Claim Details | ClaimCategory | VARCHAR | CONDITIONAL | Fraud |
| |
Claim Details | ClaimReason | VARCHAR | CONDITIONAL | Stolen |
| |
Transaction Details | Network | VARCHAR | CONDITIONAL | Mastercard, Visa |
| |
Key | ClaimId | VARCHAR | ALWAYS | 2306060014C |
| |
Key | DisputeId | VARCHAR | ALWAYS | 2306060014D |
| |
Claim Details | CustomerContactDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Dispute Details | DisputeStatusType | VARCHAR | A summarized version of Dispute Status. | ALWAYS | Open, Resolved |
|
Dispute Details | DisputeStatus | VARCHAR | ALWAYS | Pending-Response |
| |
Dispute Details | DisputeAmount | NUMBER | ALWAYS | 123.45 |
| |
Recovery Details | PreArbitrationDate | DATE | ALWAYS | 2023-09-09 |
| |
Recovery Details | PreArbitrationAmount | NUMBER | Amount of the filed case. | ALWAYS | 123.45 |
|
Recovery Details | ResponseDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Recovery Details | Response | VARCHAR |
| CONDITIONAL | Ruled in Issuer Favor |
|
Recovery Details | ResponseAmount | NUMBER | Amount of the acquirer action or association ruling. | CONDITIONAL | 123.45 |
|
Recovery Details | Outcome | VARCHAR | ALWAYS | Recovered, No Recovery, Not Attempted |
| |
Recovery Details | Status | VARCHAR | ALWAYS | Not Attempted, Pending, Completed |
| |
Recovery Details | PursedByUserId | VARCHAR | ID of the user that declined, or partially accepted, the previous recovery response. | ALWAYS | devan.robertson@quavo.com |
|
Recovery Details | PursuedBy | VARCHAR | Name associated with PursedByUserId. | ALWAYS | D. Robertson |
|
Recovery Details | PursuedByUserType | VARCHAR | Indicates whether the action was taken by a user or the system. | ALWAYS | User System |
|
Recovery Details | SubmittedByUserId | VARCHAR | ID of the user that completed the recovery attempt task. | ALWAYS | devan.robertson@quavo.com |
|
Recovery Details | SubmittedBy | VARCHAR | Name associated with SubmittedByUserId. | ALWAYS | D. Robertson |
|
Recovery Details | SubmittedByUserType | VARCHAR | Indicates whether the action was taken by a user or the system. | ALWAYS | User, System |
|
Change Log
Date | Change Summary |
|---|---|
12/10/2024 | New |
2/25/2025 | Added the following columns for use in analyzing user and system performance:
|