Versions Compared

Key

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

Name

ClaimsBasic

Type

View

Description

A lighter weight version of the Claims View for basic calculations and aggregations.

Fields

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

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

CONDITIONAL

Debit

Claim Details

ResolvedDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptResolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

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

Age

NUMBER(20,2)

Current Date - Create Date (DAYS)

ALWAYS

48