JDBC Driver for Workday

Build 23.0.8839

PeopleWorkAddresses

Retrieves a work address.

Workday Resource Information

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

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

Scope: Contact Information

Columns

Name Type Description
Id [KEY] String Id of the instance
People_Id [KEY] String The Workday ID of the People that owns this
AddressLine1 String Supported for: SELECT. Address Line 1 for the address.
AddressLine1Local String Supported for: SELECT. Local Address Line 1 for the address.
AddressLine2 String Supported for: SELECT. Address Line 2 for the address.
AddressLine2Local String Supported for: SELECT. Local Address Line 2 for the address.
AddressLine3 String Supported for: SELECT. Address Line 3 for the address.
AddressLine3Local String Supported for: SELECT. Local Address Line 3 for the address.
AddressLine4 String Supported for: SELECT. Address Line 4 for the address.
AddressLine4Local String Supported for: SELECT. Local Address Line 4 for the address.
AddressLine5 String Supported for: SELECT. Address Line 5 for the address.
AddressLine5Local String Supported for: SELECT. Local Address Line 5 for the address.
AddressLine6 String Supported for: SELECT. Address Line 6 for the address.
AddressLine6Local String Supported for: SELECT. Local Address Line 6 for the address.
AddressLine7 String Supported for: SELECT. Address Line 7 for the address.
AddressLine7Local String Supported for: SELECT. Local Address Line 7 for the address.
AddressLine8 String Supported for: SELECT. Address Line 8 for the address.
AddressLine8Local String Supported for: SELECT. Local Address Line 8 for the address.
AddressLine9 String Supported for: SELECT. Address Line 9 for the address.
AddressLine9Local String Supported for: SELECT. Local Address Line 9 for the address.
City String Supported for: SELECT. City for the address.
CityLocal String Supported for: SELECT. City - Local for the address.
CitySubdivision1 String Supported for: SELECT. City Subdivision 1 for the address.
CitySubdivision1Local String Supported for: SELECT. City Subdivision 1 - Local for the address.
CitySubdivision2 String Supported for: SELECT. City Subdivision 2 for the address.
CitySubdivision2Local String Supported for: SELECT. City Subdivision 2 - Local for the address.
CountryCity_Descriptor String Supported for: SELECT. A preview of the instance
CountryCity_Id String Supported for: SELECT. Id of the instance
CountryRegion_Descriptor String Supported for: SELECT. A preview of the instance
CountryRegion_Id String Supported for: SELECT. Id of the instance
Country_Descriptor String Supported for: SELECT. A preview of the instance
Country_Id String Supported for: SELECT. Id of the instance
Effective Datetime Supported for: SELECT. The Effective Date for the address.
FullFormattedAddress String Supported for: SELECT. Full Formatted Address
FullFormattedLocalAddress String Supported for: SELECT. Full Formatted Local Address
PostalCode String Supported for: SELECT. The postal code for the address.
RegionSubdivision1 String Supported for: SELECT. Region Subdivision 1 for the address.
RegionSubdivision1Local String Supported for: SELECT. Region Subdivision 1 - Local for the address.
RegionSubdivision2 String Supported for: SELECT. Region Subdivision 2 for the address.
Usage_Primary Bool Supported for: SELECT. True if the communication method has any primary usage type.
Usage_Public Bool Supported for: SELECT. True if the communication method is public. If no results are returned, the communication method is private.
Usage_UsageType_Descriptor String Supported for: SELECT. A preview of the instance
Usage_UsageType_Id String Supported for: SELECT. Id of the instance
Effective_Prompt Date The effective date of the person's addresses using the yyyy-mm-dd format.
PrimaryOnly_Prompt Boolean If true, returns only the IDs of the person's primary addresses.
PublicOnly_Prompt Boolean If true, returns only the IDs of the person's public addresses.
UsedFor_Prompt String Specifies usage behavior, such as mailing, billing, or shipping.
Universal_ID_Prompt String Only used when a People_Id filter is not provided. The Universal ID of the person you want to retrieve.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839