Skip to end of banner
Go to start of banner

Reg Protection Action 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 Next »

Name

RegProgectionView

Type

View

Description

Includes all records found in the Reg Protection Table with additional fields that are handy when analyzing regulatory protection actions.

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

Claim Details

ClaimReason

VARCHAR

Identifies the specific reason associated with the claim.

CONDITIONAL

Stolen

Claim Details

ClaimStatus

VARCHAR(64)

Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute.

ALWAYS

RESOLVED-PAID

Claim Details

ContactDate

DATE

Represents the date that the claim was received from the accountholder.

CONDITIONAL

2023-09-09

Key

ClaimId

VARCHAR(32)

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

Example: 2405230003C

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

ALWAYS

2306060014D

Dispute Details

DisputeAmount

NUMBER

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

ALWAYS

123.45

Action Details

Regulation

VARCHAR

The applicable rule or regulation that the protection action was applied to maintain compliance with.

ALWAYS

'Reg E Provisional Credit', 'Reg E Resolution', 'Reg Z Acknowledgement', 'Reg Z Withholding', 'Reg Z Resolution'

Action Details

Performed On

TIMESTAMP_NTZ(9)

Datetime that the regulatory protection action was applied to the dispute.

ALWAYS

2023-09-09 21:00:00

Dispute Details

PCDocRequirementSatisfiedDate

TIMESTAMP_NTZ(9)

Datetime that any applicable provisional credit document requirement was satisfied.

CONDITIONAL

2023-09-09 21:00:00

Dispute Details

RegE10Outcome

VARCHAR(64)

Defines the protective action taken by the system when the Reg E PC timeframe expired. 

CONDITIONAL

DenyProvisionalCredit

Dispute Details

PCDenyReason

VARCHAR(64)

The reason provided for denying provisional credit.

CONDITIONAL

Missing Documentation

  • No labels