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.
Data Category | Event Field/Column Name | Data Type | Description | Applicability | Sample Value | Notes |
|---|---|---|---|---|---|---|
Key | TenantId | VARCHAR(32) | Unique ID associated with each Quavo client. | ALWAYS | qvo-stg |
|
Key | ClientId | VARCHAR(64) | A unique ID representing a single client. | ALWAYS | Default |
|
Key | ClaimId | VARCHAR(32) |
Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C
| ALWAYS | 2306060014C |
|
Key | DISPUTEID | VARCHAR(32) | Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" | CONDITIONAL | 2306050001D |
|
Key | CorrespondenceId | VARCHAR(64) | Unique ID associated with a correspondence record. | ALWAYS | 729e23a5-67d5-48af-b1eb-88b40ff22912 |
|
Correspondence Details | Channel | VARCHAR(64) | Any correspondence generated by the system is communicated via a channel. Multiple channels are supported and are defined on the Correspondence page. | ALWAYS |
| |
Correspondence Details | InboundOutbound | VARCHAR(32) | Specifies whether a correspondence item was sent (outbound) or received (inbound). | ALWAYS | Outbound |
|
Correspondence Details | ExecutionMethod | VARCHAR(32) | Represents the process used to complete an accounting action, such as "Auto", "Manual", or "Tracking Only". | CONDITIONAL | AUTO |
|
Correspondence Details | LetterSource | VARCHAR(32) | Identifies how a letter was generated, via system workflow or by a user. | ALWAYS | Workflow |
|
Correspondence Details | LetterType | VARCHAR(32) |
All letters have a defined "Type" of one of the following values:
When a claim is auto-paid, the Confirmation letter type is "Paid". When a claim receives auto-PC, the Confirmation letter type is "Provisional Credit". The letter can still be identified as a confirmation letter via the Name field, which will still reflect "Confirmation".
| CONDITIONAL |
|
Coming in Version 24.01
|
Correspondence Details | IsColor | BOOLEAN | Indicates whether a letter is printed in color vs. grayscale. | CONDITIONAL | TRUE, FALSE |
|
Correspondence Details | IsDoubleSided | BOOLEAN | Indicates whether both sides of a page are printed on. | CONDITIONAL | TRUE, FALSE |
|
Correspondence Details | IsResend | BOOLEAN | A boolean value that specifies whether a correspondence item was a resend of a previous correspondence item. | CONDITIONAL | TRUE, FALSE |
|
Correspondence Details | IsReturnMailRequested | BOOLEAN | Indicates if and outbound correspondence item includes a request for return mail. Only applies when using a print vendor that requires/requests this detail. | CONDITIONAL | TRUE, FALSE |
|
Correspondence Details | PageCount | NUMBER(38,0) | Number of pages generated for a print correspondence item. |
|
|
|
Correspondence Details | Purpose | VARCHAR(128) | Identifies the reason a letter was sent. Typically coincides with the name of the letter. | ALWAYS | Provisional Credit |
|
Correspondence Details | RuntimeMemo | VARCHAR(2048) | A property associated with a correspondence item that includes any specific deny justifications selected by the user. | CONDITIONAL | Proof of Authorization |
|
Correspondence Details | MailedDateTime | TIMESTAMP_NTZ(9) | Datetime that a correspondence item status is set to "mailed". | CONDITIONAL | 2023-09-09 21:00:00 |
|
Correspondence Details | RunTimeVendor | VARCHAR(32) | Print service provider used to transmit paper correspondence. | CONDITIONAL | Lob |
|
Correspondence Details | TransmissionStatus | VARCHAR(64) | The status of transmission of a correspondence item. Examples may include "Mailed", "Out for Delivery", and "Delivered". | ALWAYS | In Transit |
|
Correspondence Details | TransmissionStatusDateTime | TIMESTAMP_NTZ(9) | Datetime that the Transmission Status of a correspondence item as last updated. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | The datetime that a record was created. | 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) | The datetime that the event was recorded. | ALWAYS | 2023-09-09 21:00:00 |
|
Metadata | EventIdentifier | VARCHAR(64) | A unique ID associated with each business event. | ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 |
|
Metadata | EventItemId | VARCHAR(64) | An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. | ALWAYS | qvo-stg|729e23a5-67d5-48af-b1eb-88b40ff22912 |
|