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

ClientId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Key

ClaimType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Account Details

CustomerId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptcustomer id
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123456

Account Details

IsEmployeeClaim

BOOLEAN

CONDITIONAL

false

Account Details

AccountNumber

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptAccount ID
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

0000123456

Account 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

Multiexcerpt include macro
macro_uuid8539b451-d921-460e-8dd1-53050f3060a7
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageAccount Open Date
addpanelfalse

CONDITIONAL

2023-09-09

Available in 24.01.03.

Account Details

AccountType

VARCHAR(32)

Multiexcerpt include macro
macro_uuid8539b451-d921-460e-8dd1-53050f3060a7
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageAccount Open Date
addpanelfalse

CONDITIONAL

“Deposit”, “Credit Card”

Available in 24.01.03.

Card Details

CardType

VARCHAR(16)

CONDITIONAL

Debit

Card Details

CardBIN

VARCHAR(8)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptBIN
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

412356, 41235678

Card Details

CardNumberLast4

VARCHAR(4)

Last 4 digits of the Card Number.

CONDITIONAL

5555

Claim Details

ReasonType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

Reason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Stolen

Claim Details

ChannelOrigin

VARCHAR(32)

ALWAYS

Online Banking

Claim Details

ClaimAmount

NUMBER(20,2)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Amount
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.45

Claim Details

TotalClaimAmount

NUMBER(20,2)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptTotal Claim Amount
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

123.45

Claim Details

CustomerContactDate

DATE

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptContact Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09

Claim Details

CustomerDiscoveryDate

DATE

Multiexcerpt include
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

Status

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Claim Details

ProvisionalCreditDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPROVISIONALCREDITDATETIME
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

PCDecision

VARCHAR(16)

CONDITIONAL

Grant

Claim Details

Decision

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Decision
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Paid, Denied

Claim Details

HasIdentifiedSuspect

BOOLEAN

Multiexcerpt include
macro_uuiddb9d0b0b-3d45-4a33-9637-e2c1a4e0c2df
MultiExcerptNameglossary_description
PageWithExcerptResolution Date
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

TRUE, FALSE

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

Claim Details

PCDecisionReason

VARCHAR(255)

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

CONDITIONAL

Claim Details

ResolvedDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptResolution Date
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

InvestigationCompleteDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptINVESTIGATIONCOMPLETEDATETIME
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Claim Details

ReclassificationCount

NUMBER(3,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Claim Details

RequiredDocumentCount

NUMBER(3,0)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptRequired Document Count
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

1

Claim Details

TimeZone

VARCHAR(48)

ALWAYS

America/Los_Angeles

Claim Details

WASPCMANUALLYWITHHELD

WasPCManuallyWithheld

BOOLEAN

Multiexcerpt include
macro_uuid110346a1-c1f8-45bd-bf93-efc782936b02
MultiExcerptNameglossary_description
PageWithExcerptReclassification Count
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

TRUE, FALSE

Compliance Details

RegE10DateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg E 10 DateTime
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegE10ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegE45DateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg E DateTime
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegE90DateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegEThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ30DateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg Z 30 DateTime
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ30ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ90DateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg Z DateTime
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ90ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

IsFCRA

BOOLEAN

Indicates whether the FCRA Override was applied to the claim.

CONDITIONAL

FALSE

Metadata

SaveDateTime

TIMESTAMP_NTZ(9)

ALWAYS

2023-09-09 21:00:00

Metadata

CreateDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptCREATEDATETIME
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2023-09-09 21:00:00

Metadata

EventDateTime

TIMESTAMP_NTZ(9)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptEVENTDATETIME
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2023-09-09 21:00:00

Metadata

EventIdentifier

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptEVENTIDENTIFIER
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

70b1c86d-d06f-4c93-bab2-0e938a4ef768

Metadata

EventItemId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptEVENTITEMID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

qvo-stg|2306060014C