Reg Z View
- Devan Robertson
Name | RegZDetails |
|---|---|
Type | View |
Description | Provides all fields that are applicable when evaluating compliance with Regulation Z rules. Only includes disputes that are covered by Reg Z. |
Â
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHARVisa | ALWAYS | qvo-stg | Â | |
Key | Tenant | VARCHAR |
| ALWAYS | Default | Â |
Key | ClientId | VARCHAR | ALWAYS | Default | Â | |
Key | Client | VARCHAR |
| ALWAYS | Default | Â |
Claim Details | ClaimType | VARCHAR | CONDITIONAL | Card-Pinless | Â | |
Claim Details | ClaimCategory | VARCHAR | CONDITIONAL | Fraud | Â | |
Claim Details | ClaimReason | VARCHAR | CONDITIONAL | Stolen | Â | |
Card Details | BIN | VARCHAR | CONDITIONAL | 412356, 41235678 | Â | |
Transaction Details | TransactionType | VARCHAR | ALWAYS | ATM | Â | |
Transaction Details | Network | VARCHAR |
| CONDITIONAL | Mastercard, Visa | Â |
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C | Â | |
Key | DisputeId | VARCHAR(32) | Â | ALWAYS | 2306060014D | Â |
Claim Details | ClaimStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID | Â | |
Dispute Details | DisputeStatus | VARCHAR(64) | ALWAYS | RESOLVED-PAID | Â | |
Dispute Details | Decision | VARCHAR(64) | CONDITIONAL | Paid, Denied | Â | |
Dispute Details | DenyReason | VARCHAR | CONDITIONAL | No Error | Â | |
Dispute Details | ReassertionIndicator | BOOLEAN | Indicates if the dispute has been reopened. | CONDITIONAL | TRUE | Â |
Account Details | NextPaymentDate | DATE | CONDITIONAL | 2023-09-09 | Only applicable when provided by the System of Record. | |
Account Details | AutopayEnrollmentIndicator | BOOLEAN | CONDITIONAL | TRUE | Only applicable when provided by the System of Record. | |
Account Details | StatementCycleDate | DATE | CONDITIONAL | 2023-09-09 | Only applicable when provided by the System of Record. | |
Dispute Details | CreateDate | DATE | CONDITIONAL | 2023-09-09 | Â | |
Claim Details | ContactDate | DATE | CONDITIONAL | 2023-09-09 | Â | |
Compliance Details | InvestigationDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Compliance Details | AcknowledgementDeadline | DATE | Calculated date that an acknowledgement letter must be mailed by. | ALWAYS | 2023-09-09 | Â |
Correspondence Details | AcknowledgementLetterDate | TIMESTAMP_NTZ(9) | Datetime that the acknowledgement (confirmation) letter was mailed. | CONDITIONAL | 2023-09-09 21:00:00 | Â |
Compliance Details | WitholdingDeadline | DATE | Calculated date that a provisional credit or dispute status must be applied to a dispute in order to prevent a billing attempt by debiting a disputed amount via automatic payment. | CONDITIONAL | 2023-09-09 | Â |
Accounting Details | PCDate | TIMESTAMP_NTZ(9) | Datetime that a provisional credit accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 | Â |
Correspondence Details | PCLetterDate | TIMESTAMP_NTZ(9) | Datetime that notification of provisional credit was mailed. | CONDITIONAL | 2023-09-09 21:00:00 | Â |
Dispute Details | DisputeStatusDate | TIMESTAMP_NTZ(9) | Datetime that a dispute was placed in dispute status via Account Maintenance. | CONDITIONAL | 2023-09-09 21:00:00 | Â |
Compliance Details | ResolutionDeadline | DATE | CONDITIONAL | 2023-09-09 | Â | |
Dispute Details | ResolutionDate | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | Â | |
Accounting Details | FinalCreditDate | TIMESTAMP_NTZ(9) | Datetime that a final credit was executed via one of the following accounting entries: ‘Final Credit’, ‘Undue Enrichment Recovery (AccountHolder)’, ‘Write Off’. | CONDITIONAL | 2023-09-09 21:00:00 |  |
Correspondence Details | ResolutionLetterDate | TIMESTAMP_NTZ(9) | Datetime that a Paid or Denied letter was mailed. | CONDITIONAL | 2023-09-09 21:00:00 | Â |
Accounting Details | DenyDebitDate | TIMESTAMP_NTZ(9) | Datetime that a credit reversal was executed via one of the following accounting entries: ‘Deny Dispute', ‘Final Credit Reversal’. | CONDITIONAL | 2023-09-09 21:00:00 |  |