Excel Add-In for Workday

Build 25.0.9434

PeopleHomeAddresses

Maintains residential address details for individuals, facilitating accurate communication and legal documentation.

Workday Resource Information

Retrieves a home address for the person with the specified ID.

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

Scope: Contact Information

Columns

Name Type Description
Id [KEY] String A unique identifier for this address entry within the system.
People_Id [KEY] String The unique Workday ID (WID) associated with the person who owns this address.
AddressLine1 String The primary street address line for the person's home address, typically includes house number and street name.
AddressLine1Local String The primary street address line in the local language or format of the address location.
AddressLine2 String An additional street address line used for apartment, suite, or other secondary address information.
AddressLine2Local String An additional street address line formatted for local language or address conventions.
AddressLine3 String A third line for extended address details, such as building name or internal mail routing.
AddressLine3Local String A third address line formatted according to local address conventions.
AddressLine4 String A fourth address line for further address specifications, if necessary.
AddressLine4Local String A fourth address line adapted to local address formatting and language preferences.
AddressLine5 String An optional fifth line for extended address details beyond standard fields.
AddressLine5Local String An optional fifth address line formatted for local language or address standards.
AddressLine6 String An optional sixth line to capture additional address-related details.
AddressLine6Local String A localized version of the sixth address line, adhering to regional formatting.
AddressLine7 String An optional seventh address line for further refinement of location details.
AddressLine7Local String A localized version of the seventh address line, following regional conventions.
AddressLine8 String An optional eighth address line to accommodate highly detailed address structures.
AddressLine8Local String A localized version of the eighth address line, formatted for regional usage.
AddressLine9 String An optional ninth address line for additional address information beyond standard fields.
AddressLine9Local String A localized version of the ninth address line for region-specific formatting.
City String The name of the city where the person's home address is located.
CityLocal String The city name in the local language or formatted according to regional address conventions.
CitySubdivision1 String The first subdivision of the city, such as a district or neighborhood, providing more granular location details.
CitySubdivision1Local String The first city subdivision formatted in the local language or regional conventions.
CitySubdivision2 String The second subdivision of the city, typically a smaller unit such as a ward or precinct.
CitySubdivision2Local String The second city subdivision formatted in the local language or according to regional address standards.
CountryCity_Descriptor String A textual representation of the country and city associated with the address, providing an overview of the location.
CountryCity_Id String A unique identifier for the country-city combination used within Workday.
CountryRegion_Descriptor String A description of the country and region where the address is located, offering additional geographic context.
CountryRegion_Id String A unique identifier for the country-region combination within Workday.
Country_Descriptor String A descriptive name of the country where the address is located.
Country_Id String A unique WID associated with the country of the address.
Effective Datetime The date when the address becomes valid or officially takes effect.
FullFormattedAddress String A fully formatted version of the home address, including all relevant address fields in a standardized format.
FullFormattedLocalAddress String A fully formatted version of the home address adapted to the local language and address conventions.
PostalCode String The postal code or ZIP code associated with the address, used for mail delivery and location identification.
RegionSubdivision1 String The first level of regional subdivision, such as a state, province, or territory.
RegionSubdivision1Local String The first regional subdivision formatted in the local language or according to regional standards.
RegionSubdivision2 String The second level of regional subdivision, such as a county, municipality, or district.
Usage_Primary Bool Indicates whether this address is designated as the primary residence for the person. A value of 'true' means this is the primary home address.
Usage_Public Bool Indicates whether this address is publicly accessible. If this value is 'false' or missing, the address is private and not shared publicly.
Usage_UsageType_Descriptor String A description of how this address is used, such as mailing, billing, or shipping purposes.
Usage_UsageType_Id String A unique WID for the usage type associated with the address.
Effective_Prompt Date Specifies the effective date for retrieving the person’s addresses. The date must be in the format YYYY-MM-DD.
PrimaryOnly_Prompt Bool If this value is 'true,' only the primary home address for the person is returned.
PublicOnly_Prompt Bool If this value is 'true,' only publicly accessible addresses for the person are returned.
UsedFor_Prompt String Defines the purpose of the address, such as mailing, billing, or shipping, to filter the retrieved addresses.
Universal_ID_Prompt String The universal identifier of the person whose address information is being retrieved.

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