Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerptmultiexcerpt-macro
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.
hiddenfalse
nameDescription
fallbackfalse

Authorization Matching events provide all the data necessary to evaluate the effectiveness of potential posting matching logic.  When a posted transaction is automatically matched to a disputed authorization by the system, an event is created.  When a posting is identified by a user, an event is created.  When a posting is referred to a user by the system, and the user does not identify it as a match for the disputed authorization, an event is created. 

...

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

DisputeId

VARCHAR(32)

...

glossary_description

...

false

ALWAYS

2306050001D

Posting Details

PostingMatchList[].TransactionDate/TRANSACTIONDATE

DATE

...

...

glossary_description

...

...

false

CONDITIONAL

2023-10-07

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].AuthorizationCode/AUTHCODE

VARCHAR(10)

...

glossary_description

...

false

CONDITIONAL

031832

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].TransactionId/TRANSACTIONID

VARCHAR(256)

...

glossary_description

...

false

...

CONDITIONAL

5315158617D1116187908

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].PostingDate/POSTINGDATE

DATE

...

glossary_description

...

...

false

CONDITIONAL

2023-0909

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].Description/DESCRIPTION

VARCHAR(256)

...

glossary_description

...

false

CONDITIONAL

STARLINK INTERNET

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].MerchantName/MERCHANTNAME

VARCHAR(256)

...

...

glossary_description

...

...

false

CONDITIONAL

STARLINK INTERNET

Only applicable when provided by the System of Record.

Posting Details

PostingMatchList[].Amount/AMOUNT

NUMBER(9,2)

The amount of the posted transaction.

ALWAYS

133.13

Posting Details

AuthMatchingOutcome/OUTCOME

VARCHAR(16)

...

glossary_description_merchantcredit

...

...

false

ALWAYS

"Auto", "Manual", "No Match"

Posting Details

PostingMatchList[].Iteration/ITERATION

NUMBER(2,0)

...

glossary_description

...

false

...

CONDITIONAL

1

Only applicable when a potential match is identified.

Posting Details

PostingMatchList[].MatchResult/MATCHRESULT

VARCHAR(16)

...

glossary_description

...

false

...

CONDITIONAL

"Auto Match", "Review"

Only applicable when a potential match is identified.

Posting Details

PostingMatchList[].PostedDisputeId/POSTEDDISPUTEID

VARCHAR(32)

...

glossary_description

...

...

false

CONDITIONAL

2310110380D

Only applicable for authorizations that post.

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|2302030002D