Page Comparison

Claim

name

Excerpt

Multiexcerpt macro

hidden	false
name	Description
fallback	false

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.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.

Multiexcerpt macro

hidden	false
name	Fields
fallback	false

Data Category	Event Field/Column Name	Data Type	Description	Applicability	Sample Value	Notes
Key	TenantId	VARCHAR(32)

...

glossary_description

...

false	ALWAYS	qvo-stg
Key	ClientId	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	Default
Key	ClaimId	VARCHAR(32)

...

glossary_description

...

false	ALWAYS	2306060014C
Key	ClaimType	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	Card-Pinless	Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details	CustomerId	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	123456	Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details	IsEmployeeClaim	BOOLEAN		CONDITIONAL

...

	TRUE	Only applicable for submitted claims where a positive employee account identifier is provided by the System of Record.
Account Details	AccountNumber	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	0000123456	Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details	IsEnrolledInAutopay	BOOLEAN		CONDITIONAL	TRUE	Only applicable for submitted claims where a positive autopay enrollment identifier is provided by the System of Record.
Account Details	NextPaymentDate	DATE		CONDITIONAL	2023-09-09	Only applicable for submitted claims where a next payment date value is provided by the System of Record.
Account Details	StatementCycleDate	DATE		CONDITIONAL	2023-09-09	Only applicable for submitted credit card claims.
Account Details	AccountOpenDate	DATE

...

8539b451-d921-460e-8dd1-53050f3060a7

...

glossary_description

...

eJyLjgUAARUAuQ==

...

false

CONDITIONAL

2023-09-09

...

Only applicable for submitted claims where a value is provided by the System of Record.
Account Details	AccountType	VARCHAR(32)

...

8539b451-d921-460e-8dd1-53050f3060a7

...

glossary_description

...

eJyLjgUAARUAuQ==

...

false

CONDITIONAL

...

“Deposit”, “Credit Card”

Deposit, Credit Card, Other	Only applicable for submitted credit card claims.
Card Details	CardType	VARCHAR(16)	CONDITIONAL	Debit, Credit	Only applicable for submitted card claims where provided by the System of Record.
Card Details	CardBIN	VARCHAR(8)

...

glossary_description

...

false	CONDITIONAL	412356, 41235678	Only applicable for submitted card claims where provided by the System of Record.
Card Details	CardNumberLast4	VARCHAR(4)	Last 4 digits of the Card Number.	CONDITIONAL	5555	Only applicable for submitted card claims where provided by the System of Record.
Claim Details	ReasonType	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	ATM, Account Merchandise Service, Authorization, Dispute, Fraud, Identity Theft, Incorrect, Missing, Revoked	Only applicable for submitted claims.
Claim Details	Reason	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	ACH Merchandise or Service, ATM Deposit, ATM Withdrawal, ATM Deposit Not Posted, ATO, Addendum Dispute, AuthChargeback, Authorization, Balance Transfer, Cancelled Recurring, Cancelled/Returned Merchandise/Service, Card Lost, Card Not Received, Card Secure, Card Stolen, Cashback, Charged More Than Once, Charged Credited Incorrect, Check Merchandise or Service, Convenience Check, Counterfeit Merchandise, Credit Not Processed, Credit Posted as Debit, Damaged/Defective, Debit Posted as Credit, Debited Prior To Auth Date, Debited By Third Party, Draft Encoding Error, Duplicate Entry, Duplicate Processing, Fraud App, Improper, Improperly Processed Electronically, Improperly Reinitiated, Incorrect Amount, Incorrect Credit Amount, Late Presentment, Merchandise Service Issue, Merchant Charged Loss/Theft, Merchant Incorrect Account Number, Merchant Incorrect Currency, Merchant Invalid Data, Merchant No Show Charged, Merchant Violated Laws Or Regs, Misrepresentation, Missing Transaction, Not as Described, Not Received, Paid by Other Means, Quality, Revoked, Stale Dated, Transaction Merchandise or Service, Unauthorized, Wrong Amount, Zelle Merchandise or Service	Only applicable for submitted claims.
Claim Details	ChannelOrigin	VARCHAR(32)		ALWAYS	Back Office User, Contact Center, External Contact Center, Online Banking
Claim Details	ClaimAmount	NUMBER(20,2)

...

glossary_description

...

false	CONDITIONAL	123.45	Only applicable for submitted claims.
Claim Details	TotalClaimAmount	NUMBER(20,2)

...

glossary_description

...

false	CONDITIONAL	123.45	Only applicable for submitted claims.
Claim Details	CustomerContactDate	DATE

...

4ffc432b-81b9-4b3b-8a9a-0ed7f61d45b5glossary_descriptioneJyLjgUAARUAuQ==false	CONDITIONAL	2023-09-09	Only applicable for submitted claims.
Claim Details	CustomerDiscoveryDate	DATE

...

glossary_description

...

false	CONDITIONAL	2023-09-09	Only applicable for submitted lost or stolen card claims.
Claim Details	IsPotentialAbuse	BOOLEAN

...

glossary_description

...

false

CONDITIONAL

...

	TRUE	Only applicable for submitted claims that mean one or more potential abuse criteria.
Claim Details	Status	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	RESOLVED-PAID
Claim Details	ProvisionalCreditDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims where provisional credit has been granted.
Claim Details	PCDecision	VARCHAR(16)		CONDITIONAL	Grant	Only applicable for submitted claims.
Claim Details	Decision	VARCHAR(64)

...

glossary_description

...

false	CONDITIONAL	Paid, Denied	Only applicable for resolved claims.
Claim Details	HasIdentifiedSuspect	BOOLEAN

...

Multiexcerpt include

macro_uuid	db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df
MultiExcerptName	glossary_description
PageWithExcerpt	Resolution Date
shouldDisplayInlineCommentsInIncludes	false

...

ALWAYS

...

TRUE, FALSE

...

2e0a1c9f-85c9-4e9d-8342-f7c0e2bc907cglossary_descriptioneJyLjgUAARUAuQ==false	CONDITIONAL	TRUE	Only applicable for submitted claims.
Claim Details	PCDecisionFromIIDPreSubmission	VARCHAR(16)

...

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

AutoPay, Review

...

Only applicable for submitted claims.
Claim Details	PCDecisionReason	VARCHAR(255)

...

db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

...

	Only applicable for submitted claims.
Claim Details	ResolvedDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for resolved claims.
Claim Details	InvestigationCompleteDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims where a pay or deny decision has been rendered.
Claim Details	ReclassificationCount	NUMBER(3,0)

...

glossary_description

...

false	CONDITIONAL	1	Only applicable for reclassified claims.
Claim Details	RequiredDocumentCount	NUMBER(3,0)

...

glossary_description

...

false	CONDITIONAL	1	Only applicable for claims with required documents.
Claim Details	TimeZone	VARCHAR(48)		ALWAYS	America/Los_Angeles	Only applicable for submitted claims.
Claim Details	WasPCManuallyWithheld	BOOLEAN

...

110346a1-c1f8-45bd-bf93-efc782936b02

...

glossary_description

...

false

ALWAYS

TRUE, FALSE

...


Compliance Details	RegE10DateTime	TIMESTAMP_NTZ(9)

...

	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation E.
Compliance Details	PCDocRequirementSatisifedDateTime	TIMESTAMP_NTZ(9)

...

CONDITIONAL

2023-09-09 21:00:00

...

Only applicable for submitted claims that are covered by Regulation E and have established document requirements that are satisfied.
Compliance Details	RegE10ThresholdDateTime	TIMESTAMP_NTZ(9)	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation E.
Compliance Details	RegE45DateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that include US ATM transactions and are covered by Regulation E.
Compliance Details	RegE90DateTime	TIMESTAMP_NTZ(9)		CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation E and do not included US ATM transactions.
Compliance Details	RegEThresholdDateTime	TIMESTAMP_NTZ(9)		CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation E.
Compliance Details	RegZ30DateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation Z.
Compliance Details	RegZ30ThresholdDateTime	TIMESTAMP_NTZ(9)		CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation Z.
Compliance Details	RegZ90DateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation Z.
Compliance Details	RegZ90ThresholdDateTime	TIMESTAMP_NTZ(9)		CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation Z.
Compliance Details	RegZPCThresholdDateTime	TIMESTAMP_NTZ(9)

...

8205c579-7f38-4507-b8b9-68628f59264f

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

2023-09-09 21:00:00

...

Only applicable for submitted claims that are covered by Regulation Z and meet the criteria for withholding protection.
Compliance Details	RegZPCDateTime	TIMESTAMP_NTZ(9)

...

8205c579-7f38-4507-b8b9-68628f59264f

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

2023-09-09 21:00:00

...

Only applicable for submitted claims that are covered by Regulation Z and meet the criteria for withholding protection.
Compliance Details	IsFCRA	BOOLEAN	Indicates whether the FCRA Override was applied to the claim.	CONDITIONAL	TRUE
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

...

CONDITIONAL

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	devan.robertson@quavo.com

...

Only applicable for submitted claims.
Metadata	SaveDateTime	TIMESTAMP_NTZ(9)	ALWAYS	2023-09-09 21:00:00
Metadata	CreateDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	ALWAYS	2023-09-09 21:00:00
Metadata	SubmittedDateTime	TIMESTAMP_NTZ(9)

...

863749f2-d1af-469c-a9ba-f14473f15b1f

...

glossary_description

...

false

CONDITIONAL

2023-09-09 21:00:00

...

Only applicable for submitted claims.
Metadata	StatusChangedDateTime	TIMESTAMP_NTZ(9)

...

0029fa70-44a4-47ae-8b0d-98991ddce573

...

glossary_description

...

false

CONDITIONAL

2023-09-09 21:00:00

...

Only applicable for submitted claims.
Metadata	EventDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	ALWAYS	2023-09-09 21:00:00
Metadata	EventIdentifier	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	70b1c86d-d06f-4c93-bab2-0e938a4ef768
Metadata	EventItemId	VARCHAR(64)

...

glossary_description

...

false

ALWAYS

qvo-stg|2306060014C

Version	Old Version 7	New Version Current
Changes made by	Devan Robertson	Devan Robertson
Saved on	Sept 19, 2024	Nov 12, 2024

Page Comparison

Versions Compared

Key

Claim