Page Comparison

Excerptmultiexcerpt-macro

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.

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.

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_descriptionfalse	ALWAYS	qvo-stg
Key	ClientId	VARCHAR(64)	glossary_descriptionfalse	ALWAYS	Default
Key	ClaimId	VARCHAR(32)	glossary_descriptionfalse	ALWAYS	2306060014C
Key	ClaimType	VARCHAR(64)	glossary_descriptionfalse	CONDITIONAL	Card-Pinless	Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details	CustomerId	VARCHAR(64)	glossary_descriptionfalse	CONDITIONAL	123456	Only applicable for submitted claims (not abandoned, cancelled, or withdrawn prior to submission).
Account Details	IsEmployeeClaim	BOOLEAN		CONDITIONALfalse	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_descriptionfalse	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-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false	CONDITIONAL	2023-09-09	Available in 24.01.03.Only applicable for submitted claims where a value is provided by the System of Record.
Account Details	AccountType	VARCHAR(32)	8539b451-d921-460e-8dd1-53050f3060a7glossary_descriptioneJyLjgUAARUAuQ==false	CONDITIONAL	“Deposit”, “Credit Card”	Available in 24.01.03.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_descriptionfalse	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_descriptionfalse	CONDITIONAL	ATM, Account Merchandise Service, Authorization, Dispute, Fraud, Identity Theft, Incorrect, Missing, Revoked	Only applicable for submitted claims.
Claim Details	Reason	VARCHAR(64)	glossary_descriptionfalse	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_descriptionfalse	CONDITIONAL	123.45	Only applicable for submitted claims.
Claim Details	TotalClaimAmount	NUMBER(20,2)	glossary_descriptionfalse	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_descriptionfalse	CONDITIONAL	2023-09-09	Only applicable for submitted lost or stolen card claims.
Claim Details	IsPotentialAbuse	BOOLEAN	glossary_descriptionfalse	CONDITIONAL	FALSETRUE	Only applicable for submitted claims that mean one or more potential abuse criteria.
Claim Details	Status	VARCHAR(64)	glossary_descriptionfalse	ALWAYS	RESOLVED-PAID
Claim Details	ProvisionalCreditDateTime	TIMESTAMP_NTZ(9)	glossary_descriptionfalse	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_descriptionfalse	CONDITIONAL	Paid, Denied	Only applicable for resolved claims.
Claim Details	HasIdentifiedSuspect	BOOLEAN	db9d0b0b2e0a1c9f-3d4585c9-4a334e9d-96378342-e2c1a4e0c2dff7c0e2bc907cglossary_descriptioneJyLjgUAARUAuQ==false	ALWAYSCONDITIONAL	TRUE, FALSEAvailable in 24.01.03.	Only applicable for submitted claims.
Claim Details	PCDecisionFromIIDPreSubmission	VARCHAR(16)	db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse	ALWAYSCONDITIONAL	AutoPay, Review	Available in 24.01.03.Only applicable for submitted claims.
Claim Details	PCDecisionReason	VARCHAR(255)	db9d0b0b-3d45-4a33-9637-e2c1a4e0c2dfeJyLjgUAARUAuQ==glossary_descriptionfalse	CONDITIONALAvailable		in 24.01.03Only applicable for submitted claims.
Claim Details	ResolvedDateTime	TIMESTAMP_NTZ(9)	glossary_descriptionfalse	CONDITIONAL	2023-09-09 21:00:00	Only applicable for resolved claims.
Claim Details	InvestigationCompleteDateTime	TIMESTAMP_NTZ(9)	glossary_descriptionfalse	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_descriptionfalse	CONDITIONAL	1	Only applicable for reclassified claims.
Claim Details	RequiredDocumentCount	NUMBER(3,0)	glossary_descriptionfalse	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-efc782936b02glossary_descriptionfalse	ALWAYS	TRUE, FALSE	Available in 24.01.03.
Compliance Details	RegE10DateTime	TIMESTAMP_NTZ(9)glossary_descriptionfalse		CONDITIONAL	2023-09-09 21:00:00	Only applicable for submitted claims that are covered by Regulation E.
Compliance Details	PCDocRequirementSatisifedDateTime	TIMESTAMP_NTZ(9)69e181af-8ebb-4e96-b6b2-96aebc3aa1e5glossary_descriptionfalse		CONDITIONAL	2023-09-09 21:00:00	Available in 24.01.03.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_descriptionfalse	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_descriptionfalse	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_descriptionfalse	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-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse	CONDITIONAL	2023-09-09 21:00:00	Available in 24.01.03Only 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-68628f59264feJyLjgUAARUAuQ==glossary_descriptionfalse	CONDITIONAL	2023-09-09 21:00:00	Available in 24.01.03.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	FALSE.	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	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.comAvailable in 24.01.03.	Only applicable for submitted claims.
Metadata	SaveDateTime	TIMESTAMP_NTZ(9)		ALWAYS	2023-09-09 21:00:00
Metadata	CreateDateTime	TIMESTAMP_NTZ(9)	glossary_descriptionfalse	ALWAYS	2023-09-09 21:00:00
Metadata	SubmittedDateTime	TIMESTAMP_NTZ(9)	863749f2-d1af-469c-a9ba-f14473f15b1fglossary_descriptionfalse	CONDITIONAL	2023-09-09 21:00:00	Available in 24.01.03.Only applicable for submitted claims.
Metadata	StatusChangedDateTime	TIMESTAMP_NTZ(9)	0029fa70-44a4-47ae-8b0d-98991ddce573glossary_descriptionfalse	CONDITIONAL	2023-09-09 21:00:00	Available in 24.01.03Only applicable for submitted claims.
Metadata	EventDateTime	TIMESTAMP_NTZ(9)	glossary_descriptionfalse	ALWAYS	2023-09-09 21:00:00
Metadata	EventIdentifier	VARCHAR(64)	glossary_descriptionfalse	ALWAYS	70b1c86d-d06f-4c93-bab2-0e938a4ef768
Metadata	EventItemId	VARCHAR(64)	glossary_descriptionfalse	ALWAYS	qvo-stg\|2306060014C

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

Page Comparison

Versions Compared

Key