Versions Compared

Version Old Version 1 New Version 2
Changes made by

Devan Robertson

Devan Robertson

Saved on

Key

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

...

CustomerContactDate

NUMBER(3,0)

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

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Key

Claim Details

ClaimType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Account Claim Details

CustomerIdClaimCategory

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptcustomer idClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123456Fraud

Account Claim Details

IsEmployeeClaim

BOOLEAN

CONDITIONAL

false

Account Details

AccountNumber

ClaimReason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptAccount IDClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

0000123456Stolen

Account Compliance Details

IsEnrolledInAutopay

BOOLEAN

CONDITIONAL

TRUE

Account Details

NextPaymentDate

DATE

CONDITIONAL

2023-09-09

Account Details

StatementCycleDate

DATE

CONDITIONAL

2023-09-09

Account Details

AccountOpenDate

DATE

RegulatoryCoverage

VARCHAR

Multiexcerpt include
macro_uuid8539b4515685cd1e-d92199c2-460e40db-8dd19a77-53050f3060a774d274228986
nameMultiExcerptNameglossary_description
templateDataeJyLjgUAARUAuQ==
pageAccount Open Date
addpanelPageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Available in 24.01.03.

Account Details

AccountTypeReg E

Claim Details

ClaimChannel

VARCHAR(32)

Card Details

CardBIN

VARCHAR(8

Multiexcerpt include
Account Open Date
macro_uuid8539b4515685cd1e-d92199c2-460e40db-8dd19a77-53050f3060a7
nameglossary_description
74d274228986
templateDataeJyLjgUAARUAuQ==page
MultiExcerptNameglossary_description
addpanelfalse

CONDITIONAL

“Deposit”, “Credit Card”

Available in 24.01.03.

Card Details

CardType

VARCHAR(16)

CONDITIONAL

Debit

PageWithExcerptClaim Channel

ALWAYS

Online Banking

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptBINClaim ID
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

412356, 41235678

Card Details

CardNumberLast4

VARCHAR(4)

Last 4 digits of the Card Number.

CONDITIONAL

5555

ALWAYS

2306060014C

Claim Details

ReasonType

VARCHAR(64)CreateDate

DATE

Multiexcerpt include
Multiexcerpt include
glossarydescription
MultiExcerptNamemacro_
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

Reason

VARCHAR(64)

uuid45c8dff0-944f-4e53-8ee3-da245af4a176
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
PageWithExcerptaddpanelClaim Reasonfalse
shouldDisplayInlineCommentsInIncludesPageWithExcerptfalseCREATEDATETIME

CONDITIONALStolen

2023-09-09

Claim Details

ChannelOrigin

VARCHAR(32)

ALWAYS

Online Banking

Claim Details

ClaimAmount

NUMBER(20,2)

Multiexcerpt include

DATE

Multiexcerpt include
macro_uuidd99ef6b8-ca27-4139-8c27-79c2824a1215
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
PageWithExcerptaddpanelClaim Amountfalse
shouldDisplayInlineCommentsInIncludesPageWithExcerptfalseCustomer Contact Date

CONDITIONAL123.45

2023-09-09

Claim Details

TotalClaimAmountClaimAmount

NUMBER(20,2)

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

CONDITIONAL

123.45

Claim Details

CustomerContactDateClaimState

DATEVARCHAR

multiexcerpt-include
Multiexcerpt include
glossarydescription
MultiExcerptNamemacro_
PageWithExcerptContact Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Claim Details

CustomerDiscoveryDate

DATE

Status

uuid261deb9e-b155-44f1-9f3e-b8d10e211bcd
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
PageWithExcerptCustomer Discovery Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Claim Details

IsPotentialAbuse

BOOLEAN

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPotential Abuse
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

FALSE

Claim Details

addpanelfalse
PageWithExcerptClaim Status Summary

ALWAYS

OPEN

Claim Details

ClaimStatus

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Claim Card Details

ProvisionalCreditDateTimeBIN

TIMESTAMP_NTZVARCHAR(98)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPROVISIONALCREDITDATETIMEBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

PCDecision412356, 41235678

Card Details

CardType

VARCHAR(16)

CONDITIONAL

GrantDebit

Claim Details

Decision

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Decision
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Paid, Denied

Claim Details

HasIdentifiedSuspectDiscoveryDate

BOOLEANDATE

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df
Multiexcerpt include
macro_uuid
MultiExcerptNameglossary_description
PageWithExcerptResolution Customer Discovery Date
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

TRUE, FALSE

Available in 24.01.03.

Claim Details

PCDecisionFromIIDPreSubmission

VARCHAR(16)

Multiexcerpt include
macro_uuiddb9d0b0b-3d45-4a33-9637-e2c1a4e0c2df
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptPC Decision From IID PreSubmission

ALWAYS

AutoPay, Review

Available in 24.01.03.

Claim Details

PCDecisionReason

VARCHAR(255)

Multiexcerpt include
macro_uuiddb9d0b0b-3d45-4a33-9637-e2c1a4e0c2df
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptPC Decision Reason

CONDITIONAL

Available in 24.01.03.

Claim Details

ResolvedDateTime

CONDITIONAL

2023-09-09

Claim Details

InvestigationCompleteDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptResolution Investigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Compliance Details

InvestigationCompleteDateTimeInvestigationDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptInvestigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Compliance Details

ReclassificationCount

NUMBER(3,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Claim Details

RequiredDocumentCount

NUMBER(3,0ResolutionDeadline

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Claim Details

TimeZone

VARCHAR(48)

ALWAYS

America/Los_Angeles

Claim Details

WasPCManuallyWithheld

BOOLEAN

Multiexcerpt include
macro_uuid110346a17ed218f1-c1f8494b-45bd472c-bf938051-efc782936b0282d520c4434a
MultiExcerptNameglossary_description
PageWithExcerptReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

TRUE, FALSE

Available in 24.01.03.

Compliance Details

RegE10DateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg E 10 DateTime
Investigation Completed Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Claim Details

PCDocRequirementSatisifedDateTimeResolvedDate

TIMESTAMP_NTZ(9)

macro_uuid
Multiexcerpt include
69e181af-8ebb-4e96-b6b2-96aebc3aa1e5MultiExcerptNameglossary_description
PageWithExcerptReg E 10 DateTimeResolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Compliance Risk Details

RegE10ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegE45DateTime

TIMESTAMP_NTZ(9)

PotentialAbuse

BOOLEAN

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg E DateTimePotential Abuse
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance FALSE

Risk Details

RegE90DateTime

TIMESTAMP_NTZ(9)EmployeeClaim

BOOLEAN

CONDITIONAL

2023-09-09 21:00:00

Compliance false

Claim Details

RegEThresholdDateTimePCDecision

TIMESTAMP_NTZVARCHAR(916)

CONDITIONAL

2023-09-09 21:00:00

Compliance Grant

Claim Details

RegZ30DateTimePCDate

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg Z 30 DateTimePROVISIONALCREDITDATETIME
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Claim Details

RegZ30ThresholdDateTimeReclassifications

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ90DateTime

TIMESTAMP_NTZ(9NUMBER(3,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg Z DateTimeReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance 1

Claim Details

RegZ90ThresholdDateTimeRequiredDocuments

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZPCThresholdDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
macro_uuid8205c579-7f38-4507-b8b9-68628f59264f
templateDataeJyLjgUAARUAuQ==

Compliance Details

IsFCRA

BOOLEAN

Indicates whether the FCRA Override was applied to the claim.

CONDITIONAL

FALSE

Metadata

CreatedbyUserId

Multiexcerpt include
MultiExcerptNameglossary_descriptionaddpanelfalse
PageWithExcerptReg Z Withholding Threshold Date

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Compliance Details

RegZPCDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
macro_uuid8205c579-7f38-4507-b8b9-68628f59264f
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptReg Z Withholding Date

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Required 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.

MetadataDispute Details

SaveDateTimeDisputeCount

TIMESTAMP_NTZ(9NUMBER(3,0)

ALWAYS

2023-09-09 21:00:00

Metadata

CreateDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCREATEDATETIME
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2023-09-09 21:00:00Dispute Details

DisputeAmount

NUMBER(20,2)

Dispute Details

MerchantCreditAmount

NUMBER(20,2)

Dispute Details

RecoveredAmount

NUMBER(20,2)

Dispute Details

LossAmount

NUMBER(20,2)