Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg | |
Key | Tenant | VARCHAR | A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID. | ALWAYS | Default | |
Key | ClientId | VARCHAR | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR | 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 | See Transaction Type. | CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR | General categorization of the claim. For a more precise description, see Claim Reason. | CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen | |
Key | ClaimId | VARCHAR | Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C | ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | ALWAYS | 2306060014D | |
Task Details | TaskName | VARCHAR | Name of the assignment. | ALWAYS | Execute Fraud Report | |
Task Details | PulledByUserID | VARCHAR | ID of the user that clicked Get Next Work. | ALWAYS | devan.robertson@quavo.com | |
Task Details | PulledBy | VARCHAR | First initial and last name of user that clicked Get Next Work. | ALWAYS | D. Robertson, System | |
Task Details | PulledDateTime | DATETIME | Datetime that the task was pulled from the queue. | ALWAYS | ||
Task Details | CompletedByUserID | VARCHAR | ID of the user that completed the assignment that was retrieved. | CONDITIONAL | devan.robertson@quavo.com | |
Task Details | CompletedBy | VARCHAR | First initial and last name of user that completed the assignment that was retrieved. | CONDITIONAL | D. Robertson | |
Task Details | CompletedDateTime | DATETIME | Datetime that the task was completed. | CONDITIONAL |
Change Log
Date | Change Summary |
|---|---|
12/10/2024 | Timestamp columns converted from NTZ to TZ format for compatibility. |