Claims View
- Devan Robertson
Name | Claims |
|---|---|
Type | View |
Description | The Claims view provides most of the same information as the Claim table, though more consolidated, as well as additional columns that are useful in the context of claims, such as dispute count, dispute amount, recovered amount, etc. |
Â
Fields
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 | Â | |
Compliance Details | RegulatoryCoverage | VARCHAR |
| CONDITIONAL | Reg E | Â |
Claim Details | ClaimChannel | VARCHAR(32) |
| ALWAYS | Online Banking | Â |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C | Â | |
Claim Details | CreateDate | DATE | CONDITIONAL | 2023-09-09 | Â | |
Claim Details | CustomerContactDate | DATE | CONDITIONAL | 2023-09-09 | Â | |
Claim Details | ClaimAmount | NUMBER(20,2) | CONDITIONAL | 123.45 | Â | |
Claim Details | ClaimState | VARCHAR |
| ALWAYS | OPEN | Â |
Claim Details | ClaimStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID | Â | |
Card Details | BIN | VARCHAR(8) | CONDITIONAL | 412356, 41235678 | Â | |
Card Details | CardType | VARCHAR(16) |
| CONDITIONAL | Debit | Â |
Claim Details | Decision | VARCHAR(64) | CONDITIONAL | Paid, Denied | Â | |
Claim Details | DiscoveryDate | DATE | CONDITIONAL | 2023-09-09 | Â | |
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Compliance Details | InvestigationDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Compliance Details | ResolutionDeadline | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Claim Details | ResolvedDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Risk Details | PotentialAbuse | BOOLEAN | CONDITIONAL | FALSE | Â | |
Risk Details | EmployeeClaim | BOOLEAN |
| CONDITIONAL | false | Â |
Claim Details | PCDecision | VARCHAR(16) |
| CONDITIONAL | Grant | Â |
Claim Details | PCDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Claim Details | Reclassifications | NUMBER(3,0) | CONDITIONAL | 1 | Â | |
Claim Details | RequiredDocuments | NUMBER(3,0) | CONDITIONAL | 1 | Â | |
Metadata | CreatedBy | VARCHAR(64) | The username of the user that created the claim. | CONDITIONAL | Available in 24.01.03. | |
Dispute Details | DisputeCount | NUMBER(3,0) |
| CONDITIONAL | 2 | Â |
Dispute Details | DisputeAmount | NUMBER(20,2) |
| CONDITIONAL | 123.59 | Â |
Dispute Details | MerchantCreditAmount | NUMBER(20,2) |
| CONDITIONAL | 123.59 | Â |
Dispute Details | RecoveredAmount | NUMBER(20,2) |
| CONDITIONAL | 123.59 | Â |
Dispute Details | LossAmount | NUMBER(20,2) |
| CONDITIONAL | 123.59 | Â |