ODBC Driver for Workday

Build 23.0.8839

ExpandIDTypes

Whether to expand multiple ID types when they appear in reports. Only has an effect for queries using the Reports as a Service (RaaS) API.

Data Type

bool

Default Value

false

Remarks

Every Workday entity is identified by a WID (a GUID generated by Workday) but some types of entities have other types of identifiers. For example, a Workday country record for the United States would be identified using the "US" country code in addition to its WID.

By default the driver collects all these IDs under one column and produce an aggregate. This is the value of the Country_Reference.ID column for the US record:

<wd:Country_Reference>
    <wd:ID type="WID">abcdef1234567890</wd:ID>
    <wd:ID type="Country_Code">US</wd:ID>
</wd:Country_Reference>

If this option is enabled, the driver instead produces a separate column for each ID type. For the US record:

  • The column Country_Reference.ID.WID is set to abcdef1234567890
  • The column Country_Reference.ID.Country_Code is set to US

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