HomeContactInformationChangesAddresses

Tracks address changes staged for update in an employee's home contact details, reflecting modifications pending approval.

Table Specific Information

Select

The Workday driver requires filtering on HomeContactInformationChange_Id in order to perform the query.

For example:

SELECT * FROM HomeContactInformationChangesAddresses WHERE HomeContactInformationChange_Id = '12345';

Workday Resource Information

Retrieve all addresses staged for update by the parent business process

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

Scope: Contact Information

Aggregate Fields

The driver 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	Unique identifier of the address record instance.
HomeContactInformationChange_Id [KEY]	String	False	Unique identifier of the home contact information change process. Must be specified in all queries to ensure accurate results.
AddressLine1	String	False	Primary address line, typically containing the street name and number.
AddressLine1Local	String	False	Primary address line in the local language or format.
AddressLine2	String	False	Secondary address line, often used for apartment, suite, or building information.
AddressLine2Local	String	False	Secondary address line in the local language or format.
AddressLine3	String	False	Additional address line for extended location details.
AddressLine3Local	String	False	Additional address line in the local language or format.
AddressLine4	String	False	Additional address line, commonly used for complex addresses or rural routes.
AddressLine4Local	String	False	Additional address line in the local language or format.
AddressLine5	String	False	Additional address line for further location specificity.
AddressLine5Local	String	False	Additional address line in the local language or format.
AddressLine6	String	False	Additional address line for large or multi-structure locations.
AddressLine6Local	String	False	Additional address line in the local language or format.
AddressLine7	String	False	Additional address line for extended address details.
AddressLine7Local	String	False	Additional address line in the local language or format.
AddressLine8	String	False	Additional address line for special location instructions.
AddressLine8Local	String	False	Additional address line in the local language or format.
AddressLine9	String	False	Additional address line for complex location descriptions.
AddressLine9Local	String	False	Additional address line in the local language or format.
City	String	False	The name of the city.
CityLocal	String	False	Name of the city in the local language or format.
CitySubdivision1	String	False	First-level subdivision within the city, such as a district or borough.
CitySubdivision1Local	String	False	First-level city subdivision in the local language or format.
CitySubdivision2	String	False	Second-level subdivision within the city, such as a neighborhood or zone.
CitySubdivision2Local	String	False	Second-level city subdivision in the local language or format.
CountryCity_Descriptor	String	False	Text description providing a preview of the country and city.
CountryCity_Id	String	False	Unique identifier for the combination of country and city.
CountryRegion_Descriptor	String	False	Text description providing a preview of the country and region.
CountryRegion_Id	String	False	Unique identifier for the combination of country and region.
Country_Descriptor	String	False	Text description providing a preview of the country.
Country_Id	String	False	Unique identifier for the country.
Effective	Datetime	False	Date when the home contact information change takes effect.
NumberDaysWFH	Decimal	False	Number of days per week the individual works from home.
PostalCode	String	False	Postal or ZIP code used for mail delivery.
RegionSubdivision1	String	False	First-level administrative region subdivision, such as a state or province.
RegionSubdivision1Local	String	False	First-level region subdivision in the local language or format.
RegionSubdivision2	String	False	Second-level administrative region subdivision, such as a county or district.
Usage_Comment	String	False	Description or comments related to the usage of the communication method.
Usage_Primary	Bool	False	Indicates whether this address is the primary contact location.
Usage_Public	Bool	False	Indicates whether this address is visible to the public.
Usage_UsageType_Descriptor	String	False	Text description of the usage type, such as home, work, or mailing.
Usage_UsageType_Id	String	False	Unique identifier for the usage type.
Usage_UsedFor_Aggregate	String	False	List of purposes this address is used for, with values separated by commas and a space after each comma.
PrimaryOnly_Prompt	Bool	False	Boolean value indicating if only the primary address should be returned.
UsedFor_Prompt	String	False	Specifies the context or purpose for which the address is used.