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)

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

ClaimType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

ClaimReason

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

Claim Details

ClaimChannel

VARCHAR(32)

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

ALWAYS

Online Banking

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Claim Details

CreateDate

DATE

Multiexcerpt include
macro_uuid45c8dff0-944f-4e53-8ee3-da245af4a176
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCREATEDATETIME

CONDITIONAL

2023-09-09

Claim Details

CustomerContactDate

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)

Multiexcerpt include
macro_uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
MultiExcerptNameglossary_description
PageWithExcerptClaim Amount
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.45

Claim Details

ClaimState

VARCHAR

Multiexcerpt include
macro_uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptClaim Status SummaryType

ALWAYS

OPEN

Claim Details

ClaimStatus

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Card Details

BIN

VARCHAR(8)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

412356, 41235678

Card Details

CardType

VARCHAR(16)

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

CONDITIONAL

Debit

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

Claim Details

InvestigationCompleteDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

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_uuid7ed218f1-494b-472c-8051-82d520c4434a
MultiExcerptNameglossary_description
PageWithExcerptInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

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

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

CONDITIONAL

Grant

Claim Details

PCDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPROVISIONALCREDITDATETIME
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,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
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

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

...