ExpandIDTypes
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 server 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 server 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"