...
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 | |||||||||||||
Key | ClaimId | VARCHAR(32) |
| ALWAYS | 2306060014C | |||||||||||||
Key | DisputeId | VARCHAR(32) |
| ALWAYS | 2306060014D | |||||||||||||
Approval Details | DisputeAmount | NUMBER(9,2) |
| CONDITIONAL | 99.95 | |||||||||||||
Approval Details | ApprovalType | VARCHAR(64) |
| ALWAYS | Write Off, Provisional Credit, Deny | |||||||||||||
Approval Details | CreatedByUserID | VARCHAR(64) | ID of the user that performed the action that led to the approval requirement. | ALWAYS | devan.robertson@quavo.com | |||||||||||||
Approval Details | CreatedBy | VARCHAR | First initial and last name of user that performed the action requiring approval. | ALWAYS | D. Robertson, System | |||||||||||||
Approval Details | PerformedByUserID | VARCHAR(64) | ID of the user, typically a manager, that completed the approval task. | ALWAYS | devan.robertson@quavo.com | |||||||||||||
Accounting Details | PerformedBy | VARCHAR | First initial and last name of user that completed the approval task. | ALWAYS | D. Robertson | |||||||||||||
Approval Details | Outcome | VARCHAR(32) | Outcome of the review: "Approve" or "Deny" | ALWAYS | Approve | |||||||||||||
Approval Details | ApprovalInfo | VARCHAR(64) | Additional details of the approval, such as the name of the letter being sent. | CONDITIONAL | Additional Information |
Change Log
Date | Change Summary |
|---|---|
12/10/2024 | Timestamp columns converted from NTZ to TZ format for compatibility. |