Fields
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 ClaimType VARCHAR(64) See Transaction Type. CONDITIONAL Card-Pinless Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission). Account Details CustomerId VARCHAR(64) Value that uniquely identifies the customer associated with a claim. May be obfuscated when NPI is used. CONDITIONAL 123456 Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission). Account Details AccountClassification VARCHAR(32) Distinguishes between Business and Consumer accounts. CONDITIONAL “Business”, “Consumer” Added in 25.01. Account Details IsEmployeeClaim BOOLEAN CONDITIONAL TRUE Only applicable for submitted claims where a positive employee account identifier is provided by the System of Record. Account Details AccountNumber VARCHAR(64) Value that uniquely identifies the account associated with a claim. May be obfuscated when NPI is used. CONDITIONAL 0000123456 Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission). Account Details IsEnrolledInAutopay BOOLEAN CONDITIONAL TRUE Only applicable for submitted claims where a positive autopay enrollment identifier is provided by the System of Record. Account Details NextPaymentDate DATE CONDITIONAL 2023-09-09 Only applicable for submitted claims where a next payment date value is provided by the System of Record. Account Details StatementCycleDate DATE CONDITIONAL 2023-09-09 Only applicable for submitted credit card claims. Account Details AccountOpenDate DATE The date the account was opened as reported by the system of record. CONDITIONAL 2023-09-09 Only applicable for submitted claims where a value is provided by the System of Record. Account Details AccountType VARCHAR(32) The date the account was opened as reported by the system of record. CONDITIONAL Deposit, Credit Card, Other Only applicable for submitted credit card claims. Card Details CardType VARCHAR(16) CONDITIONAL Debit, Credit Only applicable for submitted card claims where provided by the System of Record. Card Details CardBIN VARCHAR(8) Bank Identification Number (BIN) is the first 4-8 digits of a payment card that identifies the issuing institution. CONDITIONAL 412356, 41235678 Only applicable for submitted card claims where provided by the System of Record. Card Details CardNumberLast4 VARCHAR(4) Last 4 digits of the Card Number. CONDITIONAL 5555 Only applicable for submitted card claims where provided by the System of Record. Claim Details ReasonType VARCHAR(64) General categorization of the claim. For a more precise description, see Claim Reason. CONDITIONAL ATM, Account Merchandise Service, Authorization, Dispute, Fraud, Identity Theft, Incorrect, Missing, Revoked Only applicable for submitted claims. Claim Details Reason VARCHAR(64) Identifies the specific reason associated with the claim. CONDITIONAL ACH Merchandise or Service, ATM Deposit, ATM Withdrawal, ATM Deposit Not Posted, ATO, Addendum Dispute, AuthChargeback, Authorization, Balance Transfer, Cancelled Recurring, Cancelled/Returned Merchandise/Service, Card Lost, Card Not Received, Card Secure, Card Stolen, Cashback, Charged More Than Once, Charged Credited Incorrect, Check Merchandise or Service, Convenience Check, Counterfeit Merchandise, Credit Not Processed, Credit Posted as Debit, Damaged/Defective, Debit Posted as Credit, Debited Prior To Auth Date, Debited By Third Party, Draft Encoding Error, Duplicate Entry, Duplicate Processing, Fraud App, Improper, Improperly Processed Electronically, Improperly Reinitiated, Incorrect Amount, Incorrect Credit Amount, Late Presentment, Merchandise Service Issue, Merchant Charged Loss/Theft, Merchant Incorrect Account Number, Merchant Incorrect Currency, Merchant Invalid Data, Merchant No Show Charged, Merchant Violated Laws Or Regs, Misrepresentation, Missing Transaction, Not as Described, Not Received, Paid by Other Means, Quality, Revoked, Stale Dated, Transaction Merchandise or Service, Unauthorized, Wrong Amount, Zelle Merchandise or Service Only applicable for submitted claims. Claim Details ChannelOrigin VARCHAR(32) ALWAYS Back Office User, Contact Center, External Contact Center, Online Banking Claim Details ClaimAmount NUMBER(20,2) The sum dispute amount of all posted disputes on a claim. CONDITIONAL 123.45 Only applicable for submitted claims. Claim Details TotalClaimAmount NUMBER(20,2) The sum dispute amount of all pending and posted transactions included in a claim. CONDITIONAL 123.45 Only applicable for submitted claims. Claim Details CustomerContactDate DATE Represents the date that the claim was received from the accountholder. CONDITIONAL 2023-09-09 Only applicable for submitted claims. Claim Details CustomerDiscoveryDate DATE The date provided during intake on a lost or stolen claim that represents the date the claimant discovered that the card had been lost or stolen. CONDITIONAL 2023-09-09 Only applicable for submitted lost or stolen card claims. Claim Details IsPotentialAbuse BOOLEAN A specified number of claims submitted by a single customer/member within an established timeframe. The output of this property is a boolean (TRUE/FALSE). CONDITIONAL TRUE Only applicable for submitted claims that mean one or more potential abuse criteria. Claim Details Status 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 ProvisionalCreditDateTime TIMESTAMP_NTZ(9) Datetime when provisional credit was granted on a claim. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims where provisional credit has been granted. Claim Details PCDecision VARCHAR(16) CONDITIONAL Grant Only applicable for submitted claims. Claim Details Decision VARCHAR(64) "Paid" or "Denied". If one, or more, disputes on a claim are paid, the claim decision is "Paid". CONDITIONAL Paid, Denied Only applicable for resolved claims. Claim Details HasIdentifiedSuspect BOOLEAN Indicator of whether there were one, or more, suspects identified during claim intake. CONDITIONAL TRUE Only applicable for submitted claims. Claim Details PCDecisionFromIIDPreSubmission VARCHAR(16) Provisional credit decision set by the system during intake. CONDITIONAL AutoPay, Review Only applicable for submitted claims. Claim Details PCDecisionReason VARCHAR(255) Description of reason for the PC decision set by the system. CONDITIONAL Only applicable for submitted claims. Claim Details ResolvedDateTime TIMESTAMP_NTZ(9) Datetime that a claim or dispute is set to a "Resolved" status.. Also referred to as RESOLVEDDATETIME. CONDITIONAL 2023-09-09 21:00:00 Only applicable for resolved claims. Claim 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-09-09 21:00:00 Only applicable for submitted claims where a pay or deny decision has been rendered. Claim Details ReclassificationCount NUMBER(3,0) Number of times the claims has been reclassified. CONDITIONAL 1 Only applicable for reclassified claims. Claim Details RequiredDocumentCount NUMBER(3,0) CONDITIONAL 1 Only applicable for claims with required documents. Claim Details TimeZone VARCHAR(48) ALWAYS America/Los_Angeles Only applicable for submitted claims. Claim Details WasPCManuallyWithheld BOOLEAN Number of times the claims has been reclassified. ALWAYS TRUE, FALSE Compliance Details RegE10DateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation E. Compliance Details PCDocRequirementSatisifedDateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation E and have established document requirements that are satisfied. Compliance Details RegE10ThresholdDateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation E. Compliance Details RegE45DateTime TIMESTAMP_NTZ(9) Datetime assigned by the system by which a claim must be resolved in order to be compliant with Regulation E. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that include US ATM transactions and are covered by Regulation E. Compliance Details RegE90DateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation E and do not included US ATM transactions. Compliance Details RegEThresholdDateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation E. Compliance Details RegZ30DateTime TIMESTAMP_NTZ(9) Datetime assigned by the system by which claim acknowledgement must be completed in order to be compliant with Regulation Z. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z. Compliance Details RegZ30ThresholdDateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z. Compliance Details RegZ90DateTime TIMESTAMP_NTZ(9) Datetime assigned by the system by which a claim must be resolved in order to be compliant with Regulation Z. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z. Compliance Details RegZ90ThresholdDateTime TIMESTAMP_NTZ(9) CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z. Compliance Details RegZPCThresholdDateTime TIMESTAMP_NTZ(9) Datetime calculated by the system that represents the deadline for granting provisional credit or placing a dispute in dispute status in order to comply with in order to comply with § 1026.13(d)(1). CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z and meet the criteria for withholding protection. Compliance Details RegZPCDateTime TIMESTAMP_NTZ(9) Datetime calculated by the system, including any client-configured buffers, that represents the deadline for granting provisional credit or placing a dispute in dispute status in order to comply with in order to comply with § 1026.13(d)(1). CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims that are covered by Regulation Z and meet the criteria for withholding protection. Compliance Details IsFCRA BOOLEAN Indicates whether the FCRA Override was applied to the claim. CONDITIONAL TRUE Deflection Details ISANYTRANSACTIONDEFLECTEDFROMMERCHANTCREDIT BOOLEAN TRUE when 1 or more disputes are resolved-no action, due to merchant credit. CONDITIONAL TRUE Only available with Deflection booster. Deflection Details ISANYTRANSACTIONDEFLECTEDFROMPURCHASEINQUIRY BOOLEAN TRUE when 1 or more disputes are resolved-no action, due to purchase inquiry details. CONDITIONAL TRUE Only available with Deflection booster. Deflection Details ISANYTRANSACTIONDEFLECTEDFROMUNDISPUTEDHISTORY BOOLEAN TRUE when 1 or more disputes are resolved-no action, due to undisputed history. CONDITIONAL TRUE Only available with Deflection booster. Metadata AssociatedTagsCSV VARCHAR(256) Comma-separated list of user-applied tags. CONDITIONAL FEB2024BINATTACK Added in 25.01. Metadata CreatedbyUserId VARCHAR(64) The username of the user that created the claim. CONDITIONAL devan.robertson@quavo.com Only applicable for submitted claims. Metadata SaveDateTime TIMESTAMP_NTZ(9) ALWAYS 2023-09-09 21:00:00 Metadata CreateDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. ALWAYS 2023-09-09 21:00:00 Metadata SubmittedDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims. Metadata StatusChangedDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. CONDITIONAL 2023-09-09 21:00:00 Only applicable for submitted claims. 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|2306060014C CONDITIONAL VARCHAR(32) VARCHAR(32) Account Details Account Details Account Details Account Details