Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)VARCHARVisa

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptTenant ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

qvo-stg

Key

Tenant

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTenant
addpanelfalse

ALWAYS

Default

Key

ClientId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

Client

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageClient
addpanelfalse

ALWAYS

Default

Claim Details

ClaimTypeType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategoryCategory

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

ClaimReasonReason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Stolen

Compliance Details

RegulatoryCoverage

VARCHAR

Multiexcerpt include
macro_uuid5685cd1e-99c2-40db-9a77-74d274228986
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Reg E

Dispute Details

Network

VARCHAR

Visa, Mastercard

Claim Details

ClaimChannelChannel

VARCHAR(32)

Multiexcerpt include
macro_uuid5685cd1e-99c2-40db-9a77-74d274228986
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptClaim Channel

ALWAYS

Online Banking

Card Details

CardType

VARCHAR(16)

Multiexcerpt include
macro_uuid97e89f13-1c2e-41c7-925f-3c97f32515db
MultiExcerptNameglossary_description
PageWithExcerptBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Debit

Card Details

BIN

VARCHAR(8)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

412356, 41235678

Transaction Details

TransactionType

VARCHAR

Multiexcerpt include macro
macro_uuid3195254b-6a01-4d6a-9f3d-3dfe0f7f14a1
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTransaction Type
addpanelfalse

ALWAYS

ATM

Card Details

BIN

VARCHAR

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

412356, 41235678

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

Multiexcerpt include macro
macro_uuida3e31307-8cb9-40d8-8eef-f74f27879680
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageDispute ID
addpanelfalse

ALWAYS

2306060014D

Claim Details

ClaimStatus

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Dispute Details

DisputeStatus

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Dispute Details

DisputeStatusType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Claim Dispute Details

CreateDateDenyReason

DATEVARCHAR

Multiexcerpt include
glossary_description
macro_uuid45c8dff02e92bee9-944f0ad2-4e534bd4-8ee3-da245af4a176a47b-9c6aee2a8ac7
nameglossary_description
templateDataeJyLjgUAARUAuQ==MultiExcerptName
pageDeny Reason
addpanelfalse
PageWithExcerptCREATEDATETIME

CONDITIONAL2023

-09-09No Error

Claim Details

CustomerContactDateContactDate

DATE

Multiexcerpt include
macro_uuidd99ef6b8-ca27-4139-8c27-79c2824a1215
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCustomer Contact Date

CONDITIONAL

2023-09-09

Claim Details

ClaimAmount

NUMBER(20,2)CreateDate

DATE

Multiexcerpt include
macro_uuid261deb9e45c8dff0-b155944f-44f14e53-9f3e-b8d10e211bcd
MultiExcerptNameglossary_description
PageWithExcerptClaim Amount
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.45

Claim Details

ClaimState

VARCHAR

Multiexcerpt include
macro_uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
8ee3-da245af4a176
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptClaim Status Summary

ALWAYS

OPEN

Claim Details

Decision

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Decision
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Paid, Denied

Claim Details

DiscoveryDate

DATE

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCustomer Discovery Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Compliance Details

InvestigationDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

ResolutionDeadline

TIMESTAMP_NTZ(9)

Multiexcerpt include macro
macro_uuid027fa8ef-0adf-4d64-8d22-eb934d764d70
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageRegulatory Resolution Deadline
addpanelfalse

CREATEDATETIME

CONDITIONAL

2023-09-09 21:00:00

Claim Details

ResolvedDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptResolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Risk Transaction Details

PotentialAbuse

BOOLEAN

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPotential Abuse
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

FALSE

Risk Details

EmployeeClaim

BOOLEAN

Multiexcerpt include
macro_uuid91afd1e2-a292-4a59-a8a4-669839e9b53a
MultiExcerptNameglossary_description
PageWithExcerptPotential Abuse
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

false

Claim Details

PCDecision

VARCHAR(16)AuthorizationStatus

VARCHAR

Multiexcerpt include
macro_uuid91afd1e2-a292-4a59-a8a4-669839e9b53a
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_descriptionaddpanelfalse
Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPROVISIONALCREDITDATETIME
PageWithExcerptPC Decision

CONDITIONAL

Grant

Claim Details

PCDate

TIMESTAMP_NTZ(9)

Authorization Status
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

Reclassifications

NUMBER(3,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Claim Details

RequiredDocuments

NUMBER(3,0ALWAYS

Pending, Posted

Transaction Details

MerchantCategoryCode

VARCHAR(6)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptRequired Document CountMerchant Category Code
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Metadata

CreatedBy

VARCHAR(64)

The username of the user that created the claim.

CONDITIONAL

devan.robertson@quavo.com

Available in 24.01.03.

Dispute Details

DisputeCount

NUMBER(3,0)

Multiexcerpt include
macro_uuid6e32305a-3507-48ee-9aa3-09af5eaba4e5
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptDispute Count

CONDITIONAL

2

Dispute Details

4829

Dispute Details

DisputeAmount

NUMBER(20,2)

Multiexcerpt include
macro_uuid103f1606-1b62-436a-81bb-d17588afd4cb
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptDispute Amount

CONDITIONAL

123.59

Dispute Details

MerchantCreditAmount

NUMBER(20,2)

Multiexcerpt include macro
macro_uuid27d56e9c-828f-40d8-8c30-5ae5841cecd6
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageMerchant Credit Balance
addpanelfalse

CONDITIONAL

123.59

Dispute Details

RecoveredAmount

NUMBER(20,2)

Multiexcerpt include macro
macro_uuid5835dccc-cf95-4910-9bc2-9c45ad829860
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageRecovered Amount
addpanelfalse

CONDITIONAL

123.59

Dispute Details

LossAmount

NUMBER(20,2)

Multiexcerpt include macro
macro_uuidbec857fa-cc36-4255-a95d-491416e54f60
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageLoss Balance
addpanelfalse

CONDITIONAL

123.59