...
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 | |||||||||||||
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 | Task Details | Parent | VARCHAR |
| |||||||||
| macro_uuid | 9a0193d8-5746-40a4-91d8-abcf05cab2ef | glossary_description | ||||||||||||||||
| templateData | eJyLjgUAARUAuQ== | |||||||||||||||||
| page | CLAIMDISPUTE | |||||||||||||||||
| addpanel | false | 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 |