HomeContactInformationChangesEmailAddresses

Maintains a record of email address changes in employee contact information, ensuring updated communication channels.

Table Specific Information

Select

The Workday connector requires filtering on HomeContactInformationChange_Id in order to perform the query.

For example:

SELECT * FROM HomeContactInformationChangesEmailAddresses WHERE HomeContactInformationChange_Id = '12345';

Workday Resource Information

Retrieve all email addresses staged for update by the parent business process

Secured by: Person Data: Home Email, Self-Service: Home Email

Scope: Contact Information

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

Usage_UsedFor_Aggregate

[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
}]

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	Unique identifier for the email address record within the system.
HomeContactInformationChange_Id [KEY]	String	False	Unique identifier of the home contact information change process. This value is required for all queries.
Descriptor	String	False	The display name of the instance
EmailAddress	String	False	The full email address associated with the contact information record.
Usage_Comment	String	False	A brief note explaining the context or purpose of the specified communication method.
Usage_Primary	Bool	False	Indicates whether this email address is designated as the primary contact method. True means it is the primary email.
Usage_Public	Bool	False	Indicates whether this email address is publicly accessible. True means the email address is public; if false or no result is returned, the address is private.
Usage_UsageType_Id	String	False	Unique identifier representing the type of usage for this email address, such as home or work.
Usage_UsedFor_Aggregate	String	False	Specifies the usage behaviors for the email address, including mailing, billing, shipping, etc. Values are comma-separated with a space after each comma.
PrimaryOnly_Prompt	Bool	False	When true, the query returns only the Ids of email addresses designated as primary.
PublicOnly_Prompt	Bool	False	When true, the query returns only the Ids of email addresses that are publicly accessible.
UsageType_Prompt	String	False	Specifies the usage type for filtering results, such as home or work. Only applicable if the service allows access to multiple usage types through the same endpoint.
UsedFor_Prompt	String	False	Specifies the intended usage behavior for filtering results, such as mailing, billing, or shipping. Values are comma-separated with a space after each comma.