Extract Single Instance

Security: Custom Field Management
domain in the System functional area.

You can set up the calculated field to extract a single instance from a multi-instance field based on a boolean condition.

Access the

Create Calculated Field

task.

Select Extract Single Instance
for the

Function

As you complete the

Calculation

tab, consider:

Option	Description
Source Field	Select a multi-instance field to apply the boolean condition to.
Condition	Specify the boolean condition associated with the related business object to apply to the Source Field .
Sort Field	Select a field to use as the basis for sorting. You can set up the Sort Direction and specify the number of Instance to be Returned . When sorting dates, Workday places the earliest date first in ascending sort and the most recent date first in descending sort. When sorting boolean values, Workday ranks a false value as 0 and true as 1, so an ascending sort places false values before true values and a descending sort places true values before false values. Example: Select Workday ID if you want Workday to sort the results by the employee's ID.

Workday returns zero instances or 1 instance from a related business object that satisfies the boolean condition.

You can use the calculated field to retrieve information about an employee, such as:

Current dental, medical, and vision enrollments as separate fields.

Dependents as Dependent #1, Dependent #2, and so on.

Last completed performance review in 2018.

Last master's degree received.

Last time off request.

Create additional calculated fields.

Create new calculated fields from within an extract single instance calculated field.