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 | |
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 | FinalDecision | VARCHAR(64) | "Paid" or "Denied". If one, or more, disputes on a claim are paid, the claim decision is "Paid". | CONDITIONAL | Paid, Denied | |
Dispute Details | DenyReason | VARCHAR(64) | The reason associated with a denial action. See Denied for a list of supported reasons. | CONDITIONAL | No Error | |
Claim Details | ContactDate | DATE | Represents the date that the claim was received from the accountholder. | CONDITIONAL | 2023-09-09 | |
Compliance Details | FinalDecisionDate | TIMESTAMP_NTZ(9) | Datetime that a pay or deny decision is rendered for the dispute. | CONDITIONAL | 2023-09-09 21:00:00 | InvestigationDate |
Compliance Details | ResolutionDeadline | TIMESTAMP_NTZ(9) | Datetime assigned by the system by which a claim must be resolved in order to be compliant with applicable regulations. | CONDITIONAL | 2023-09-09 21:00:00 | |
Dispute Details | PaidLetter | TIMESTAMP_NTZ(9) | Datetime that the paid letter was created. | CONDITIONAL | 2023-09-09 21:00:00 | |
Dispute Details | DeniedLetter | TIMESTAMP_NTZ(9) | Datetime that the denied letter was created. | CONDITIONAL | 2023-09-09 21:00:00 | |
Dispute Details | PartialDenyDebit | TIMESTAMP_NTZ(9) | Datetime that a partial deny debit accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 | |
Dispute Details | DenyDebit | TIMESTAMP_NTZ(9) | Datetime that a deny debit accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 | |
Dispute Details | FinalCreditReversal | TIMESTAMP_NTZ(9) | Datetime that a final credit reversal accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | DenyDebitMinimum | TIMESTAMP_NTZ(9) | Final Decision Date or Denied Letter Date + 5 business days. | ALWAYS | 2023-09-09 21:00:00 | |
Compliance Details | PartialDenyDebitCompliant | BOOLEAN | Indicates whether the partial deny debit was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE | |
Compliance Details | DenyDebitCompliant | BOOLEAN | Indicates whether the deny debit was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE | |
Compliance Details | FinalCreditReversalCompliant | BOOLEAN | Indicates whether the final credit reversal was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE | |
Dispute Details | PreviouslyPaid | BOOLEAN | Indicates whether a pay decision had been applied prior to the deny decision. | ALWAYS | FALSE |
General
Content
Integrations