ODBC Driver for Workday

Build 24.0.9060

WorkContactInformationChangesAddresses

An address as it exists staged for update by the parent business process.

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 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.

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

Id of the instance

WorkContactInformationChange_Id [KEY] String False

The ID of the change process, must be set in all queries.

AddressLine1 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 1

AddressLine1Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 1

AddressLine2 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 2

AddressLine2Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 2

AddressLine3 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 3

AddressLine3Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 3

AddressLine4 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 4

AddressLine4Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 4

AddressLine5 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 5

AddressLine5Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 5

AddressLine6 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 6

AddressLine6Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 6

AddressLine7 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 7

AddressLine7Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 7

AddressLine8 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 8

AddressLine8Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 8

AddressLine9 String False

Supported for: SELECT, INSERT, UPDATE. Address Line 9

AddressLine9Local String False

Supported for: SELECT, INSERT, UPDATE. Local Address Line 9

City String False

Supported for: SELECT, INSERT, UPDATE. City

CityLocal String False

Supported for: SELECT, INSERT, UPDATE. City - Local

CitySubdivision1 String False

Supported for: SELECT, INSERT, UPDATE. City Subdivision 1

CitySubdivision1Local String False

Supported for: SELECT, INSERT, UPDATE. City Subdivision 1 - Local

CitySubdivision2 String False

Supported for: SELECT, INSERT, UPDATE. City Subdivision 2

CitySubdivision2Local String False

Supported for: SELECT, INSERT, UPDATE. City Subdivision 2 - Local

CountryCity_Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

CountryCity_Id String False

Supported for: SELECT, INSERT, UPDATE. Id of the instance

CountryRegion_Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

CountryRegion_Id String False

Supported for: SELECT, INSERT, UPDATE. Id of the instance

Country_Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

Country_Id String False

Supported for: SELECT, INSERT, UPDATE. Id of the instance

Effective Datetime False

Supported for: SELECT. The date this business process takes effect.

PostalCode String False

Supported for: SELECT, INSERT, UPDATE. Postal Code

RegionSubdivision1 String False

Supported for: SELECT, INSERT, UPDATE. Region Subdivision 1

RegionSubdivision1Local String False

Supported for: SELECT, INSERT, UPDATE. Region Subdivision 1 - Local

RegionSubdivision2 String False

Supported for: SELECT, INSERT, UPDATE. Region Subdivision 2

Usage_Comment String False

Supported for: SELECT, INSERT, UPDATE. Returns the description for a given communication method.

Usage_Primary Bool False

Supported for: SELECT, INSERT, UPDATE. Returns Boolean Value False

Usage_Public Bool False

Supported for: SELECT, INSERT, UPDATE. Is Public Visibility

Usage_UsageType_Descriptor String False

Supported for: SELECT, INSERT, UPDATE. A preview of the instance

Usage_UsageType_Id String False

Supported for: SELECT, INSERT, UPDATE. Id of the instance

Usage_UsedFor_Aggregate String False

Supported for: SELECT, INSERT, UPDATE. A JSON aggregate. Used For

PublicOnly_Prompt Bool False

No description available.

UsedFor_Prompt String False

No description available.

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