Versions Compared

Key

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

Name

Claims

Type

View

Description

The Claims view provides most of the same data information as the Claim table, though more consolidated, as well as additional columns that are useful in the context of claims, such as dispute count, dispute amount, recovered amount, etc.

...

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)

ALWAYS

Default

Key

ClientId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

Client

VARCHAR(64)

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 Summary

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)

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

CONDITIONAL

false

Claim Details

PCDecision

VARCHAR(16)

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

CONDITIONAL

2

Dispute Details

DisputeAmount

NUMBER(20,2)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.59

Dispute Details

MerchantCreditAmount

NUMBER(20,2)

Multiexcerpt include
macro_uuid1d778864-45ac-42f6-ae27-fe02c9b6a6ff
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.59

Dispute Details

RecoveredAmount

NUMBER(20,2)

Multiexcerpt include
macro_uuidaff246f2-579f-47c3-bd2c-d2c7722cdc93
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.59

Dispute Details

LossAmount

NUMBER(20,2)

Multiexcerpt include
macro_uuidd76dee79-cd21-400d-a738-e2ea3888e22b
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.59