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

When correspondence is generated, or the transmission status is updated, an event is generated. The event includes all important details of the correspondence. This information is useful for capturing time-to-send, understanding the costs related to customer contact, as well as measuring compliance to regulatory requirements.

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

...

DISPUTEID

VARCHAR(32)

...

glossary_description

...

false	CONDITIONAL	2306050001D	Only applicable for correspondence that is related to specific dispute(s).
Key	CorrespondenceId	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	729e23a5-67d5-48af-b1eb-88b40ff22912
Correspondence Details	Channel	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	Mail
Correspondence Details	InboundOutbound	VARCHAR(32)

...

glossary_description

...

false	ALWAYS	Outbound
Correspondence Details	ExecutionMethod	VARCHAR(32)

...

Multiexcerpt include

macro_uuid	10c32108-41ea-471c-8f59-9ae31fcb710e
MultiExcerptName	glossary_description
PageWithExcerpt	Execution Method
shouldDisplayInlineCommentsInIncludes	false

...

CONDITIONAL

Indicates how the correspondence was transmitted.	CONDITIONAL	AUTO, BATCH, MANUAL	Only applicable for correspondence that has been transmitted.
Correspondence Details	LetterSource	VARCHAR(32)

...

f46723ae-2eb3-42a8-b3b3-381b5aca5db6

...

glossary_description

...

false	ALWAYS	Workflow
Correspondence Details	LetterType	VARCHAR(32)

...

ea82507a-b5a9-43df-8084-d9bebbf0ccc8

...

glossary_description

...

false

CONDITIONAL

...

	Only applicable where configured.
Correspondence Details	IsColor	BOOLEAN

...

ea82507a-b5a9-43df-8084-d9bebbf0ccc8

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

TRUE

...

	Only applicable when true.
Correspondence Details	IsDoubleSided	BOOLEAN

...

ea82507a-b5a9-43df-8084-d9bebbf0ccc8

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

TRUE

...

	Only applicable when true.
Correspondence Details	IsResend	BOOLEAN

...

94989f89-c64b-4e4d-a449-a64341c26b10

...

glossary_description

...

false

CONDITIONAL

TRUE

...

	Only applicable when true.
Correspondence Details	IsReturnMailRequested	BOOLEAN

...

94989f89-c64b-4e4d-a449-a64341c26b10

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL

TRUE

...

	Only applicable when true.
Correspondence Details	PageCount	NUMBER(38,0)

...

94989f89-c64b-4e4d-a449-a64341c26b10

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

ALWAYS

...

2
Correspondence Details	Purpose	VARCHAR(128)

...

81b1706d-a006-4eb8-9ab7-cc2e8fbe41bf

...

glossary_description

...

false	ALWAYS	Provisional Credit
Correspondence Details	RuntimeMemo	VARCHAR(2048)

...

glossary_description

...

false	CONDITIONAL	Proof of Authorization	Only applicable when justifications are enabled and applied to a letter.
Correspondence Details	MailedDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

false	CONDITIONAL	2023-09-09 21:00:00	Only applicable for correspondence that has been transmitted.
Correspondence Details	RunTimeVendor	VARCHAR(32)

...

e1d16ba0-5fbc-4c31-8560-bf40c2330ff1

...

eJyLjgUAARUAuQ==

...

glossary_description

...

false

...

CONDITIONAL	Lob	Only applicable when configured.
Correspondence Details	TransmissionStatus	VARCHAR(64)

...

glossary_description

...

false	ALWAYS	In Transit
Correspondence Details	TransmissionStatusDateTime	TIMESTAMP_NTZ(9)

...

glossary_description

...

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

...

glossary_description

...

false	ALWAYS	2023-09-09 21:00:00
Metadata	SaveDateTime	TIMESTAMP_NTZ(9)	The datetime that a record was saved.	ALWAYS	2023-09-09 21:00:00
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|729e23a5-67d5-48af-b1eb-88b40ff22912

Versions Compared

Old Version 4

New Version Current

Key