WorkContactInformationChangesAddresses

Represents address updates pending approval as part of a worker's contact information change process.

Table Specific Information

Select

The Workday connector requires filtering on WorkContactInformationChange_Id in order to perform the query.

For example:

SELECT * FROM WorkContactInformationChangesAddresses WHERE WorkContactInformationChange_Id = '1234';

Workday Resource Information

Retrieve an existing address as it exists when staged by the parent business process.

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

Scope: Contact Information

Aggregate Fields

The connector 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 /* The display name of the instance */
  id: Text /* Id of the instance */
}]

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique Workday ID of the instance.
WorkContactInformationChange_Id [KEY]	String	False	The Workday ID of the work contact information change process. Must be set in all queries.
AddressLine1	String	False	Primary address line 1.
AddressLine1Local	String	False	Localized version of address line 1.
AddressLine2	String	False	Primary address line 2.
AddressLine2Local	String	False	Localized version of address line 2.
AddressLine3	String	False	Primary address line 3.
AddressLine3Local	String	False	Localized version of address line 3.
AddressLine4	String	False	Primary address line 4.
AddressLine4Local	String	False	Localized version of address line 4.
AddressLine5	String	False	Primary address line 5.
AddressLine5Local	String	False	Localized version of address line 5.
AddressLine6	String	False	Primary address line 6.
AddressLine6Local	String	False	Localized version of address line 6.
AddressLine7	String	False	Primary address line 7.
AddressLine7Local	String	False	Localized version of address line 7.
AddressLine8	String	False	Primary address line 8.
AddressLine8Local	String	False	Localized version of address line 8.
AddressLine9	String	False	Primary address line 9.
AddressLine9Local	String	False	Localized version of address line 9.
City	String	False	City name.
CityLocal	String	False	Localized city name.
CitySubdivision1	String	False	First subdivision within the city (for example, district, borough).
CitySubdivision1Local	String	False	Localized version of city subdivision 1.
CitySubdivision2	String	False	Second subdivision within the city (for example, neighborhood).
CitySubdivision2Local	String	False	Localized version of city subdivision 2.
CountryCity_Descriptor	String	False	The display name of the instance
CountryCity_Id	String	False	The Workday ID of the city instance.
CountryRegion_Descriptor	String	False	The display name of the instance
CountryRegion_Id	String	False	The Workday ID of the region instance.
Country_Descriptor	String	False	The display name of the instance
Country_Id	String	False	The Workday ID of the country instance.
Effective	Datetime	False	The date when this work contact information takes effect.
PostalCode	String	False	Postal or ZIP code.
RegionSubdivision1	String	False	Primary region subdivision (for example, state or province).
RegionSubdivision1Local	String	False	Localized version of primary region subdivision.
RegionSubdivision2	String	False	Secondary region subdivision (for example, county or district).
Usage_Comment	String	False	Description of the communication method usage.
Usage_Primary	Bool	False	Indicates whether this is the primary communication method (false by default).
Usage_Public	Bool	False	Indicates whether this contact information is publicly visible.
Usage_UsageType_Descriptor	String	False	The display name of the instance
Usage_UsageType_Id	String	False	The Workday ID of the usage type.
Usage_UsedFor_Aggregate	String	False	List of purposes for which this contact information is used.
PublicOnly_Prompt	Bool	False	Filters for publicly visible contact information.
UsedFor_Prompt	String	False	Filters for specific usage types.