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
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
