...
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 | ||||||||||||||||||||
Accounting Details | PerformedOn | TIMESTAMP_NTZ(9) |
| ||||||||||||||||||||||
| macro_uuid | 08ffa65b-3984-48fd-8b68-f9ad10086a67 | ||||||||||||||||||||||||
| name | glossary_description | ||||||||||||||||||||||||
| templateData | eJyLjgUAARUAuQ== | ||||||||||||||||||||||||
| page | Performed On | addpanel | falseAssignment DetailsFlow | 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 | ||||||||||||||||||||
Accounting Assignment Details | PerformedBy | VARCHAR |
| ALWAYS | D. Robertson | Accounting Details | ExecutedOn | TIMESTAMP_NTZ(9)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 | 2023-09-09 21:00:00 | Accounting Details | ExecutedByD. Robertson | ||||||||||||||||||
Assignment Details | PerformedBy | VARCHAR |
| ALWAYS | Ddevan.robertson@quavo. Robertsoncom |