UKG Data Integration

UKG Pro and UKG Pro WFM Posts

UKG Data Integration

California Meal and Rest Breaks in UKG Pro WFM

In California if a person doesn’t take a break after five hours, they receive extra pay. Unless they attest that it was their choice to skip the meal. A similar rule applies for rest breaks.

UKG has standard functionality to handle this but it’s not straightforward. Our client had an added challenge. Some of their employees use a different system to enter time and attestations. that data needed to be interfaced.

I thought about writing up the entire process in detail. But it’s just too much for a blog post. Here are some key lessons learned:

  1. There are many ways to create the pay code edit for the penalty. You can use:
    1. A bonus rule attached to a work rule attached to the pay rule for the employee.
    2. An Attestation workflow
    3. A Boomi Extension.
      Choose one so you don’t get more entries than you expect.
  2. If the meal break pay code is created automatically, you may want to cancel it. You can do this:
    1. With an Attestation workflow. The pay code edit will show as cancelled in the timecard. Users may be confused.
    2. With an API to delete the pay code edit.
  3. Just because the process works on the screen, DOESN’T mean it will work when called via the API.
    We had an issue where the attestation button created a pay code when the button was used from the tile on the user’s home page.
    It didn’t work when the same button was “punched” via API. Support provided additional code to resolve the issue.

You can’t understand an API unless you understand the system. If you want help bridging the API/Application gap, contact us.

UKG People Analytics and Reporting

Power BI and UKG Pro

You’re here because you want to use Power BI with UKG Pro Data.

You’re not the only one. Here’s a solution that might interest you.

The solution comes with all the code you need to run reports in UKG People Analytics and have the data show up in Power BI. The Power BI model has measure based on payroll amounts and hours. We’ll be adding head count statistics shortly. All the basics are included – like Job and org Level information.

So, let’s point out a few key things for business users and technical folks:

Read more…
UKG Data Integration

UKG Pro – Reports as a Service vs Rest API

Why We Use Reports as a Service over Rest APIs with UKG Pro

You need to decide how to get your data from UKG Pro. We recommend Reports as a Service (RAAS) even as we also support Rest APIs. Here’s the data.

  1. It provides the most data
    We’ve found all the data we need in People Analytics. While the API list is long, it’s not FULLY comprehensive. For example, the Employee Pay Statement shows everything the employee sees on their check. It doesn’t show Org Level Job allocations. If you do a lot of payroll analysis, this doesn’t work. If you’re like all my customers, you have at least SOME people that work in multiple departments and even in multiple jobs. If someone has found an API that provides this detail, please, please, please let me know I’m wrong.
  2. RAAS leverages user knowledge.
    There are plenty of folks who know how to use people Analytics. We want to leverage that knowledge. Consulting time is expensive. You should pay for what you need, not for what you can already do. Of course, if you don’t have People Analytics expertise, we are happy to help
  3. RAAS is one thing to learn.
    There are lots of APIs. And they all work. But they all work differently. Which means every new piece of data means something new to learn. We’ve learned most of them. But it wasn’t fun.

UKG Pro Rest APIs have their place. If you want to build your own user application, APIs can be the way to go. But for analytics, we think RAAS is the way to go.

Two other options before we leave.

UKG Pro also supports Informatica. Informatica is a complex tool and resources are expensive and not easy to come by. We prefer widely known tools like PowerShell. When you choose an approach, you want to make sure that you’re not dependent on a particular resource.

If you already have a cloud data warehouse like Snowflake or RedShift, you have another option to consider. Portable.io has created a pipeline to take data from UKG Pro directly into several cloud data warehouse like Snowflake and RedShift based on the APIs. We’ve been working with Snowflake for other purposes and as we learn more, we’ll be sure to post.

What have you been using to get your data from UKG Pro?

UKG Data Integration

UKG Reports as A Service in Postman

You want to understand how to run People Analytics Reports as A service (RAAS). If you just want the sample Postman code, you can request that here. Please note that the last step of the process requires a few lines of PowerShell outside of Postman. For your reference, here’s the UKG documentation.

Read more…
UKG Data Integration

Choosing A UKG Consultant

There are many UKG Pro/UltiPro/Kronos/Dimensions consultants out there. And if you’re searching for help, all the websites may have started to merge together.

Everyone has years of experience, focuses on their client and delivers great results.

Why would you choose us?

Read more…
UKG Data Integration

UKG Pro – Assigning Platform Configuration Field Values to Business Rules

As a data person, you’ll find that platform configuration fields are among the most useful features of UKG Pro aka UltiPro. These are user fields on steroids, allowing not only to add data, but to validate that data. In order to validate that data, you’ll generally need to set up a custom business rule. I’m not going to go through all the steps for adding a platform configuration field as there is solid documentation on the web site. However, once you have the field setup, you’ll want to add values. And if you have lots of records to update, you don’t want to do that manually.

Read more…

Get tips and insights delivered to your inbox

Start a conversation with us

Call: 917-848-7284
Email: inquiries@redthree.com

Request a Consult