ODBC Driver for Workday

Build 25.0.9434

HomeContactInformationChangesWebAddresses

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

Table Specific Information

Select

The Workday driver 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 driver 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

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434