| Page Properties | ||||||
|---|---|---|---|---|---|---|
|
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 |