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 | DISPUTEID | VARCHAR(32) | glossary_descriptionfalse | CONDITIONAL | 2306050001D | Only applicable for correspondence that is related to specific dispute(s). |
Key | CorrespondenceId | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | 729e23a5-67d5-48af-b1eb-88b40ff22912 | |
Correspondence Details | Channel | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | Mail | |
Correspondence Details | InboundOutbound | VARCHAR(32) | glossary_descriptionfalse | ALWAYS | Outbound | |
Correspondence Details | ExecutionMethod | VARCHAR(32) | 10c32108-41ea-471c-8f59-9ae31fcb710eglossary_descriptionfalseIndicates 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-381b5aca5db6glossary_descriptionfalse | ALWAYS | Workflow | |
Correspondence Details | LetterType | VARCHAR(32) | ea82507a-b5a9-43df-8084-d9bebbf0ccc8glossary_descriptionfalse | CONDITIONALComing | | in Version 24.01Only applicable where configured. |
Correspondence Details | IsColor | BOOLEAN | ea82507a-b5a9-43df-8084-d9bebbf0ccc8eJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | TRUE, FALSE | Only applicable when true. |
Correspondence Details | IsDoubleSided | BOOLEAN | ea82507a-b5a9-43df-8084-d9bebbf0ccc8eJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | TRUE, FALSE | Only applicable when true. |
Correspondence Details | IsResend | BOOLEAN | 94989f89-c64b-4e4d-a449-a64341c26b10glossary_descriptionfalse | CONDITIONAL | TRUE, FALSE | Only applicable when true. |
Correspondence Details | IsReturnMailRequested | BOOLEAN | 94989f89-c64b-4e4d-a449-a64341c26b10eJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | TRUE, FALSE | Only applicable when true. |
Correspondence Details | PageCount | NUMBER(38,0) | 94989f89-c64b-4e4d-a449-a64341c26b10eJyLjgUAARUAuQ==glossary_descriptionfalse | ALWAYS | 2 | |
Correspondence Details | Purpose | VARCHAR(128) | 81b1706d-a006-4eb8-9ab7-cc2e8fbe41bfglossary_descriptionfalse | ALWAYS | Provisional Credit | |
Correspondence Details | RuntimeMemo | VARCHAR(2048) | glossary_descriptionfalse | CONDITIONAL | Proof of Authorization | Only applicable when justifications are enabled and applied to a letter. |
Correspondence Details | MailedDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | CONDITIONAL | 2023-09-09 21:00:00 | Only applicable for correspondence that has been transmitted. |
Correspondence Details | RunTimeVendor | VARCHAR(32) | e1d16ba0-5fbc-4c31-8560-bf40c2330ff1eJyLjgUAARUAuQ==glossary_descriptionfalse | CONDITIONAL | Lob | Only applicable when configured. |
Correspondence Details | TransmissionStatus | VARCHAR(64) | glossary_descriptionfalse | ALWAYS | In Transit | |
Correspondence Details | TransmissionStatusDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | glossary_descriptionfalse | 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_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|729e23a5-67d5-48af-b1eb-88b40ff22912 | |
