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 | |
Account Details | CustomerId | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | 123456 | |
Account Details | IsEmployeeClaim | BOOLEAN | | CONDITIONAL | false | |
Account Details | AccountNumber | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | 0000123456 | |
Account Details | IsEnrolledInAutopay | BOOLEAN | | CONDITIONAL | TRUE | |
Account Details | NextPaymentDate | DATE | | CONDITIONAL | 2023-09-09 | |
Account Details | StatementCycleDate | DATE | | CONDITIONAL | 2023-09-09 | |
Account Details | AccountOpenDate | DATE | 8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | 2023-09-09 | Available in 24.01.03. |
Account Details | AccountType | VARCHAR(32) | 8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false | CONDITIONAL | “Deposit”, “Credit Card” | Available in 24.01.03. |
Card Details | CardType | VARCHAR(16) | | CONDITIONAL | Debit | |
Card Details | CardBIN | VARCHAR(8) | glossary_descriptionfalse | CONDITIONAL | 412356, 41235678 | |
Card Details | CardNumberLast4 | VARCHAR(4) | Last 4 digits of the Card Number. | CONDITIONAL | 5555 | |
Claim Details | ReasonType | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | Fraud | |
Claim Details | Reason | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | Stolen | |
Claim Details | ChannelOrigin | VARCHAR(32) | | ALWAYS | Online Banking | |
Claim Details | ClaimAmount | NUMBER(20,2) | glossary_descriptionfalse | CONDITIONAL | 123.45 | |
Claim Details | TotalClaimAmount | NUMBER(20,2) | glossary_descriptionfalse | CONDITIONAL | 123.45 | |
Claim Details | CustomerContactDate | DATE | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 | |
Claim Details | CustomerDiscoveryDate | DATE | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 | |
Claim Details | IsPotentialAbuse | BOOLEAN | glossary_descriptionfalse | CONDITIONAL | FALSE | |
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 | |
Claim Details | PCDecision | VARCHAR(16) | | CONDITIONAL | Grant | |
Claim Details | Decision | VARCHAR(64) | glossary_descriptionfalse | CONDITIONAL | Paid, Denied | |
Claim Details | HasIdentifiedSuspect | BOOLEAN | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfglossary_descriptionfalse | ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Claim Details | PCDecisionFromIIDPreSubmission | VARCHAR(16) | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse | ALWAYS | AutoPay, Review | Available in 24.01.03. |
Claim Details | PCDecisionReason | VARCHAR(255) | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | | Available in 24.01.03. |
Claim Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Claim Details | ReclassificationCount | NUMBER(3,0) | glossary_descriptionfalse | CONDITIONAL | 1 | |
Claim Details | RequiredDocumentCount | NUMBER(3,0) | glossary_descriptionfalse | CONDITIONAL | 1 | |
Claim Details | TimeZone | VARCHAR(48) | | ALWAYS | America/Los_Angeles | |
Claim Details | WasPCManuallyWithheld | BOOLEAN | 110346a1-c1f8-45bd-bf93-efc782936b02glossary_descriptionfalse | ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Compliance Details | RegE10DateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | PCDocRequirementSatisifedDateTime | TIMESTAMP_NTZ(9) | 69e181af-8ebb-4e96-b6b2-96aebc3aa1e5glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegE10ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegE45DateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegE90DateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegEThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ30DateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ30ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ90DateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ90ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZPCThresholdDateTime | TIMESTAMP_NTZ(9) | 8205c579-7f38-4507-b8b9-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegZPCDateTime | TIMESTAMP_NTZ(9) | 8205c579-7f38-4507-b8b9-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | IsFCRA | BOOLEAN | Indicates whether the FCRA Override was applied to the claim. | CONDITIONAL | FALSE | |
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 | Available in 24.01.03. |
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 | Available in 24.01.03. |
Metadata | StatusChangedDateTime | TIMESTAMP_NTZ(9) | 0029fa70-44a4-47ae-8b0d-98991ddce573glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
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 | |
