Approvals View
- Devan Robertson
Name | Approvals |
|---|---|
Type | View |
Description | Includes all approval actions from the Approval Table , as well as additional columns from the Claim and User Profile tables to improve usability. |
Version Availability | 24.02 |
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. |