Retrieves all email address changes staged for update as part of a Workday business process.

Table Specific Information

Select

The Workday server requires filtering on WorkContactInformationChange_Id in order to perform the query.

For example:

SELECT * FROM WorkContactInformationChangesEmailAddresses WHERE WorkContactInformationChange_Id = '1234';

Workday Resource Information

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

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

Scope: Contact Information

Aggregate Fields

The server 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 /* A preview of the instance */
  id: Text /* Id of the instance */
}]

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique Workday ID of the instance.
WorkContactInformationChange_Id [KEY]	String	False	The Workday ID of the work contact information change process. Required for all queries.
Descriptor	String	False	A preview description of the email instance.
EmailAddress	String	False	The email address associated with the instance.
Usage_Comment	String	False	A description of how this communication method is used.
Usage_Primary	Bool	False	True if this is the primary email address for the person.
Usage_Public	Bool	False	True if the email address is publicly visible; otherwise, it is private.
Usage_UsageType_Id	String	False	The Workday ID of the usage type associated with this email address.
Usage_UsedFor_Aggregate	String	False	A list of usage behaviors for the email address, such as mailing, billing, or shipping.
PrimaryOnly_Prompt	Bool	False	Filters results to return only primary email addresses.
PublicOnly_Prompt	Bool	False	Filters results to return only public email addresses.
UsageType_Prompt	String	False	Filters results by usage type, such as home or work email.
UsedFor_Prompt	String	False	Filters results by usage behavior, such as mailing, billing, or shipping.