Display one column per ID type when a report contains multiple ID types.

Data Type

bool

Default Value

false

Remarks

Note: This connection property only applies when ConnectionType is set to Reports.

Every Workday entity is identified by a unique ID (generated by Workday) called a Workday ID (WID), but some types of entities have other types of identifiers.

For example, a Workday country record for the United States is identified using the "US" country code in addition to its WID.

By default, the add-in collects all these IDs under one column and produce an aggregate. For example, 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 connection property is set to True, the add-in instead produces a separate column for each ID type. The aggregate value above is expanded into these two columns:

• The column Country_Reference.ID.WID displays "abcdef1234567890"
• The column Country_Reference.ID.Country_Code displays "US"