Disputes Basic View
- Devan Robertson
Name | DisputesBasic |
|---|---|
Type | View |
Description | A lighter weight version of the Disputes View for basic calculations and aggregations. |
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHARVisa | ALWAYS | qvo-stg |
| |
Key | Tenant | VARCHAR |
| ALWAYS | Default |
|
Key | ClientId | VARCHAR | ALWAYS | Default |
| |
Key | Client | VARCHAR |
| ALWAYS | Default |
|
Claim Details | Type | VARCHAR | CONDITIONAL | Card-Pinless |
| |
Claim Details | Category | VARCHAR | CONDITIONAL | Fraud |
| |
Claim Details | Reason | VARCHAR | CONDITIONAL | Stolen |
| |
Compliance Details | RegulatoryCoverage | VARCHAR |
| CONDITIONAL | Reg E |
|
Dispute Details | Network | VARCHAR |
|
| Visa, Mastercard |
|
Claim Details | Channel | VARCHAR |
| ALWAYS | Online Banking |
|
Card Details | CardType | VARCHAR(16) |
| CONDITIONAL | Debit |
|
Transaction Details | TransactionType | VARCHAR | ALWAYS | ATM |
| |
Card Details | BIN | VARCHAR | CONDITIONAL | 412356, 41235678 |
| |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C |
| |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306060014D |
| |
Claim Details | ClaimStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID |
| |
Dispute Details | DisputeStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID |
| |
Dispute Details | DisputeStatusType | VARCHAR(64) | ALWAYS |
|
| |
Dispute Details | DenyReason | VARCHAR | CONDITIONAL | No Error |
| |
Claim Details | ContactDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Claim Details | CreateDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Claim Details | ResolvedDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 |
| |
Transaction Details | AuthorizationStatus | VARCHAR | ALWAYS | Pending, Posted |
| |
Transaction Details | MerchantCategoryCode | VARCHAR(6) | CONDITIONAL | 4829 |
| |
Dispute Details | DisputeAmount | NUMBER(20,2) |
| CONDITIONAL | 123.59 |
|