JDBC Driver for Workday

Build 25.0.9434

PeopleWorkAddresses

Captures and retrieves work location details for employees, supporting accurate office assignments and logistical planning.

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 A unique identifier for this address record, used to distinguish it from other address entries.
People_Id [KEY] String The unique Workday ID (WID) for the person associated with this address. This links the address to an individual in the system.
AddressLine1 String The primary street address or building number for the location, typically the first line of a mailing address.
AddressLine1Local String The primary street address in a local or native language format, used in regions with different address structures.
AddressLine2 String Additional address information such as apartment number, suite, or floor designation.
AddressLine2Local String Additional address details in a local language format, ensuring proper address recognition in regional contexts.
AddressLine3 String Further address details, often used for complex addresses or extended location specifications.
AddressLine3Local String Extended address details in the native language format for regional use.
AddressLine4 String A supplementary field for address details, sometimes used for rural or specialized location information.
AddressLine4Local String Additional address information in a localized format for country-specific address conventions.
AddressLine5 String An optional line for additional address segmentation, typically used in large organizations or complex locations.
AddressLine5Local String Localized version of Address Line 5, ensuring accurate representation in the native language.
AddressLine6 String Extra space for specific address needs, often left blank unless required.
AddressLine6Local String Localized equivalent of Address Line 6 for regions with different address structures.
AddressLine7 String Additional optional line for highly detailed address configurations.
AddressLine7Local String Localized version of Address Line 7, used where regional address formats necessitate more fields.
AddressLine8 String Further extension of address information when needed for clarity.
AddressLine8Local String Native language version of Address Line 8 for better regional compatibility.
AddressLine9 String Last optional address field for special cases requiring detailed location information.
AddressLine9Local String Localized equivalent of Address Line 9, providing full address comprehension in native formatting.
City String The city in which the address is located, used for geographical identification.
CityLocal String The local language representation of the city name, ensuring consistency with regional address standards.
CitySubdivision1 String The first subdivision of the city, such as a district or borough, providing more precise location details.
CitySubdivision1Local String The localized name of the first city subdivision, ensuring alignment with regional naming conventions.
CitySubdivision2 String A secondary city subdivision, often used for further regional classification such as a neighborhood or sector.
CitySubdivision2Local String The native language equivalent of the secondary city subdivision for accurate local referencing.
CountryCity_Descriptor String A human-readable summary or preview of the associated city and country combination.
CountryCity_Id String A system-generated unique identifier for the specific country and city combination.
CountryRegion_Descriptor String A text-based preview of the country and its associated region, used for easy identification.
CountryRegion_Id String A unique identifier representing the country and its region in the system.
Country_Descriptor String A descriptive label for the country, making it easier to recognize in reports or selections.
Country_Id String A unique system-generated identifier for the country associated with the address.
Effective Datetime The date on which this address record takes effect, determining its validity in the system.
FullFormattedAddress String A fully formatted version of the address, combining all relevant fields into a structured layout suitable for display or mailing.
FullFormattedLocalAddress String The complete formatted address in the local language or region-specific format for accuracy in regional mailing.
PostalCode String The postal or ZIP code associated with this address, used for mail delivery and location identification.
RegionSubdivision1 String The primary administrative subdivision of a country, such as a state, province, or territory.
RegionSubdivision1Local String The localized name of the primary region subdivision, reflecting regional naming conventions.
RegionSubdivision2 String A secondary administrative subdivision, such as a county, district, or prefecture.
Usage_Primary Bool Indicates whether this address serves as the person's primary address. If true, this is the main address on record.
Usage_Public Bool Indicates whether this address is publicly visible. If the value is 'false,' the address is considered private.
Usage_UsageType_Descriptor String A preview or summary of the specific usage type associated with this address, such as 'Home' or 'Work'.
Usage_UsageType_Id String A unique system identifier for the specific usage type assigned to this address.
Effective_Prompt Date The effective date for the person's addresses, formatted as yyyy-mm-dd, used to determine which address records are valid at a given time.
PrimaryOnly_Prompt Bool If the value is 'true,' it only returns addresses designated as primary for the person.
PublicOnly_Prompt Bool If the value is 'true,' it only returns addresses marked as public, filtering out private addresses.
UsedFor_Prompt String Defines the intended usage of the address, such as for mailing, billing, or shipping purposes.
Universal_ID_Prompt String The universal unique identifier for the person whose addresses are being retrieved, ensuring correct association.

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