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.

When an accounting record is created or executed in QFD, an event is generated.  The event includes all important details of the accounting adjustment.  This information is useful for reconciling GLs, as well as measuring compliance to regulatory requirements.

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

Key

ENTRYIDENTIFIER

VARCHAR(64)

...

glossary_description

...

false

ALWAYS

e5199543-c6b2-4cb6-937e-b278ca95979b

Key

StepIdentifier

VARCHAR(64)

...

...

glossary_description

...

...

false

ALWAYS

cb7f68e3-1fb1-49e8-a683-5232cf6992ce

Accounting Details

AMOUNT

NUMBER(9,2)

Amount of the accounting entry performed.

ALWAYS

123.23

Accounting Details

REASON

VARCHAR(64)

...

glossary_description

...

false

ALWAYS

Provisional Credit

Accounting Details

DEBITCREDIT

VARCHAR(16)

...

...

168a5d47-cc7d-4afe-859a-d32dcfda4015

...

glossary_description

...

...

false

ALWAYS

Debit, Credit

Accounting Details

COLLECTIONNAME

VARCHAR(64)

...

glossary_description

...

false

ALWAYS

Accountholder, Merchant, Loss, Suspense

Accounting Details

PERFORMEDBYOPERATORID

VARCHAR(128)

...

12b0df20-31b4-40de-8ffd-59f2151179fe

...

glossary_description

...

false

ALWAYS

devan.robertson@quavo.com

Metadata

PERFORMEDON

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

ALWAYS

2023-09-09 21:00:00

Accounting Details

EXECUTEDBYOPERATORID

VARCHAR(128)

...

glossary_description

...

...

false

CONDITIONAL

devan.robertson@quavo.com

Accounting Details

EXECUTEDON

TIMESTAMP_NTZ(9)

...

glossary_description

...

...

false

CONDITIONAL

2023-08-16 17:48:47.709

Accounting Details

ExecutionMethod

VARCHAR(32)

...

glossary_description

...

false

ALWAYS

AUTO

Accounting Details

AccountNumber

VARCHAR(128)

Account number associated with the account being debited or credited. Will be obfuscated it the account number is a full card number.

CONDITIONAL

123456789

Available in 24.01.03.

Accounting Details

IsManualEntry

BOOLEAN

...

...

c683dd99-4952-42c9-8008-b9e76d7184e1

...

glossary_description

...

eJyLjgUAARUAuQ==

...

false

CONDITIONAL

TRUE

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|cb7f68e3-1fb1-49e8-a683-5232cf6992ce