EmailAddresses
Stores email address records that are linked to users, contacts, leads, and other entities. This table supports communication routing, contact identity resolution, and email activity tracking.
Columns
| Name | Type | ReadOnly | Description |
| Confirmation_Requested_On | Datetime | False |
The date and time when a confirmation request is issued for this email address. This field is used in double opt-in or consent validation workflows. |
| Date_Created | Datetime | False |
The date and time when the email address record was first created in the system. |
| Date_Modified | Datetime | True |
The date and time when the email address record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the email address record is marked for deletion. It returns a value of 'false' when the record remains active and available. |
| Email_Address | String | False |
The email address associated with this record in standard formatting. |
| Email_Address_Caps | String | False |
The email address stored in uppercase. This field is primarily used to support standardized comparisons and case-insensitive matching. |
| Id [KEY] | String | True |
The unique identifier (Id) for this email address record. |
| Invalid_Email | Bool | False |
A Boolean field that returns a value of 'true' when the email address is flagged as invalid due to bounce responses, format errors, or failed delivery attempts. It returns a value of 'false' when the email address is considered valid for communication. |
| Opt_Out | Bool | False |
A Boolean field that returns a value of 'true' when the email address has opted out of receiving marketing or bulk communications. It returns a value of 'false' when the email address remains eligible to receive these communications. |