Stores pending changes to web addresses within employee contact details, supporting profile updates and digital presence tracking.

Table Specific Information

Select

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

For example:

SELECT * FROM HomeContactInformationChangesWebAddresses WHERE HomeContactInformationChange_Id = '12345';

Workday Resource Information

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

Secured by: Person Data: Home Web Address, Self-Service: Home Web Address

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 of the web address instance.
HomeContactInformationChange_Id [KEY]	String	False	Identifier of the home contact information change process. Must be provided in all queries.
Url	String	False	The full URL for the web address, including protocol (for example, https://).
Usage_Comment	String	False	A brief note describing the purpose or context of the communication method.
Usage_Primary	Bool	False	True if this communication method is designated as primary for the person.
Usage_Public	Bool	False	True if this communication method is visible to the public. If false or no results are returned, the method is private.
Usage_UsageType_Id	String	False	Unique identifier for the usage type, specifying the context in which the communication method is used.
Usage_UsedFor_Aggregate	String	False	List of usage behaviors for the communication method, including mailing, billing, shipping, etc. Each value is separated by a comma and a space.
PrimaryOnly_Prompt	Bool	False	If true, returns only the identifiers of the person's primary web addresses.
PublicOnly_Prompt	Bool	False	If true, returns only the identifiers of the person's public web addresses.
UsageType_Prompt	String	False	Specifies the type of usage, 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, such as mailing, billing, or shipping.