Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg | |
Key | Tenant | VARCHAR(64) | A tenant is a Quavo customer that uses QFD. Each tenant is assigned a unique Tenant ID. | ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR(64) | 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(64) | See Transaction Type. | CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | General categorization of the claim. For a more precise description, see Claim Reason. | CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen | |
Compliance Details | RegulatoryCoverage | VARCHAR | Identifies the specific reason associated with the claim. | CONDITIONAL | Reg E | |
Claim Details | ClaimStatus | VARCHAR(64) | Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. | ALWAYS | RESOLVED-PAID | |
Dispute Details | DisputeStatus | VARCHAR(64) | Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. | ALWAYS | RESOLVED-PAID | |
Claim Details | ClaimContactDate | DATE | Represents the date that the claim was received from the accountholder. | CONDITIONAL | 2023-09-09 | |
Claim Details | ClaimAge | NUMBER(20,2) | Current Date - Create Date (DAYS) | ALWAYS | 48 | |
Key | ClaimId | VARCHAR(32) | Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C | ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR(32) | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | ALWAYS | 2306060014D | |
Claim Details | ClaimAmount | NUMBER(20,2) | The sum dispute amount of all posted disputes on a claim. | 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 | Name of the user that performed the action. | ALWAYS | D. Robertson | |
Assignment Details | PerformedByUserID | VARCHAR | The unique ID of the operator that performed an action. | ALWAYS | devan.robertson@quavo.com |
General
Content
Integrations