ODBC Driver for Workday

Build 24.0.9062

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.

データ型

bool

デフォルト値

false

解説

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 本製品 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 本製品 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 24.0.9062