WorkContactInformationChangesPhoneNumbers

Records phone number changes for a worker before they are officially updated in Workday.

Table Specific Information

Select

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

For example:

SELECT * FROM WorkContactInformationChangesPhoneNumbers WHERE WorkContactInformationChange_Id = '1234';

Workday Resource Information

Retrieve an existing phone number as it exists when staged by the parent business process.

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

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.
CompletePhoneNumber	String	False	The full phone number, including country code and extension if applicable.
CountryPhoneCode_CountryPhoneCode	String	False	The dialing code associated with a country.
CountryPhoneCode_Country_Descriptor	String	False	A preview description of the country associated with the phone code.
CountryPhoneCode_Country_Id	String	False	The Workday ID of the country associated with the phone code.
CountryPhoneCode_Descriptor	String	False	A preview description of the phone code.
CountryPhoneCode_Id	String	False	The Workday ID of the phone code.
Descriptor	String	False	A preview description of the phone number instance.
DeviceType_Descriptor	String	False	A preview description of the device type (for example, mobile, landline, fax).
DeviceType_Id	String	False	The Workday ID of the device type.
Extension	String	False	The extension number associated with the phone number.
Usage_Comment	String	False	A description of how this communication method is used.
Usage_Primary	Bool	False	True if this phone number is the primary contact method.
Usage_Public	Bool	False	True if this phone number is publicly visible; otherwise, it is private.
Usage_UsageType_Id	String	False	The Workday ID of the usage type associated with this phone number.
Usage_UsedFor_Aggregate	String	False	A list of usage behaviors for this phone number, such as mailing, billing, or shipping.
PrimaryOnly_Prompt	Bool	False	Filters results to return only primary phone numbers.
PublicOnly_Prompt	Bool	False	Filters results to return only public phone numbers.
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.