Running the Employee Absence Activity Query

Summary

In this article, you will learn the steps to run a query on the OneUSG Connect System Manager Reporting Page in order to view absence activity by employee or by department.

Body

Overview

In OneUSG Connect, you can run a query to view employee absence activity by employee or by HR department (180_ABS_ACTIVITY). You can search by Begin Date (required), End Date, and whether or not the absence was approved.

Information returned includes Leave Type, Begin/End Date, Duration (in hours), and the name and ID of the employee who approved the absence.

In this article, you will learn the steps to run a query on the OneUSG Connect System Manager Reporting Page in order to view absence activity by employee or by department.

1. Step 1

First, log into OneUSG Connect

On the Manager Self Service homepage, click the System Manager Reporting tile.

2. Step 2

The System Manager Reporting page is displayed.

Under the Queries menu, click the Absence Management drop-down menu to view the available queries.

3. Step 3

A list of available Absence Management queries is displayed.

Click the Leave Balance Query Group tab.

Next, click the Absence Activity Detail link.

4. Step 4

The 180_ABS_ACTIVITY (Employee Absence Activity) query is displayed on the right side of the screen.

Click the collapse menu button to expand the workspace.

5. Step 5

Enter appropriate information into relevant search fields to narrow your search. You can search by Employee ID to find a specific employee, or you can search by HR Department to view all absence activity for a given department.

If you do not know the requested information, you can also use the lookup magnifying glass next to those fields to search for the correct value.

Example shown here: 1812345 " in the Employee ID field.