Data Category
Event Field/Column Name
Data Type
Description
Applicability
Sample Value
Notes
Key
TenantId
VARCHAR(32)
glossary_description
ALWAYS
qvo-stg
Key
ClientId
VARCHAR(64)
glossary_description
ALWAYS
Default
Key
ClaimId
VARCHAR(32)
glossary_description
ALWAYS
2306060014C
Key
ClaimType
VARCHAR(64)
glossary_description
CONDITIONAL
Card-Pinless
Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details
CustomerId
VARCHAR(64)
glossary_description
CONDITIONAL
123456
Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details
IsEmployeeClaim
BOOLEAN
CONDITIONALfalse
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_description
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==
CONDITIONAL
2023-09-09
Available in 24.01.03 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==
CONDITIONAL
“Deposit”, “Credit Card”
Available in 24.01.03. 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_description
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_description
CONDITIONAL
ATM, Account Merchandise Service, Authorization, Dispute, Fraud, Identity Theft, Incorrect, Missing, Revoked
Only applicable for submitted claims.
Claim Details
Reason
VARCHAR(64)
glossary_description
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_description
CONDITIONAL
123.45
Only applicable for submitted claims.
Claim Details
TotalClaimAmount
NUMBER(20,2)
glossary_description
CONDITIONAL
123.45
Only applicable for submitted claims.
Claim Details
CustomerContactDate
DATE
4ffc432b-81b9-4b3b-8a9a-0ed7f61d45b5 glossary_description eJyLjgUAARUAuQ== false
CONDITIONAL
2023-09-09
Only applicable for submitted claims.
Claim Details
CustomerDiscoveryDate
DATE
glossary_description
CONDITIONAL
2023-09-09
Only applicable for submitted lost or stolen card claims.
Claim Details
IsPotentialAbuse
BOOLEAN
glossary_description
CONDITIONAL
FALSE TRUE
Only applicable for submitted claims that mean one or more potential abuse criteria.
Claim Details
Status
VARCHAR(64)
glossary_description
ALWAYS
RESOLVED-PAID
Claim Details
ProvisionalCreditDateTime
TIMESTAMP_NTZ(9)
glossary_description
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_description
CONDITIONAL
Paid, Denied
Only applicable for resolved claims.
Claim Details
HasIdentifiedSuspect
BOOLEAN
db9d0b0b 2e0a1c9f - 3d45 85c9 - 4a33 4e9d - 9637 8342 - e2c1a4e0c2df f7c0e2bc907c glossary_description eJyLjgUAARUAuQ== false
ALWAYS CONDITIONAL
TRUE, FALSEAvailable in 24.01.03
Only applicable for submitted claims .
Claim Details
PCDecisionFromIIDPreSubmission
VARCHAR(16)
db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse
ALWAYS CONDITIONAL
AutoPay, Review
Available in 24.01.03. Only applicable for submitted claims.
Claim Details
PCDecisionReason
VARCHAR(255)
db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse
CONDITIONALAvailable
in 24.01.03 Only applicable for submitted claims .
Claim Details
ResolvedDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-09-09 21:00:00
Only applicable for resolved claims.
Claim Details
InvestigationCompleteDateTime
TIMESTAMP_NTZ(9)
glossary_description
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_description
CONDITIONAL
1
Only applicable for reclassified claims.
Claim Details
RequiredDocumentCount
NUMBER(3,0)
glossary_description
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_description
ALWAYS
TRUE, FALSEAvailable in 24.01.03.
Compliance Details
RegE10DateTime
TIMESTAMP_NTZ(9)glossary_description false
CONDITIONAL
2023-09-09 21:00:00
Only applicable for submitted claims that are covered by Regulation E.
Compliance Details
PCDocRequirementSatisifedDateTime
TIMESTAMP_NTZ(9)69e181af-8ebb-4e96-b6b2-96aebc3aa1e5 glossary_description false
CONDITIONAL
2023-09-09 21:00:00
Available in 24.01.03. 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_description
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_description
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_description
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
Available in 24.01.03 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
Available in 24.01.03. 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
FALSE 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 Available in 24.01.03
Only applicable for submitted claims .
Metadata
SaveDateTime
TIMESTAMP_NTZ(9)
ALWAYS
2023-09-09 21:00:00
Metadata
CreateDateTime
TIMESTAMP_NTZ(9)
glossary_description
ALWAYS
2023-09-09 21:00:00
Metadata
SubmittedDateTime
TIMESTAMP_NTZ(9)
863749f2-d1af-469c-a9ba-f14473f15b1fglossary_description
CONDITIONAL
2023-09-09 21:00:00
Available in 24.01.03. Only applicable for submitted claims.
Metadata
StatusChangedDateTime
TIMESTAMP_NTZ(9)
0029fa70-44a4-47ae-8b0d-98991ddce573glossary_description
CONDITIONAL
2023-09-09 21:00:00
Available in 24.01.03 Only applicable for submitted claims .
Metadata
EventDateTime
TIMESTAMP_NTZ(9)
glossary_description
ALWAYS
2023-09-09 21:00:00
Metadata
EventIdentifier
VARCHAR(64)
glossary_description
ALWAYS
70b1c86d-d06f-4c93-bab2-0e938a4ef768
Metadata
EventItemId
VARCHAR(64)
glossary_description
ALWAYS
qvo-stg|2306060014C
