| Page Properties | ||||||
|---|---|---|---|---|---|---|
|
...
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 | Action Details | Task | ||||||||||||||||||||||||||||||||||||||||
Task Details | Parent | VARCHAR |
| ALWAYS | Claim, Dispute | ||||||||||||||||||||||||||||||||||||||||||
Key | ClaimId | VARCHAR |
| ALWAYS | 2306060014C | ||||||||||||||||||||||||||||||||||||||||||
Claim Details | ClaimStatus | VARCHAR(64) |
| ALWAYS | RESOLVED-PAID | ||||||||||||||||||||||||||||||||||||||||||
Claim Details | ClaimResolvedDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||||||||||||||||||||||||||||||
Key | DisputeId | VARCHAR |
| ALWAYS | 2306060014C | ||||||||||||||||||||||||||||||||||||||||||
Task Details | FlowType | VARCHAR | Differentiates between Front Office and Back Office actions. | ALWAYS | Front Office, Back Office | ||||||||||||||||||||||||||||||||||||||||||
Task Details | Flow | VARCHAR | Name of flow where assignment is generated. | CONDITIONAL | Manual Fraud Reporting | ||||||||||||||||||||||||||||||||||||||||||
Task Details | Assignment | VARCHAR | Name of the task associated with the action. | CONDITIONAL | Manual Fraud Reporting | ||||||||||||||||||||||||||||||||||||||||||
Action Details | Action | VARCHAR | Name of the action that was completed. | ALWAYS | Report Fraud | ||||||||||||||||||||||||||||||||||||||||||
Action Details | CompletedBy | VARCHAR | First initial and last name of the user that completed the action. | ALWAYS | D. Robertson | ||||||||||||||||||||||||||||||||||||||||||
Action Details | ActionDateTime | DATE | Datetime that the action was completed. | ALWAYS | 2023-09-09 | Claim Details | ClaimCreateDateTime | DATE | Datetime that the claim associated with the task was created. | CONDITIONAL | 2023-09-09 | Claim Details | ClaimResolvedDateTime | DATE |
| CONDITIONAL | 2023-09-09 | Task Details | ClaimDispute | VARCHAR |
| ALWAYS | OPEN
Change Log
Date | Change Summary |
|---|---|
12/10/2024 | Timestamp columns converted from NTZ to TZ format for compatibility. |
12/11/2024 | Added FlowType column |
12/18/2024 | Added ClaimResolvedDate column |