JDBC Driver for Workday

Build 25.0.9434

PeopleHomePhones

Maintains personal contact numbers for individuals, ensuring up-to-date records for emergency contacts and personal outreach.

Workday Resource Information

Retrieves a home phone number for the person with the specified ID.

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

Scope: Contact Information

Columns

Name Type Description
Id [KEY] String The unique identifier for this specific phone record instance within Workday.
People_Id [KEY] String The unique Workday ID (WID) for the person who owns this phone record.
CompletePhoneNumber String The full phone number, including country code, area code, and local number, formatted as a single string.
CountryPhoneCode_CountryPhoneCode String The numeric dialing code assigned to a country, used as a prefix for international dialing.
CountryPhoneCode_CountryPhoneCodeID String Reference id of the instance
CountryPhoneCode_Country_Descriptor String A human-readable label providing a preview or brief description of the associated country for the phone code.
CountryPhoneCode_Country_Id String The unique identifier representing the country associated with the phone code in Workday.
CountryPhoneCode_Descriptor String A user-friendly description of the country phone code, typically used for display purposes.
CountryPhoneCode_Id String A unique system-generated identifier assigned to the country phone code entry.
Descriptor String A general preview or description of the phone record, often used in UI elements or summary displays.
DeviceType_Descriptor String A brief label or description of the type of device associated with this phone number, such as Mobile, Work, or Home.
DeviceType_Id String A unique identifier for the type of device linked to this phone number.
Extension String An additional numeric extension assigned to a phone number, often used in office environments to route calls within an organization.
Usage_Primary Bool Indicates whether this phone number is designated as the primary contact number for the person. A value of 'true' means it is the primary number.
Usage_Public Bool Indicates whether this phone number is publicly visible. A value of 'true' means the number is publicly accessible, while 'false' means it is private.
Usage_UsageType_Descriptor String A user-friendly description of how this phone number is used, such as 'Work Contact' or 'Emergency Contact.'
Usage_UsageType_Id String A unique identifier for the specific usage type associated with this phone number.
PrimaryOnly_Prompt Bool If the value is 'true', only the primary phone numbers associated with a person will be returned in the query results.
PublicOnly_Prompt Bool If the value is 'true', only publicly accessible phone numbers associated with a person will be included in the query results.
UsedFor_Prompt String Defines the intended purpose of this phone number, such as for mailing, billing, or shipping notifications.
Universal_ID_Prompt String The globally unique Universal ID used to retrieve specific phone number records for a person within Workday.

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