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
Account Details
CustomerId
VARCHAR(64)
glossary_description
CONDITIONAL
123456
Account Details
IsEmployeeClaim
BOOLEAN
CONDITIONAL
false
Account Details
AccountNumber
VARCHAR(64)
glossary_description
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==
CONDITIONAL
2023-09-09
Available in 24.01.03.
Account Details
AccountType
VARCHAR(32)
8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==
CONDITIONAL
“Deposit”, “Credit Card”
Available in 24.01.03.
Card Details
CardType
VARCHAR(16)
CONDITIONAL
Debit
Card Details
CardBIN
VARCHAR(8)
glossary_description
CONDITIONAL
412356, 41235678
Card Details
CardNumberLast4
VARCHAR(4)
Last 4 digits of the Card Number.
CONDITIONAL
5555
Claim Details
ReasonType
VARCHAR(64)
glossary_description
CONDITIONAL
Fraud
Claim Details
Reason
VARCHAR(64)
glossary_description
CONDITIONAL
Stolen
Claim Details
ChannelOrigin
VARCHAR(32)
ALWAYS
Online Banking
Claim Details
ClaimAmount
NUMBER(20,2)
glossary_description
CONDITIONAL
123.45
Claim Details
TotalClaimAmount
NUMBER(20,2)
glossary_description
CONDITIONAL
123.45
Claim Details
CustomerContactDate
DATE
glossary_description
CONDITIONAL
2023-09-09
Claim Details
CustomerDiscoveryDate
DATE
glossary_description
CONDITIONAL
2023-09-09
Claim Details
IsPotentialAbuse
BOOLEAN
glossary_description
CONDITIONAL
FALSE
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
Claim Details
PCDecision
VARCHAR(16)
CONDITIONAL
Grant
Claim Details
Decision
VARCHAR(64)
glossary_description
CONDITIONAL
Paid, Denied
Claim Details
HasIdentifiedSuspect
BOOLEAN
db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfglossary_description
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_description
CONDITIONAL
2023-09-09 21:00:00
Claim Details
InvestigationCompleteDateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-09-09 21:00:00
Claim Details
ReclassificationCount
NUMBER(3,0)
glossary_description
CONDITIONAL
1
Claim Details
RequiredDocumentCount
NUMBER(3,0)
glossary_description
CONDITIONAL
1
Claim Details
TimeZone
VARCHAR(48)
ALWAYS
America/Los_Angeles
Claim Details
WasPCManuallyWithheld
BOOLEAN
110346a1-c1f8-45bd-bf93-efc782936b02glossary_description
ALWAYS
TRUE, FALSE
Available in 24.01.03.
Compliance Details
RegE10DateTime
TIMESTAMP_NTZ(9)
glossary_description
CONDITIONAL
2023-09-09 21:00:00
Compliance Details
PCDocRequirementSatisifedDateTime
TIMESTAMP_NTZ(9)
69e181af-8ebb-4e96-b6b2-96aebc3aa1e5glossary_description
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_description
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_description
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_description
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_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.
Metadata
StatusChangedDateTime
TIMESTAMP_NTZ(9)
0029fa70-44a4-47ae-8b0d-98991ddce573glossary_description
CONDITIONAL
2023-09-09 21:00:00
Available in 24.01.03.
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
