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.
First, log into OneUSG Connect
On the Manager Self Service homepage, click the System Manager Reporting tile.
The System Manager Reporting page is displayed.
Under the Queries menu, click the Absence Management drop-down menu to view the available queries.
A list of available Absence Management queries is displayed.
Click the Leave Balance Query Group tab.
Next, click the Absence Activity Detail link.
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.
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.
Begin Date is a required field.
Enter appropriate information into the Begin Date field, or click the calendar icon to find a specific date.
Example, shown here: "12/16/2018 " in the Begin Date field.
Enter additional information as needed, then click the View Results button.
The query results are displayed. Each type of leave is displayed on its own row for each employee.
To open the results in Excel, click the Excel Spreadsheet link.
Click the OK button to open the spreadsheet with Excel.
The Excel document is displayed in a protected view.
Click the Enable Editing button.
Useful columns in the query include Leave Type, Begin Date, and End Date.
Scroll to the right to view additional columns, including the Duration of each absence request in hours.
Scroll to the right to view additional columns, including the Approver Name ( Appr Name ) and Date/Time ( Appr Datetime ) of approval.