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) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg |
|
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default |
|
Key | ClaimId | VARCHAR(32) |
Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C
| ALWAYS | 2306060014C |
|
Key | ClaimType | VARCHAR(64) | See Transaction Type. | CONDITIONAL | Card-Pinless |
|
Account Details | CustomerId | VARCHAR(64) | Value that uniquely identifies the customer associated with a claim. May be obfuscated when NPI is used. | CONDITIONAL | 123456 |
|
Account Details | IsEmployeeClaim | BOOLEAN |
| CONDITIONAL | false |
|
Account Details | AccountNumber | VARCHAR(64) | Value that uniquely identifies the account associated with a claim. May be obfuscated when NPI is used. | 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 | The date the account was opened as reported by the system of record. | CONDITIONAL | 2023-09-09 | Available in 24.01.03. |
Account Details | AccountType | VARCHAR(32) | The date the account was opened as reported by the system of record. | CONDITIONAL | “Deposit”, “Credit Card” | Available in 24.01.03. |
Card Details | CardType | VARCHAR(16) |
| CONDITIONAL | Debit |
|
Card Details | CardBIN | VARCHAR(8) | Bank Identification Number (BIN) is the first 4-8 digits of a payment card that identifies the issuing institution. | CONDITIONAL | 412356, 41235678 |
|
Card Details | CardNumberLast4 | VARCHAR(4) | Last 4 digits of the Card Number. | CONDITIONAL | 5555 |
|
Claim Details | ReasonType | VARCHAR(64) |
General categorization of the claim. For a more precise description, see Claim Reason.
| CONDITIONAL | Fraud |
|
Claim Details | Reason | VARCHAR(64) | Identifies the specific reason associated with the claim. | CONDITIONAL | Stolen |
|
Claim Details | ChannelOrigin | VARCHAR(32) |
| ALWAYS | Online Banking |
|
Claim Details | ClaimAmount | NUMBER(20,2) | The sum dispute amount of all posted disputes on a claim. | CONDITIONAL | 123.45 |
|
Claim Details | TotalClaimAmount | NUMBER(20,2) | The sum dispute amount of all pending and posted transactions included in a claim. | CONDITIONAL | 123.45 |
|
Claim Details | CustomerContactDate | DATE |
Page lookup error: page "Contact Date" not found. If you're experiencing issues please see our Troubleshooting Guide.
| CONDITIONAL | 2023-09-09 |
|
Claim Details | CustomerDiscoveryDate | DATE | The date provided during intake on a lost or stolen claim that represents the date the claimant discovered that the card had been lost or stolen. | CONDITIONAL | 2023-09-09 |
|
Claim Details | IsPotentialAbuse | BOOLEAN | A specified number of claims submitted by a single customer/member within an established timeframe. The output of this property is a boolean (TRUE/FALSE). | CONDITIONAL | FALSE |
|
Claim Details | Status | VARCHAR(64) | Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. | ALWAYS | RESOLVED-PAID |
|
Claim Details | ProvisionalCreditDateTime | TIMESTAMP_NTZ(9) | Datetime when provisional credit was granted on a claim. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Claim Details | PCDecision | VARCHAR(16) |
| CONDITIONAL | Grant |
|
Claim Details | Decision | VARCHAR(64) | "Paid" or "Denied". If one, or more, disputes on a claim are paid, the claim decision is "Paid". | CONDITIONAL | Paid, Denied |
|
Claim Details | HasIdentifiedSuspect | BOOLEAN | Datetime that a claim or dispute is set to a "Resolved" status.. Also referred to as RESOLVEDDATETIME. | ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Claim Details | PCDecisionFromIIDPreSubmission | VARCHAR(16) | Provisional credit decision set by the system during intake. | ALWAYS | AutoPay, Review | Available in 24.01.03. |
Claim Details | PCDecisionReason | VARCHAR(255) | Description of reason for the PC decision set by the system. | CONDITIONAL |
| Available in 24.01.03. |
Claim Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | Datetime that a claim or dispute is set to a "Resolved" status.. Also referred to as RESOLVEDDATETIME. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | Date and/or datetime that a Pay or Deny decision is rendered for all disputes on a claim. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Claim Details | ReclassificationCount | NUMBER(3,0) | Number of times the claims has been reclassified. | CONDITIONAL | 1 |
|
Claim Details | RequiredDocumentCount | NUMBER(3,0) |
| CONDITIONAL | 1 |
|
Claim Details | TimeZone | VARCHAR(48) |
| ALWAYS | America/Los_Angeles |
|
Claim Details | WasPCManuallyWithheld | BOOLEAN | Number of times the claims has been reclassified. | ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Compliance Details | RegE10DateTime | TIMESTAMP_NTZ(9) | Datetime assigned by the system by which a claim must be granted provisional credit in order to maintain compliance with Regulation E. | CONDITIONAL | 2023-09-09 21:00:00 |
|
Compliance Details | PCDocRequirementSatisifedDateTime | TIMESTAMP_NTZ(9) | Datetime assigned by the system by which a claim must be granted provisional credit in order to maintain compliance with Regulation E. | 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) | Datetime assigned by the system by which a claim must be resolved in order to be compliant with Regulation E. | 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) | Datetime assigned by the system by which claim acknowledgement must be completed in order to be compliant with Regulation Z. | 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) | Datetime assigned by the system by which a claim must be resolved in order to be compliant with Regulation Z. | 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) | Datetime calculated by the system that represents the deadline for granting provisional credit or placing a dispute in dispute status in order to comply with in order to comply with § 1026.13(d)(1). | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegZPCDateTime | TIMESTAMP_NTZ(9) | Datetime calculated by the system, including any client-configured buffers, that represents the deadline for granting provisional credit or placing a dispute in dispute status in order to comply with in order to comply with § 1026.13(d)(1). | 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 |
|
Deflection Details | ISANYTRANSACTIONDEFLECTEDFROMMERCHANTCREDIT | BOOLEAN | TRUE when 1 or more disputes are resolved-no action, due to merchant credit. | CONDITIONAL | TRUE | Only available with Deflection booster. |
Deflection Details | ISANYTRANSACTIONDEFLECTEDFROMPURCHASEINQUIRY | BOOLEAN | TRUE when 1 or more disputes are resolved-no action, due to purchase inquiry details. | CONDITIONAL | TRUE | Only available with Deflection booster. |
Deflection Details | ISANYTRANSACTIONDEFLECTEDFROMUNDISPUTEDHISTORY | BOOLEAN | TRUE when 1 or more disputes are resolved-no action, due to undisputed history. | CONDITIONAL | TRUE | Only available with Deflection booster. |
Metadata | CreatedbyUserId | VARCHAR(64) | The username of the user that created the claim. | CONDITIONAL | Available in 24.01.03. | |
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) |
| ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | SubmittedDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Metadata | StatusChangedDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | The datetime that the event was recorded. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventIdentifier | VARCHAR(64) | A unique ID associated with each business event. | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 |
|
Metadata | EventItemId | VARCHAR(64) | An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. | ALWAYS | qvo-stg|2306060014C |
|