Versions Compared

Key

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

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-d32dcfda4015glossary_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-59f2151179feglossary_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

Will be populated once accounting entry has been executed.

Accounting Details

...

EXECUTEDON

TIMESTAMP_NTZ(9)

...

glossary_description

...

false

CONDITIONAL

2023-08-16 17:48:47.709

Will be populated once accounting entry has been executed.

Accounting Details

ExecutionMethod

VARCHAR(32)

...

glossary_description

...

false

...

CONDITIONAL

AUTO, BATCH, MANUAL, TrackingOnly

Will be populated once accounting entry has been executed.

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

...

Applicability depends on accounting plan configuration.

Accounting Details

IsManualEntry

BOOLEAN

c683dd99-4952-42c9-8008-b9e76d7184e1glossary_descriptioneJyLjgUAARUAuQ==false

CONDITIONAL

TRUE

Applicable when the accounting entry is entered by a user instead of generated by the system.

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