Versions Compared

Key

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

...

Excerpt
nameEach time a change is saved to a claim-level property in QFD, an event is created.  This event includes all important claim details and will be useful for referencing from most other events to understand the full picture of the claim.

Each time a change is saved to a claim-level property in QFD, an event is created.  This event includes all important claim details and will be useful for referencing from most other events to understand the full picture of the claim.

Multiexcerpt macro
hiddenfalse
nameFields
fallbackfalse

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

...

glossary_description

...

...

false

ALWAYS

qvo-stg

Key

ClientId

VARCHAR(64)

...

glossary_description

...

false

ALWAYS

Default

Key

ClaimId

VARCHAR(32)

...

...

glossary_description

...

false

ALWAYS

2306060014C

Key

ClaimType

VARCHAR(64)

...

glossary_description

...

...

false

CONDITIONAL

Card-Pinless

Account Details

CustomerId

VARCHAR(64)

...

glossary_description

...

false

CONDITIONAL

123456

Account Details

IsEmployeeClaim

BOOLEAN

CONDITIONAL

false

Account Details

AccountNumber

VARCHAR(64)

...

...

glossary_description

...

false

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

...

8539b451-d921-460e-8dd1-53050f3060a7

...

glossary_description

...

eJyLjgUAARUAuQ==

...

...

false

CONDITIONAL

2023-09-09

Available in 24.01.03.

Account Details

AccountType

VARCHAR(32)

...

8539b451-d921-460e-8dd1-53050f3060a7

...

glossary_description

...

eJyLjgUAARUAuQ==

...

false

CONDITIONAL

“Deposit”, “Credit Card”

Available in 24.01.03.

Card Details

CardType

VARCHAR(16)

CONDITIONAL

Debit

Card Details

CardBIN

VARCHAR(8)

...

...

glossary_description

...

false

CONDITIONAL

412356, 41235678

Card Details

CardNumberLast4

VARCHAR(4)

Last 4 digits of the Card Number.

CONDITIONAL

5555

Claim Details

ReasonType

VARCHAR(64)

...

glossary_description

...

...

false

CONDITIONAL

Fraud

Claim Details

Reason

VARCHAR(64)

...

glossary_description

...

...

false

CONDITIONAL

Stolen

Claim Details

ChannelOrigin

VARCHAR(32)

ALWAYS

Online Banking

Claim Details

ClaimAmount

NUMBER(20,2)

...

glossary_description

...

false

CONDITIONAL

123.45

Claim Details

TotalClaimAmount

NUMBER(20,2)

...

glossary_description

...

...

false

CONDITIONAL

123.45

Claim Details

CustomerContactDate

DATE

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09

Claim Details

CustomerDiscoveryDate

DATE

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09

Claim Details

IsPotentialAbuse

BOOLEAN

...

glossary_description

...

false

CONDITIONAL

FALSE

Claim Details

Status

VARCHAR(64)

...

glossary_description

...

...

false

ALWAYS

RESOLVED-PAID

Claim Details

ProvisionalCreditDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Claim Details

PCDecision

VARCHAR(16)

CONDITIONAL

Grant

Claim Details

Decision

VARCHAR(64)

...

glossary_description

...

false

CONDITIONAL

Paid, Denied

Claim Details

HasIdentifiedSuspect

BOOLEAN

...

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df

...

glossary_description

...

false

ALWAYS

TRUE, FALSE

Available in 24.01.03.

Claim Details

PCDecisionFromIIDPreSubmission

VARCHAR(16)

...

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

ALWAYS

AutoPay, Review

Available in 24.01.03.

Claim Details

PCDecisionReason

VARCHAR(255)

...

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

Available in 24.01.03.

Claim Details

ResolvedDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Claim Details

InvestigationCompleteDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Claim Details

ReclassificationCount

NUMBER(3,0)

...

glossary_description

...

...

false

CONDITIONAL

1

Claim Details

RequiredDocumentCount

NUMBER(3,0)

...

glossary_description

...

...

false

CONDITIONAL

1

Claim Details

TimeZone

VARCHAR(48)

ALWAYS

America/Los_Angeles

Claim Details

WasPCManuallyWithheld

BOOLEAN

...

110346a1-c1f8-45bd-bf93-efc782936b02

...

glossary_description

...

...

false

ALWAYS

TRUE, FALSE

Available in 24.01.03.

Compliance Details

RegE10DateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

PCDocRequirementSatisifedDateTime

TIMESTAMP_NTZ(9)

...

69e181af-8ebb-4e96-b6b2-96aebc3aa1e5

...

glossary_description

...

false

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Compliance Details

RegE10ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegE45DateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

false

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)

...

glossary_description

...

false

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)

...

glossary_description

...

...

false

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZ90ThresholdDateTime

TIMESTAMP_NTZ(9)

CONDITIONAL

2023-09-09 21:00:00

Compliance Details

RegZPCThresholdDateTime

TIMESTAMP_NTZ(9)

...

8205c579-7f38-4507-b8b9-68628f59264f

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Compliance Details

RegZPCDateTime

TIMESTAMP_NTZ(9)

...

8205c579-7f38-4507-b8b9-68628f59264f

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Compliance Details

IsFCRA

BOOLEAN

Indicates whether the FCRA Override was applied to the claim.

CONDITIONAL

FALSE

Metadata

CreatedbyUserId

VARCHAR(64)

The username of the user that created the claim.

CONDITIONAL

devan.robertson@quavo.com

Available in 24.01.03.

Metadata

SaveDateTime

TIMESTAMP_NTZ(9)

ALWAYS

2023-09-09 21:00:00

Metadata

CreateDateTime

TIMESTAMP_NTZ(9)

...

glossary_description

...

false

ALWAYS

2023-09-09 21:00:00

Metadata

SubmittedDateTime

TIMESTAMP_NTZ(9)

...

863749f2-d1af-469c-a9ba-f14473f15b1f

...

glossary_description

...

false

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Metadata

StatusChangedDateTime

TIMESTAMP_NTZ(9)

...

0029fa70-44a4-47ae-8b0d-98991ddce573

...

glossary_description

...

false

CONDITIONAL

2023-09-09 21:00:00

Available in 24.01.03.

Metadata

EventDateTime

TIMESTAMP_NTZ(9)

...

...

glossary_description

...

false

ALWAYS

2023-09-09 21:00:00

Metadata

EventIdentifier

VARCHAR(64)

...

...

glossary_description

...

false

ALWAYS

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

Metadata

EventItemId

VARCHAR(64)

...

...

glossary_description

...

false

ALWAYS

qvo-stg|2306060014C