HomeContactInformationChangesPhoneNumbers

Logs updates to employee phone numbers within the home contact details, ensuring current contact records are maintained.

Table Specific Information

Select

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

For example:

SELECT * FROM HomeContactInformationChangesPhoneNumbers WHERE HomeContactInformationChange_Id = '12345';

Workday Resource Information

Retrieve all phone numbers staged for update by the parent business process

Secured by: Person Data: Home Phone, Self-Service: Home Phone

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 phone number entry within the change process.
HomeContactInformationChange_Id [KEY]	String	False	Identifier for the home contact information change process, required in all queries to link the phone number to the process.
CompletePhoneNumber	String	False	Full phone number including country code, area code, and local number.
CountryPhoneCode_CountryPhoneCode	String	False	International dialing code assigned to a specific country, such as +1 for the United States.
CountryPhoneCode_Country_Descriptor	String	False	The display name of the instance
CountryPhoneCode_Country_Id	String	False	Unique identifier for the country associated with the phone code.
CountryPhoneCode_Descriptor	String	False	The display name of the instance
CountryPhoneCode_Id	String	False	Unique identifier for the country phone code instance.
Descriptor	String	False	The display name of the instance
DeviceType_Descriptor	String	False	The display name of the instance
DeviceType_Id	String	False	Unique identifier for the phone device type.
Extension	String	False	Telephone extension used for internal dialing within an organization.
Usage_Comment	String	False	Additional information or notes related to the phone number’s communication usage.
Usage_Primary	Bool	False	True if the phone number is designated as the primary contact method for the person.
Usage_Public	Bool	False	True if the phone number is publicly available. If false or not returned, the phone number is private.
Usage_UsageType_Id	String	False	Unique identifier for the communication usage type, such as home, work, or mobile.
Usage_UsedFor_Aggregate	String	False	List of communication purposes associated with the phone number, such as mailing, billing, shipping, etc. Values are comma-separated with a space after each comma.
PrimaryOnly_Prompt	Bool	False	If true, limits results to only the primary phone numbers associated with the person.
PublicOnly_Prompt	Bool	False	If true, limits results to only phone numbers designated as public.
UsageType_Prompt	String	False	Specifies the usage type of the phone number, such as home, work, or mobile. Only used if the service allows multiple usage types from the same endpoint.
UsedFor_Prompt	String	False	Defines the communication behavior of the phone number, such as mailing, billing, or shipping. Values should be comma-separated with a space after each comma.