Fields
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 | Tenant | VARCHAR(64) | ALWAYS | Default | ||
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default | |
Key | Client | VARCHAR(64) | 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 | |
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 |