WorkContactInformationChangesInstantMessengers
Captures pending updates to a worker’s instant messaging details within the Workday system.
Table Specific Information
Select
The Workday provider 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 provider 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. |