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 | ClaimChannel | VARCHAR(32) | The Claim Channel defines the intake channel where the claim originated. This channel can include various avenues such as online banking, back office users, contact centers, or external 3rd party contact centers. | ALWAYS | Back Office, Contact Center, Online Banking | |
Key | ClaimId | VARCHAR(32) | Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C | ALWAYS | 2306060014C | |
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 | |
Key | DisputeId | VARCHAR(32) | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | ALWAYS | 2306060014D | |
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 | |
Correspondence Details | Direction | VARCHAR | Specifies whether a correspondence item was sent (outbound) or received (inbound). | ALWAYS | Inbound, Outbound | |
Correspondence Details | Channel | VARCHAR(64) | Any correspondence generated by the system is communicated via a channel. Multiple channels are supported and are defined on the Correspondence page. | ALWAYS | Email, Mail, Verbal | |
Correspondence Details | Type | VARCHAR(32) | All letters have a defined "Type" of one of the following values: When a claim is auto-paid, the Confirmation letter type is "Paid". When a claim receives auto-PC, the Confirmation letter type is "Provisional Credit". The letter can still be identified as a confirmation letter via the Name field, which will still reflect "Confirmation". | CONDITIONAL | Confirmation, Denied, Paid, Provisional Credit, Other | |
Correspondence Details | Name | VARCHAR(128) | Identifies the reason a letter was sent. Typically coincides with the name of the letter. | ALWAYS | Provisional Credit | |
Correspondence Details | Vendor | VARCHAR(32) | Print service provider used to transmit paper correspondence. | CONDITIONAL | Lob | |
Correspondence Details | PageCount | NUMBER(38,0) | Number of pages generated for a print correspondence item. | CONDITIONAL | 2 | |
Correspondence Details | IsDoubleSided | BOOLEAN | Indicates whether both sides of a page are printed on. | CONDITIONAL | TRUE, FALSE | |
Correspondence Details | IsReturnMailRequested | BOOLEAN | Indicates if and outbound correspondence item includes a request for return mail. Only applies when using a print vendor that requires/requests this detail. | CONDITIONAL | TRUE, FALSE | |
Correspondence Details | IsColor | BOOLEAN | Indicates whether a letter is printed in color vs. grayscale. | CONDITIONAL | TRUE, FALSE | |
Correspondence Details | Status | VARCHAR(64) | The status of transmission of a correspondence item. Examples may include "Mailed", "Out for Delivery", and "Delivered". | ALWAYS | In Transit | |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | ALWAYS | 2023-09-09 21:00:00 | |
Correspondence Details | MailedDateTime | TIMESTAMP_NTZ(9) | Datetime that a correspondence item status is set to "mailed". | CONDITIONAL | 2023-09-09 21:00:00 | |
Metadata | DaysToSend | NUMBER | Number of calendar days elapsed between the create date and mailed date of a correspondence item. | CONDITIONAL | 2 | |
Metadata | BusinessDaysToSend | NUMBER | Number of days elapsed between the create date and mailed date of a correspondence item, excluding weekends and U.S. federal bank holidays. | CONDITIONAL | 2 | |
Correspondence Details | Method | VARCHAR(32) | Represents the process used to complete an accounting action, such as "Auto", "Manual", or "Tracking Only". | CONDITIONAL | AUTO | |
Correspondence Details | Source | VARCHAR(32) | Identifies how a letter was generated, via system workflow or by a user. | ALWAYS | Workflow | |
Correspondence Details | Resend | BOOLEAN | A boolean value that specifies whether a correspondence item was a resend of a previous correspondence item. | CONDITIONAL | TRUE, FALSE |
General
Content
Integrations