Deny Debit View
- Devan Robertson
Name | DenyDebit |
|---|---|
Type | View |
Description | Provides a detailed view of all dispute credit reversals and measures compliance with Reg E rule - “Upon debiting a provisionally credited amount, the financial institution shall (...) Notify the consumer that the institution will honor ("Transactions") from the consumer's account (...) for five business days after the notification.” |
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | ALWAYS | qvo-stg |
| |
Key | Tenant | VARCHAR(64) |
| ALWAYS | Default |
|
Key | ClientId | VARCHAR(64) | ALWAYS | Default |
| |
Key | Client | VARCHAR(64) |
| ALWAYS | Default |
|
Key | ClaimId | VARCHAR(32) | ALWAYS | 2306060014C |
| |
Key | DisputeId | VARCHAR(32) | ALWAYS | 2306060014D |
| |
Claim Details | FinalDecision | VARCHAR(64) | CONDITIONAL | Paid, Denied |
| |
Dispute Details | DenyReason | VARCHAR(64) | CONDITIONAL | No Error |
| |
Claim Details | ContactDate | DATE | CONDITIONAL | 2023-09-09 |
| |
Compliance Details | FinalDecisionDate | TIMESTAMP_NTZ(9) | Datetime that a pay or deny decision is rendered for the dispute. | CONDITIONAL | 2023-09-09 21:00:00 | InvestigationDate |
Compliance Details | ResolutionDeadline | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 |
| |
Dispute Details | PaidLetter | TIMESTAMP_NTZ(9) | Datetime that the paid letter was created. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Dispute Details | DeniedLetter | TIMESTAMP_NTZ(9) | Datetime that the denied letter was created. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Dispute Details | PartialDenyDebit | TIMESTAMP_NTZ(9) | Datetime that a partial deny debit accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Dispute Details | DenyDebit | TIMESTAMP_NTZ(9) | Datetime that a deny debit accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Dispute Details | FinalCreditReversal | TIMESTAMP_NTZ(9) | Datetime that a final credit reversal accounting entry was executed. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Compliance Details | DenyDebitMinimum | TIMESTAMP_NTZ(9) | Final Decision Date or Denied Letter Date + 5 business days. | ALWAYS | 2023-09-09 21:00:00 |
|
Compliance Details | PartialDenyDebitCompliant | BOOLEAN | Indicates whether the partial deny debit was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE |
|
Compliance Details | DenyDebitCompliant | BOOLEAN | Indicates whether the deny debit was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE |
|
Compliance Details | FinalCreditReversalCompliant | BOOLEAN | Indicates whether the final credit reversal was in compliance with the 5 business day rule (if applicable). | CONDITIONAL | TRUE |
|
Dispute Details | PreviouslyPaid | BOOLEAN | Indicates whether a pay decision had been applied prior to the deny decision. | ALWAYS | FALSE |
|