Excel Add-In for Workday

Build 25.0.9434

WorkContactInformationChangesInstantMessengers

Captures pending updates to a worker’s instant messaging details within the Workday system.

Table Specific Information

Select

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

For example:

SELECT * FROM WorkContactInformationChangesInstantMessengers WHERE WorkContactInformationChange_Id = '1234';

Workday Resource Information

Retrieve an existing instant messenger as it exists when staged by the parent business process.

Secured by: Person Data: Work Instant Messenger, Self-Service: Work Instant Messenger

Scope: Contact Information

Aggregate Fields

The add-in 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.

Type_Descriptor String False

A preview description of the instant messenger type.

Type_Id String False

The Workday ID of the instant messenger type.

Usage_Comment String False

A description of how this communication method is used.

Usage_Primary Bool False

True if this is the primary instant messenger account.

Usage_Public Bool False

True if the instant messenger account is publicly visible; otherwise, it is private.

Usage_UsageType_Id String False

The Workday ID of the usage type associated with this communication method.

Usage_UsedFor_Aggregate String False

A list of usage behaviors for this communication method, such as mailing, billing, or shipping.

UserName String False

The username associated with the instant messenger account.

PrimaryOnly_Prompt Bool False

Filters results to return only primary instant messenger accounts.

PublicOnly_Prompt Bool False

Filters results to return only public instant messenger accounts.

UsageType_Prompt String False

Filters results by usage type, such as home or work.

UsedFor_Prompt String False

Filters results by usage behavior, such as mailing, billing, or shipping.

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