Claim Event
- Devan Robertson
Claim
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 | HasIdentifiedSuspect | BOOLEAN |
| ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Claim Details | PCDecisionFromIIDPreSubmission | VARCHAR(16) |
| ALWAYS | AutoPay, Review | Available in 24.01.03. |
Claim Details | PCDecisionReason | VARCHAR(255) |
| CONDITIONAL |
| Available in 24.01.03. |
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 |
|
Claim Details | WasPCManuallyWithheld | BOOLEAN |
| ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Compliance Details | RegE10DateTime | TIMESTAMP_NTZ(9) | CONDITIONAL | 2023-09-09 21:00:00 |
| |
Compliance Details | PCDocRequirementSatisifedDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
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 | RegZPCThresholdDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegZPCDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | IsFCRA | BOOLEAN | Indicates whether the FCRA Override was applied to the claim. | CONDITIONAL | FALSE |
|
Metadata | CreatedbyUserId | VARCHAR(64) | The username of the user that created the claim. | CONDITIONAL | devan.robertson@quavo.com | Available in 24.01.03. |
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 | SubmittedDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Metadata | StatusChangedDateTime | TIMESTAMP_NTZ(9) |
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
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 |
|