Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties

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

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptTenant ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

qvo-stg

Key

Tenant

VARCHAR

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTenant
addpanelfalse

ALWAYS

Default

Key

ClientId

VARCHAR

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

Client

VARCHAR

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageClient
addpanelfalse

ALWAYS

Default

Claim Details

ClaimType

VARCHAR

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

ClaimReason

VARCHAR

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Stolen

Claim Details

ClaimStatus

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptStatus Work
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

RESOLVED-PAID

Claim Details

ContactDate

DATE

Multiexcerpt include
macro_uuidd99ef6b8-ca27-4139-8c27-79c2824a1215
templateDataeJyLjgUAARUAuQ==
MultiExcerptNameglossary_description
addpanelfalse
PageWithExcerptCustomer Contact Date

CONDITIONAL

2023-09-09

Key

ClaimId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

2306060014C

Key

DisputeId

VARCHAR(32)

ALWAYS

2306060014D

Dispute Details

DisputeAmount

NUMBER

Multiexcerpt include macro
macro_uuidcf118209-282b-4c0b-936a-3481818e5929
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageDispute Amount
addpanelfalse

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)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPC Doc Requirements Satisfied DateTime
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

2023-09-09 21:00:00

Dispute Details

RegE10Outcome

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptReg E 10 Processing Outcome
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

DenyProvisionalCredit

Dispute Details

PCDenyReason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptPC Deny Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Missing Documentation