Claim
| Excerpt | ||
|---|---|---|
| ||
Each time a change is saved to a claim-level property in QFD, an event is created. This event includes all important claim details and will be useful for referencing from most other events to understand the full picture of the claim. |
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) |
| ALWAYS | qvo-stg | |||||||||||||
Key | ClientId | VARCHAR(64) |
| ALWAYS | Default | |||||||||||||
Key | ClaimId | VARCHAR(32) |
| ALWAYS | 2306060014C | |||||||||||||
Key | ClaimType | VARCHAR(64) |
| CONDITIONAL | Card-Pinless | |||||||||||||
Account Details | CustomerId | VARCHAR(64) |
| CONDITIONAL | 123456 | |||||||||||||
Account Details | IsEmployeeClaim | BOOLEAN | CONDITIONAL | false | ||||||||||||||
Account Details | AccountNumber | VARCHAR(64) |
| CONDITIONAL | 0000123456 | |||||||||||||
Account Details | IsEnrolledInAutopay | BOOLEAN | CONDITIONAL | TRUE | ||||||||||||||
Account Details | NextPaymentDate | DATE | CONDITIONAL | 2023-09-09 | ||||||||||||||
Account Details | StatementCycleDate | DATE | CONDITIONAL | 2023-09-09 | ||||||||||||||
Account Details | AccountOpenDate | DATE |
| CONDITIONAL | 2023-09-09 | Available in 24.01.03. | ||||||||||||
Account Details | AccountType | VARCHAR(32) |
| CONDITIONAL | “Deposit”, “Credit Card” | Available in 24.01.03. | ||||||||||||
Card Details | CardType | VARCHAR(16) | CONDITIONAL | Debit | ||||||||||||||
Card Details | CardBIN | VARCHAR(8) |
| CONDITIONAL | 412356, 41235678 | |||||||||||||
Card Details | CardNumberLast4 | VARCHAR(4) | Last 4 digits of the Card Number. | CONDITIONAL | 5555 | |||||||||||||
Claim Details | ReasonType | VARCHAR(64) |
| CONDITIONAL | Fraud | |||||||||||||
Claim Details | Reason | VARCHAR(64) |
| CONDITIONAL | Stolen | |||||||||||||
Claim Details | ChannelOrigin | VARCHAR(32) | ALWAYS | Online Banking | ||||||||||||||
Claim Details | ClaimAmount | NUMBER(20,2) |
| CONDITIONAL | 123.45 | |||||||||||||
Claim Details | TotalClaimAmount | NUMBER(20,2) |
| CONDITIONAL | 123.45 | |||||||||||||
Claim Details | CustomerContactDate | DATE |
| CONDITIONAL | 2023-09-09 | |||||||||||||
Claim Details | CustomerDiscoveryDate | DATE |
| CONDITIONAL | 2023-09-09 | |||||||||||||
Claim Details | IsPotentialAbuse | BOOLEAN |
| CONDITIONAL | FALSE | |||||||||||||
Claim Details | Status | VARCHAR(64) |
| ALWAYS | RESOLVED-PAID | |||||||||||||
Claim Details | ProvisionalCreditDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Claim Details | PCDecision | VARCHAR(16) | CONDITIONAL | Grant | ||||||||||||||
Claim Details | Decision | VARCHAR(64) |
| CONDITIONAL | Paid, Denied | |||||||||||||
Claim Details | ResolvedDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Claim Details | ReclassificationCount | NUMBER(3,0) |
| CONDITIONAL | 1 | |||||||||||||
Claim Details | RequiredDocumentCount | NUMBER(3,0) |
| CONDITIONAL | 1 | |||||||||||||
Claim Details | TimeZone | VARCHAR(48) | ALWAYS | America/Los_Angeles | ||||||||||||||
Compliance Details | RegE10DateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Compliance Details | RegE10ThresholdDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||
Compliance Details | RegE45DateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Compliance Details | RegE90DateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||
Compliance Details | RegEThresholdDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||
Compliance Details | RegZ30DateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Compliance Details | RegZ30ThresholdDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||
Compliance Details | RegZ90DateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | |||||||||||||
Compliance Details | RegZ90ThresholdDateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 | ||||||||||||||
Compliance Details | IsFCRA | BOOLEAN | Indicates whether the FCRA Override was applied to the claim. | CONDITIONAL | FALSE | |||||||||||||
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) | ALWAYS | 2023-09-09 21:00:00 | ||||||||||||||
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) |
| ALWAYS | 2023-09-09 21:00:00 | |||||||||||||
Metadata | EventDateTime | TIMESTAMP_NTZ(9) |
| ALWAYS | 2023-09-09 21:00:00 | |||||||||||||
Metadata | EventIdentifier | VARCHAR(64) |
| ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |||||||||||||
Metadata | EventItemId | VARCHAR(64) |
| ALWAYS | qvo-stg|2306060014C |