Versions Compared

Key

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

...

MultiExcerptNameALWAYS

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

Transaction Details

Network

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptNetwork
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Mastercard, Visa

Claim Details

ClaimChannel

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

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

Dispute Details

Decision

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Decision
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Paid, Denied

Dispute Details

DenyReason

VARCHAR

Multiexcerpt include macro
macro_uuid2e92bee9-0ad2-4bd4-a47b-9c6aee2a8ac7
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageDeny Reason
addpanelfalse

CONDITIONAL

No Error

Transaction Details

TransactionDate

DATE

Multiexcerpt include macro
macro_uuidf9b82b6c-1d48-4821-afec-d7c7a4493a68
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTransaction Date
addpanelfalse

ALWAYS

2023-09-09

Claim Details

CreateDateContactDate

DATE

Multiexcerpt include
macro_uuid45c8dff0d99ef6b8-944fca27-4e534139-8ee38c27-da245af4a17679c2824a1215
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCREATEDATETIMECustomer Contact Date

CONDITIONALALWAYS

2023-09-09

Claim Dispute Details

CustomerContactDateCreateDate

DATE

Multiexcerpt include
macro_uuidd99ef6b845c8dff0-ca27944f-41394e53-8c278ee3-79c2824a1215da245af4a176
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCustomer Contact DateCREATEDATETIME

CONDITIONALALWAYS

2023-09-09

Claim Dispute Details

ClaimAmountInvestigationDate

NUMBER(20,2TIMESTAMP_NTZ(9)

Multiexcerpt include
macro_uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
MultiExcerptNameglossary_description
PageWithExcerptClaim AmountInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.45

Claim Details

ClaimState

VARCHAR2023-09-09 21:00:00

Dispute Details

ResolvedDate

TIMESTAMP_NTZ(9)

VARCHAR(64

Multiexcerpt include
macro_uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_descriptionaddpanelfalse
PageWithExcerptClaim Status Type

ALWAYS

OPEN

Dispute Details

Decision

Resolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Transaction Details

AuthorizationStatus

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim DecisionAuthorization Status
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONALALWAYS

PaidPending, DeniedPosted

Claim Transaction Details

DiscoveryDate

DATEMerchantCategoryCode

VARCHAR(6)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCustomer Discovery DateMerchant Category Code
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Compliance 8999

Transaction Details

InvestigationDate

TIMESTAMP_NTZ(9)

Merchant

2023-09

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

-
09 21:00:00

Compliance Details

ResolutionDeadline

TIMESTAMP_NTZ(9)

multiexcerpt-include-macro
macro_uuid027fa8efde3e24ca-0adf565a-4d6441c8-8d22b800-eb934d764d70c2659d0922c2
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageRegulatory Resolution DeadlineMerchant Name
addpanelfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

ResolvedDate

TIMESTAMP_NTZ(9)

Multiexcerpt include

PAYPAL

Transaction Details

POSEntryMode

2023-09-09 21:00:00

Multiexcerpt include macro
macro_uuidde3e24ca-565a-41c8-b800-c2659d0922c2
nameglossary_description
PageWithExcerptResolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

templateDataeJyLjgUAARUAuQ==
pagePOS Entry Mode
addpanelfalse

CONDITIONAL

81

Transaction Details

AuthorizationStatus

VARCHAR(32)TransactionDescription

Dispute Details

DisputeCount

NUMBER(3,0

MultiExcerptName
Multiexcerpt include
-macro
macro_uuidde3e24ca-565a-41c8-b800-c2659d0922c2
nameglossary_description
PageWithExcerptAuthorization Status
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Pending, Posted

Transaction Details

MerchantCategoryCode

VARCHAR(6)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptMerchant Category Code
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

4829

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.

templateDataeJyLjgUAARUAuQ==
pageTransaction Description
addpanelfalse

ALWAYS

PAYPAL *CASHAPP0777701 402-935-7733 CA

Dispute Details

DisputeAmount

NUMBER(20,2)

Multiexcerpt include
macro_uuid6e32305a103f1606-35071b62-48ee436a-9aa381bb-09af5eaba4e5d17588afd4cb
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptDispute CountAmount

CONDITIONAL2

123.59

Dispute Transaction Details

DisputeAmountTransactionAmount

NUMBER(20,2)

Multiexcerpt include
glossary_descriptionPageWithExcerpt
macro_uuid103f160623775cb8-919d-1b624041-436a-81bb-d17588afd4cb90f7-115777927901
nameglossary_description
templateDataeJyLjgUAARUAuQ==MultiExcerptName
pageTransaction Amount
addpanelfalse

ALWAYS

123.59

Dispute Details

AccoundholderAmount

NUMBER(20,2)

Amount of all accountholder adjustments.

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

Dispute Details

DeniedAmount

NUMBER(20,2)

Total amount denied.

CONDITIONAL

123.59

SQL

For greater transparency, and to provide clients with a “jumping off” point for their own queries, the SQL used to generated this view is provided below.

...