Skip to end of banner
Go to start of banner

Work View

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Name

Work_All

Type

View

Description

A list of all outstanding user assignments along with relevant claim and dispute attributes used to determine priority order.

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR

Unique ID associated with each Quavo client.

ALWAYS

qvo-stg

Key

Tenant

VARCHAR

A tenant is a Quavo customer that uses QFD.  Each tenant is assigned a unique Tenant ID.

ALWAYS

Default

Key

ClientId

VARCHAR

A unique ID representing a single client.

ALWAYS

Default

Key

Client

VARCHAR

A client is a Quavo customer that uses QFD through a relationship with a Quavo tenant.  Each client is assigned a unique Client ID.

ALWAYS

Default

Claim Details

ClaimType

VARCHAR

See Transaction Type.

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR

General categorization of the claim.

For a more precise description, see Claim Reason.

CONDITIONAL

Fraud

Compliance Details

RegulatoryCoverage

VARCHAR

Identifies the specific reason associated with the claim.

CONDITIONAL

Reg E

Dispute Details

Network

VARCHAR

A network is a company that provides the communication system between a merchant and a card issuer in order to process transactions.  For more details, see Acquirer Networks.

CONDITIONAL

Visa

Key

ClaimId

VARCHAR

Unique ID associated with a claim.  Format: YYMMDD<Ordinal Number>"C"

Example: 2405230003C

ALWAYS

2306060014C

Key

DisputeId

VARCHAR

Unique ID associated with a disputed transaction.  Format: YYMMDD#####"D"

ALWAYS

2306060014D

Claim Details

TotalClaimAmount

NUMBER

The sum dispute amount of all pending and posted transactions included in a claim.

ALWAYS

123.45

Dispute Details

DisputeAmount

NUMBER

The current amount in dispute, accounting for any recoveries or adjustments.

ALWAYS

185.55

Assignment Details

Assignment

VARCHAR

Name of the assignment.

ALWAYS

Pending Documents

Assignment Details

Workgroup

VARCHAR

Assigned workgroup.

ALWAYS

Daily Critical

Assignment Details

CreatedDateTime

DATE

Datetime that the assignment was created.

ALWAYS

2023-09-09

Accounting Details

ProvisionalCreditDate

DATE

Datetime when provisional credit was granted on a claim.

CONDITIONAL

2023-09-09

Compliance Details

PCActionDays

NUMBER

Days until provisional credit is due.

CONDITIONAL

3

Recovery Details

NextRecoveryDateTime

Date

Date that the next issuer recovery action must be completed.

CONDITIONAL

2023-09-09

Recovery Details

RecoveryActionDays

Number

Days until the next issuer recovery action must be completed.

CONDITIONAL

3

Compliance Details

FinalRegDateTime

Date

Date that claim must be resolved based on applicable regulatory coverage.

CONDITIONAL

2023-09-09

Compliance Details

ResolutionActionDays

Number

Days until claim must be resolved based on applicable regulatory coverage.

CONDITIONAL

3

Assignment Details

AssignmentGroup

VARCHAR

General assignment grouping. Does not account for high dollar.

CONDITIONAL

2023-09-09

Assignment Details

NextAction

VARCHAR

Next required compliance or recovery action.

CONDITIONAL

Provisional Credit, Recovery Action, Resolution Action

Assignment Details

NextActionDate

Date

Date of next required compliance or recovery action.

CONDITIONAL

2023-09-09

Assignment Details

ActionDue

Number

Days until next required compliance or recovery action.

CONDITIONAL

3

Assignment Details

Age

NUMBER

Days between the assignment create date and today.

ALWAYS

12

  • No labels