Whether to expand single instance, currency, and multi-instance columns into multiple subfield columns.

Data Type

bool

Default Value

true

Remarks

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

By default, the add-in automatically flattens certain WQL field types into two columns each:

• Single instance and Self referencing instance fields are split into an .id column and a .descriptor column.
• Currency fields are split into a .value column and a .currency column.
• Multi-instance fields are split into .id and .descriptor columns when ExpandMultiValues is set to True.

Set this connection property to False to disable all subfield flattening. When disabled, all field types are exposed as a single column and the add-in returns the raw value from Workday for each field.

For example, with this property set to True (the default), a primarySupervisoryOrganization single instance field is exposed as two columns:

• primarySupervisoryOrganization.id
• primarySupervisoryOrganization.descriptor

With this property set to False, the same field is exposed as one column:

• primarySupervisoryOrganization