Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|
Key | TenantId | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | qvo-stg | |
Key | ClientId | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | Default | |
Key | ClaimId | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | 2306060014C | |
Key | ClaimType | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | Card-Pinless | Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission). |
Account Details | CustomerId | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | 123456 | Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission). |
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) | glossary_descriptionfalse | 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 | 8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | 2023-09-09 | Only applicable for submitted claims where a value is provided by the System of Record. |
Account Details | AccountType | VARCHAR(32) | 8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false | 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) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | CONDITIONAL | ATM, Account Merchandise Service, Authorization, Dispute, Fraud, Identity Theft, Incorrect, Missing, Revoked | Only applicable for submitted claims. |
Claim Details | Reason | VARCHAR(64) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | CONDITIONAL | 123.45 | Only applicable for submitted claims. |
Claim Details | TotalClaimAmount | NUMBER(20,2) | glossary_descriptionfalse | CONDITIONAL | 123.45 | Only applicable for submitted claims. |
Claim Details | CustomerContactDate | DATE | 4ffc432b-81b9-4b3b-8a9a-0ed7f61d45b5glossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | 2023-09-09 | Only applicable for submitted claims. |
Claim Details | CustomerDiscoveryDate | DATE | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 | Only applicable for submitted lost or stolen card claims. |
Claim Details | IsPotentialAbuse | BOOLEAN | glossary_descriptionfalse | CONDITIONAL | TRUE | Only applicable for submitted claims that mean one or more potential abuse criteria. |
Claim Details | Status | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | RESOLVED-PAID | |
Claim Details | ProvisionalCreditDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | CONDITIONAL | Paid, Denied | Only applicable for resolved claims. |
Claim Details | HasIdentifiedSuspect | BOOLEAN | db9d0b0b2e0a1c9f-3d4585c9-4a334e9d-96378342-e2c1a4e0c2dff7c0e2bc907cglossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | TRUE | Only applicable for submitted claims. |
Claim Details | PCDecisionFromIIDPreSubmission | VARCHAR(16) | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | AutoPay, Review | Only applicable for submitted claims. |
Claim Details | PCDecisionReason | VARCHAR(255) | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | | Only applicable for submitted claims. |
Claim Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Only applicable for resolved claims. |
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | CONDITIONAL | 1 | Only applicable for reclassified claims. |
Claim Details | RequiredDocumentCount | NUMBER(3,0) | glossary_descriptionfalse | 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 | 110346a1-c1f8-45bd-bf93-efc782936b02glossary_descriptionfalse | 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) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | 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) | glossary_descriptionfalse | 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) | 8205c579-7f38-4507-b8b9-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse | 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) | 8205c579-7f38-4507-b8b9-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse | 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 | 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) | glossary_descriptionfalse | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | SubmittedDateTime | TIMESTAMP_NTZ(9) | 863749f2-d1af-469c-a9ba-f14473f15b1fglossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Only applicable for submitted claims. |
Metadata | StatusChangedDateTime | TIMESTAMP_NTZ(9) | 0029fa70-44a4-47ae-8b0d-98991ddce573glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Only applicable for submitted claims. |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventIdentifier | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |
Metadata | EventItemId | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | qvo-stg|2306060014C | |
