Workday Integration Report: Displaying Dependents

In this Workday Integration I would want to demonstrate you how reports show employee dependents.

When I run the report for 2 employees, it retrieves all dependent details automatically.

About example, you may view all the details about the dependents of Logan McNeely and Jacqueline.

With Workday Integration, you can easily pull this data efficiently.

Adding Age and Relationship in Workday Integration

Then I added 2 fields. Age and Relationship.

I restricted the number of fields to make the report more readable.

You can use Workday Integration to add calculated fields like these to arrange dependent data.

Once entered, you can plainly see which dependent is a spouse and which is a child, along with their ages.

Extracting Youngest Child in Workday Integration

Now let’s see how to get a single instance utilizing Workday Integration.

The purpose is to choose the youngest dependent child.

For example, Logan McNeely has three dependents: a spouse and two children.

I can use Workday Integration to construct a calculated field that brings in only the youngest child.

Betty Liu’s youngest child is also John Wick.

Creating a Calculated Field in Workday Integration

Workday Integration Create Calculated Field I am going to “Create Calculated Field” I selected the Worker business object.

Then I click ‘Extract Single Instance’. I provide which instance from the multi-instance dependent field to extract.

Workday Integration seamlessly links similar business objects so you can easily filter and extract data.

Filtering by Child Relationship in Workday Integration

Then I create a condition to get just children.

I set up conditions on related business items through the Workday Integration and applied it to the dependent relationship field.

Then I filter by ‘Child’ and the report only shows dependent instances that are children.

This makes the data much easier to evaluate.

Sorting Dependents by Age in Workday Integration

I filter out all child dependents and organize them by age in ascending order.

Then Workday Integration shows the youngest child in the first row.

Now the first occurrence of the youngest child is easy to extract.

If I wanted the last child I’d use the last occurrence instead.

Workday Integration sorting makes sure I always obtain the right dependent instance.

Using Extracted Instance in Workday Integration Reports

After I create the calculated field, I add it to the report.

With Workday Integration you can pull more information for the extracted instance, for example, first name, last name, gender.

The youngest child extracted now is treated as a connected business object and I can extract more information for reporting reasons.

Workday Integration Enables Instance-Level Data to be Available and Usable

Leveraging Calculated Fields as Business Objects in Workday Integration

The powerful element of Workday Integration is any instance type calculated field can be a business object.

That implies after I construct the youngest kid instance, I can treat it as a separate business item in my report.

Then I can immediately pull more fields and details out of it.

Workday Integration facilitates dealing with multi-instance data and helps create clean accurate reports.

Workday Integration:  Extract Multi Instance

Now we are acquainted with extract single instance in Workday Integration, let’s go to extract multi – instance.

Extract multi-instance in Workday Integration lets you extract more than one instance for an employee, but not all of the instances.

You use the extract multi-instance calculated field for this purpose.

Before constructing a multi-instance calculated field in Workday Integration, you need to know four operations: subset, intersection, except, and union. these activities will make your reports much easier to deal with.

Workday Integration Subset Operation

subset allows you to retrieve a fraction of objects from the whole collection in Workday Integration.

Let’s say you have 100 goods and you just need 80 With subset you may filter to get only what you need.

This is the simplest action in multi-instance and works very well for dealing with dependent data.

Workday Integration Intersection Operation

With Intersection in Workday Integration you can evaluate two conditions at the same time. You will only see those things that satisfy both conditions in your output. For example, if you have two groups of objects, intersection pulls out the common objects that meet both requirements. It ensures accurate results in your reports.

Workday Integration Except Operation

Except operation is quite powerful in Workday Integrate. Thus one of the conditions is satisfied, but not the other.

Workday Integration excludes objects that fit the excluded condition so you may focus on the data you need and ignore the rest.

Workday Integration Union Operation

Workday Integration Union incorporates numerous conditions.

If the item meets any of the conditions you specify, it will be in your output.

This is useful if you want a wider view without losing valuable data from several circumstances.

Workday Integration in Practice: Creating Multi Instance Calculated Fields

To build a multi-instance calculated field in Workday Integration, start by choosing your operation type.

If you want a subset, for example, select subset. Then, specify the source field and condition.

In my example I pulled all dependents with connection “child”.

Once you create the calculated field, you may view the results in your report right away.

For example, Workday Integration pulled two dependents for Logan McNeil with the connection ‘child’ and none for Jacqueline.

This makes the analysis of the employees’ data transparent and efficient.

Workday Integration Reporting Tips

Workday Integration also supports counts of occurrences from connected business items.

For example, if Swetha has five dependents, you might count all dependents or only the children.

This flexibility is useful when constructing rich reports and dashboards with Workday Integration.

Keep in mind, Workday Integration allows you the flexibility to choose the data you want to extract, whether it’s a subset, intersection, exception, or union

These activities ensure your reports are accurate and actionable.

Creating Count Related Calculated Fields in Workday Integration

When dealing with Workday Integration, you typically need to access particular counts for some employee data.

Sometimes you don’t want to pull all instances. Instead you can create an instance computed field on a count to get exactly what you need.

Let me show you how it works. Say you wish to count all the child workers.

First create a calculated field in Workday Integration.

Call it something like ‘Child Worker Count’ and choose the number type.

This will ensure that your report handles the data correctly.

Setting Conditions in Workday Integration Calculated Fields

You can add criteria to your computed fields in Workday Integration.

Here I simply want examples that satisfy some relation.

For example, if the connection is ‘child’, I set the criteria to only include child dependents.

This allows me to keep my report short and not count additional dependent kinds like spouses.

Type the condition and click OK. Your Workday Integration Calculated Field is now ready to be used in Reports.

It will return only the occurrences that satisfy your criteria, so you may get more accurate insights.

Adding Count Related Calculated Fields to Reports in Workday Integration

After you create your calculated field, you can add it to any report in Workday Integration.

For example, if I look in my report to Logan MacNeil the ‘Child Worker Count’ field has the correct numbers.

So, if Logan has two child dependents the field will return ‘2’. If there aren’t any, it returns ‘0’.

Instead, if I had picked all cases, Workday Integration would have tallied all dependents including spouses.

I employ count-based instance fields with criteria to keep my reports tidy and focused on just the data I want.

Practical Tips for Using Workday Integration Count Fields

Keep in mind Workday Integration calculated fields are great for conditional counts.

Be sure to establish your conditions properly for reliable results. The number-type field guarantees that your reports total appropriately.

This approach in Workday Integration allows you to create various count fields for different sorts of dependents or other relationships.

It is a versatile, time-saving solution that eliminates the need for human counting.