Running the Validate Monthly Pay Query

Summary

In this article, you will learn the steps to run the Validate Monthly Pay query on the OneUSG Connect System Manager Reporting Page in order to view and validate monthly payroll.

Body

   Overview   

The Validate Monthly Pay query provides data relating to monthly paid employee paychecks. The prompts entry of a Pay Run ID.

More information about Pay Run IDs can be found below in the Addtional Information section.

In this article, you will learn the steps to run the Validate Monthly Pay query on the OneUSG Connect System Manager Reporting Page in order to view and validate monthly payroll.

Note: Data has been redacted to protect employee information.

1. Step 1

step image

First, log into OneUSG Connect

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

2. Step 2

step image

The System Manager Reporting page is displayed.

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

3. Step 3

step image

A list of available Payroll queries is displayed.

Click the Monthly Payroll Query Group link.

4. Step 4

step image

The query is displayed on the right side of the screen.

Click the Validate Monthly Pay link.

5. Step 5

step image

To search the data using this query, you must enter a Pay Run ID.

Enter the Pay Run ID manually, or click the lookup magnifying glass to the right of the field to search for the appropriate value.

Example shown here: Click the lookup magnifying glass.

6. Step 6

step image

A list of possible Pay Run IDs is displayed.

Pay Run ID is organized by year. Everything from a certain year starts with the same value. For example, 2019 Pay Run IDs begins with 9, and 2020 Pay Run IDs begin with 0. Please see the landing page for this tutorial for more information on reading the Pay Run ID.

Click to select the appropriate Pay Run ID.

Example shown here:  01M1  link to select the January 2020 monthly pay run.

7. Step 7

step image

You can continue to refine your search using the prompts for Department and/or Empl ID.

Click the View Results button.

8. Step 8

step image

The selected monthly pay run matching your search criteria is displayed.

Click the Excel SpreadSheet link.

9. Step 9

step image

Click the Open File button to open the spreadsheet with Excel.

10. Step 10

step image

The Excel document is displayed in a protected view.

Click the Enable Editing button.

11. Step 11

step image

The first columns show Empl ID, Position number, Job Title.

Scroll to the right to view additional columns.

12. Step 12

step image

The query displays Earns Begin and Earns End dates, plus Regular Earnings.

Scroll to the right to view additional information.

Additional Information:

The query contains information about Earns Begin, Earns End, Regular Earnings, Total Gross pay, Job Comp Rate, the difference between what they were paid and what was expected, and additional links internal to the query that show unpaid absences and employees without a paycheck.

Understanding Pay Run IDs

The Pay Run ID for each of the bi-weekly pay dates has the following naming convention:

  • 91B1 = 9 (2019) + 1 (January, 1st month) + B (Biweekly) + 1 (1st check for the month)
  • So, 93B3 = 2019 March (3rd month) Biweekly 3 (the 3rd check of March) 

The monthly Pay Run ID naming conventions are as follows:

  • 91M1 = 9 (2019) + 1 (January, 1st month) + M (Monthly) + 1 (1st check of the month - will always be 1)

Note: The months switch to letters after the 9th month: O for October, N for November, D for December. 

  • 9OM1 = 2019 October Monthly 1st Check

A list of all pay dates and pay run IDs can be found within the UGA Payroll Calendars.

 

Details

Details

Article ID: 149827
Created
Sat 9/24/22 11:25 PM
Modified
Fri 1/5/24 5:10 PM