Tasks View
- Devan Robertson
Name | ASSIGNMENT_USER |
|---|---|
Type | View |
Description | Includes records for all outstanding and completed assignments user assignments, as well as additional columns from various other tables that are relevant in the context of assignments. System and Pending assignments excluded. |
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 |
|
Claim Details | ClaimStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID |
| |
Dispute Details | DisputeStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID |
| |
Claim Details | ClaimContactDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Claim Details | ClaimAge | NUMBER(20,2) | Current Date - Create Date (DAYS) | ALWAYS | 48 |
|
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C |
| |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306060014D |
| |
Claim Details | ClaimAmount | NUMBER(20,2) | ALWAYS | 123.45 |
| |
Dispute Details | DisputeAmount | NUMBER(9,2) | The current amount in dispute, accounting for any recoveries or adjustments. | ALWAYS | 185.55 |
|
Assignment Details | Flow | VARCHAR(128) | The flow where a flow action is completed. | ALWAYS | Collect Customer Documentation |
|
Assignment Details | Assignment | VARCHAR(128) | Name of the assignment. | ALWAYS | Pending Documents |
|
Assignment Details | State | VARCHAR | The current state of the assignment | ALWAYS | Outstanding, Completed |
|
Assignment Details | CreatedDateTime | TIMESTAMP_NTZ(9) | Datetime that the assignment was created. | ALWAYS | 2023-09-09 21:00:00 |
|
Assignment Details | CompletedDateTime | TIMESTAMP_NTZ(9) | Datetime that the assignment was completed. | CONDITIONAL | 2023-09-09 21:00:00 | Only displayed when the assignment state is “Completed”. |
Assignment Details | Age | NUMBER(9,2) | For outstanding assignment, the number of days between the create date and today. For completed assignments, the number of days between the create date and the complete date. | ALWAYS | 12 |
|
Assignment Details | Queue | VARCHAR | Designates who is intended to complete the work. | ALWAYS | Pending, System, User |
|
Assignment Details | PerformedBy | VARCHAR | ALWAYS | D. Robertson |
| |
Assignment Details | PerformedByUserID | VARCHAR | ALWAYS | devan.robertson@quavo.com |
|