Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Extract Multi-Instance

Extract Multi-Instance

Security:
Custom Field Management
 domain in the System functional area.
You can use the calculated field to extract multiple instances from a related business object based on a boolean condition.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Extract Multi-Instance
     from the
    Function
     prompt.
  3. On the
    Calculation
     tab, select the
    Operation Type
    .
    Option Description
    Except
    Evaluates the filtered instances from
    Source Field 1
     and
    Source Field 2
     and returns the instances from the first field minus the instances from the second.
    The related business object associated with both source fields must be the same.
    Intersection
    Evaluates the filtered instances from
    Source Field 1
     and
    Source Field 2
     and returns only the common instances.
    The related business object associated with both source fields must be the same.
    Subset
    Filters instances specified in
    Source Field 1
     and returns the results.
    Union
    Combines the filtered instances from
    Source Field 1
     and
    Source Field 2
     and returns all results.
    The related business object associated with both source fields must be the same.
  4. As you complete the
    Calculation
     tab, consider:
    Option Description
    Source Field
    Select the source field to apply a boolean condition to.
    Condition
    Specify the boolean condition associated with the related business object to apply to
    Source Field 1
     and
    Source Field 2
    .
Workday returns a set of multi-instance fields matching the defined criteria and removes any duplicate instances from the results. If no instances match the condition, Workday returns an empty value.
You can use the calculated field to list:
  • All staffing events associated with an employee's current position.
  • Any employee event for an employee that occurred in 2009.
  • Current enrollment elections for an employee.
  • Teams to which an employee belongs.
  • Training completed by each employee in the last 12 months.
You can create:
  • Additional calculated fields.
  • New calculated fields from within an extract multi-instance calculated field.