Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
---|
Key | TenantId | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Tenant ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | qvo-stg | |
Key | ClientId | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Client ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | Default | |
Key | ClaimId | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Claim ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 2306060014C | |
Key | DisputeList[].DisputeId/DISPUTEID | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Dispute ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 2306050001D | |
Key | CorrespondenceId | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Letter ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 729e23a5-67d5-48af-b1eb-88b40ff22912 | |
Correspondence Details | Channel | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Channel |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | Mail | |
Correspondence Details | InboundOutbound | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | INBOUNDOUTBOUND |
---|
shouldDisplayInlineCommentsInIncludes | 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 | AUTO | |
Correspondence Details | LetterSource | VARCHAR(32) | Multiexcerpt include |
---|
macro_uuid | f46723ae-2eb3-42a8-b3b3-381b5aca5db6 |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Letter Source |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | Workflow | |
Correspondence Details | LetterType | VARCHAR(32) | Multiexcerpt include |
---|
macro_uuid | ea82507a-b5a9-43df-8084-d9bebbf0ccc8 |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Letter Type |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | | Info |
---|
Coming in Version 24.01 |
|
Correspondence Details | IsColor | BOOLEAN | Multiexcerpt include |
---|
macro_uuid | ea82507a-b5a9-43df-8084-d9bebbf0ccc8 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Color |
---|
|
| CONDITIONAL | TRUE, FALSE | |
Correspondence Details | IsDoubleSided | BOOLEAN | Multiexcerpt include |
---|
macro_uuid | ea82507a-b5a9-43df-8084-d9bebbf0ccc8 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Double Sided |
---|
|
| CONDITIONAL | TRUE, FALSE | |
Correspondence Details | IsResend | BOOLEAN | Multiexcerpt include |
---|
macro_uuid | 94989f89-c64b-4e4d-a449-a64341c26b10 |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Is Resend |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | TRUE, FALSE | |
Correspondence Details | IsReturnMailRequested | BOOLEAN | Multiexcerpt include |
---|
macro_uuid | 94989f89-c64b-4e4d-a449-a64341c26b10 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Return Mail Requested |
---|
|
| CONDITIONAL | TRUE, FALSE | |
Correspondence Details | PageCount | NUMBER(38,0) | Multiexcerpt include |
---|
macro_uuid | 94989f89-c64b-4e4d-a449-a64341c26b10 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Page Count |
---|
|
| | | |
Correspondence Details | Purpose | VARCHAR(128) | Multiexcerpt include |
---|
macro_uuid | 81b1706d-a006-4eb8-9ab7-cc2e8fbe41bf |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Purpose |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | Provisional Credit | |
Correspondence Details | RuntimeMemo | VARCHAR(2048) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Runtime Memo |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | Proof of Authorization | |
Correspondence Details | MailedDateTime | TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Mailed DateTime |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Correspondence Details | RunTimeVendor | VARCHAR(32) | Multiexcerpt include |
---|
macro_uuid | e1d16ba0-5fbc-4c31-8560-bf40c2330ff1 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerptaddpanel | Mailed DateTimefalse |
---|
shouldDisplayInlineCommentsInIncludesPageWithExcerpt | falsePrint Vendor |
---|
|
| CONDITIONAL | Lob | |
Correspondence Details | TransmissionStatus | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Transmission Status |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | In Transit | |
Correspondence Details | TransmissionStatusDateTime | TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Transmission Status Datetime |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | CREATEDATETIME |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) | | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | EVENTDATETIME |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventIdentifier | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | EVENTIDENTIFIER |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |
Metadata | EventItemId | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | EVENTITEMID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | qvo-stg|729e23a5-67d5-48af-b1eb-88b40ff22912 | |