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 | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default |
|
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 | 2306050001D |
|
Dispute Details | Status | VARCHAR(32) | Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. | ALWAYS | Open-ProcessLiability |
|
Dispute Details | StatusChangeDateTime | TIMESTAMP_NTZ(9) | Datetime the status of the object was last changed. | ALWAYS | 2023-09-09 21:00:00 |
|
Dispute Details | DisputeAmount | NUMBER(9,2) | The current amount in dispute, accounting for any recoveries or adjustments. | ALWAYS | 185.00 |
|
Transaction Details | TransactionId | VARCHAR(128) | A unique ID associated with a transaction. This value is provided by the transaction system of record. | ALWAYS | ABC123456789 |
|
Transaction Details | Amount | NUMBER(9,2) | Amount of the transaction. | ALWAYS | 185.00 |
|
Transaction Details | AmountPosted | NUMBER(9,2) | The settled amount of a transaction. | CONDITIONAL | 185.00 | Only applicable for posted transactions. |
Transaction Details | AuthCode | VARCHAR(32) | A credit card authorization or approval code is an alphanumeric string generated at the POS. Normally consisting of five to six characters, this one-time approval code is unique to each transaction. | CONDITIONAL | 855410 | Only applicable for dual message card transactions where provided by the System of Record. Available in 24.01.03. |
Transaction Details | IsManualTransaction | BOOLEAN | Indicates whether the transaction information was entered manually by the intake user. | CONDITIONAL | TRUE | Only applicable when true. Available in 24.01.03. |
Transaction Details | TransactionDate | DATE | The date of the transaction, as provided by the system of record. This generally represents the Posting Date. | ALWAYS | 2023-11-11 |
|
Transaction Details | PostingDate | DATE | The date the transaction posted to the customer/member account. | ALWAYS | 2023-11-12 |
|
Transaction Details | AcquirerNetwork | VARCHAR(64) | A network is a company that provides the communication system between a merchant and a card issuer in order to process transactions. For more details, see Acquirer Networks. | CONDITIONAL | Mastercard, Visa | Only applicable when provided by the System of Record. |
Transaction Details | AcquirerReferenceNumber | VARCHAR(32) | A unique number assigned to a credit card transaction as it moves through the payment flow. | CONDITIONAL | 24055233349083742325779 | Only applicable when provided by the System of Record. |
Transaction Details | TransactionType | VARCHAR(64) | The type of transaction, such as ACH, BillPay, Card, Check, RTP, Wire, Zelle, etc. | ALWAYS | Card - Pinless |
|
Transaction Details | AuthorizationStatus | VARCHAR(32) | Represents the posting state of a transaction. Values include "Authorization" and "Posted". | ALWAYS | Pending, Posted |
|
Transaction Details | Description | VARCHAR(256) | A description of the transaction as provided by the system of record. Typically, this will match what the customer/member sees on their account statement. | ALWAYS | GOOGLE *YouTube g.co/helppay#CAUS |
|
Transaction Details | MerchantCategoryCode | VARCHAR(6) | Also referred to as "MCC", this 4-digit code represents the type of goods or services a business offers. | CONDITIONAL | 4829 | Only applicable when provided by the System of Record. |
Transaction Details | MerchantName | VARCHAR(256) | Name of the business providing goods or services, as provided by the system of record. | CONDITIONAL | GOOGLE *YouTube | Only applicable when provided by the System of Record. |
Transaction Details | POSEntryMode | VARCHAR(32) | Code representing how the merchant entered the transaction at the point of sale (POS). | CONDITIONAL | 05 | Only applicable when provided by the System of Record. |
Dispute Details | HasChargebackRights | BOOLEAN | A boolean value representing whether chargeback rights exist for a specified dispute. | CONDITIONAL | FALSE | Only applicable for transactions where chargeback rights can be evaluated. |
Dispute Details | IsChargebackSubmitted | BOOLEAN | A boolean value representing whether a chargeback has been processed in QFD for a particular dispute. | CONDITIONAL | TRUE | Only applicable for card disputes where a chargeback has been submitted. |
Dispute Details | OriginalDisputeAmount | NUMBER(9,2) | Represents the date that the next recovery action must be completed by an issuer or acquirer to continue in the recovery process. | ALWAYS | 185.00 | Available in 24.01.03. |
Dispute Details | NextRecoveryDateTime | TIMESTAMP_NTZ(9) | Represents the date that the next recovery action must be completed by an issuer or acquirer to continue in the recovery process. | CONDITIONAL | 2023-09-09 21:00:00 | Only applicable where a recovery deadline is present. |
Accounting Details | AccountHolderTotal | NUMBER(9,2) | The balance of the Accountholder accounting collection. Also referred to as ACCOUNTHOLDERTOTAL. | CONDITIONAL | 185.00 | Only applicable when accounting has occurred for the specified bucket. |
Accounting Details | MerchantTotal | NUMBER(9,2) | The balance of the Merchant accounting collection. Also referred to as MERCHANTTOTAL. | CONDITIONAL | 185.00 | Only applicable when accounting has occurred for the specified bucket. |
Accounting Details | LossTotal | NUMBER(9,2) | The balance of the Loss accounting collection. Also referred to as LOSSTOTAL. | CONDITIONAL | 185.00 | Only applicable when accounting has occurred for the specified bucket. |
Accounting Details | AppliedCreditsTotal | NUMBER(9,2) | Amount of all applied merchant credits. | CONDITIONAL | 185.00 | Value only exists when 1, or more, merchant credits applied to dispute. |
Dispute Details | Decision | VARCHAR(64) | When related to a claim or dispute, this represents a pay/deny decision applied. When related to recovery actions, this represents a decision made by the system or user to pursue or not pursue recovery. Reflected as either "Deny," "Write Off," or "Pay" | CONDITIONAL | Deny | Only applicable when a decision has been rendered. |
Dispute Details | DenyReason | VARCHAR(64) | The reason associated with a denial action. See Denied for a list of supported reasons. | CONDITIONAL | No Error | Only applicable when a deny decision has been rendered. |
Dispute Details | DenySubReason | VARCHAR(64) | A more detailed Deny Reason. | CONDITIONAL | Out of Timeframe | Deprecated |
Dispute Details | DenyDebitDate | DATE | Date that a provisional credit reversal will occur when a dispute is denied and provisional credit was previously issued. | CONDITIONAL | 2023-12-06 | Only applicable when a credit reversal is processed. |
Dispute Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | Date and/or datetime that a Pay or Deny decision is rendered for all disputes on a claim. | CONDITIONAL | 2023-11-28 17:32:46.625 | Only applicable when an investigation has been completed. |
Dispute Details | CustomerFinalProcessingDateTime | TIMESTAMP_NTZ(9) | Datetime that final processing is completed. Also referred to as CUSTOMERFINALPROCESSINGDATETIME. | CONDITIONAL | 2023-11-28 17:32:46.625 | Only applicable when the dispute has been paid. |
Dispute Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | Datetime that a claim or dispute is set to a "Resolved" status.. Also referred to as RESOLVEDDATETIME. | CONDITIONAL | 2023-11-28 17:32:46.625 | Only applicable when the dispute has been resolved. |
Dispute Details | LastReopenDateTime | TIMESTAMP_NTZ(9) | Datetime that a dispute was last reopened. | CONDITIONAL | 2023-11-28 17:32:46.625 | Only applicable when the dispute has been denied and then reopened. |
Dispute Details | DisputeStatusDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-11-28 17:32:46.625 | Only applicable when dispute status maintenance has been performed. |
Dispute Details | IsAutoDenyLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE | Only applicable when a user has suppressed a denial letter. |
Dispute Details | IsAutoPaidLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE | Only applicable when a user has suppressed a paid letter. |
Dispute Details | IsAutoPCLetterSuppressed | BOOLEAN |
| CONDITIONAL | TRUE | Only applicable when a user has suppressed a provisional credit letter. |
Dispute Details | IsReopened | BOOLEAN |
| CONDITIONAL | TRUE | Only applicable when the dispute has been denied and then reopened. |
Deflection Details | WasReviewedForMerchantCredit | BOOLEAN | TRUE when a merchant credit was presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | WasReviewedForPurchaseInquiry | BOOLEAN | TRUE when purchase inquiry details were presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | WasReviewedForUndisputedHistory | BOOLEAN | TRUE when undisputed history was presented during intake in an attempt to resolved the dispute. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromMerchantCredit | BOOLEAN | TRUE when the dispute was resolved in intake via merchant credit. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromPurchaseInquiry | BOOLEAN | TRUE when the dispute was resolved in intake via purchase inquiry details. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromUndisputedHistory | BOOLEAN | TRUE when the dispute was resolved in intake via undisputed history details. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Deflection Details | IsDeflectedFromIntake | BOOLEAN | TRUE when the dispute was resolved in intake via any deflection method. | CONDITIONAL | TRUE | Only available with the Deflection booster. |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) |
| ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | The datetime that the event was recorded. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventIdentifier | VARCHAR(64) | A unique ID associated with each business event. | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 |
|
Metadata | EventItemId | VARCHAR(64) | An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. | ALWAYS | qvo-stg|2302030002D |
|
Each time a change is saved to a dispute-level property in QFD, an event is created. This event includes all important dispute details and will be useful for referencing from most other events to understand the full picture of the dispute.
General
Content
Integrations