Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg | |
Key | Tenant | VARCHAR(64) | A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID. | ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR(64) | A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant. Each client is assigned a unique Client ID. | ALWAYS | Default | |
Claim Details | ClaimType | VARCHAR(64) | See Transaction Type. | CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | General categorization of the claim. For a more precise description, see Claim Reason. | CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen | |
Compliance Details | RegulatoryCoverage | VARCHAR | Identifies the specific reason associated with the claim. | CONDITIONAL | Reg E | |
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 | Identifies a relationship to a claim or a dispute. | 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 |