Running the Validate Monthly Pay Query

   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

Manager Self Service homepage displayed with the System Manager Reporting tile highlighted

First, log into OneUSG Connect

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

2. Step 2

System Manager Reporting page displayed with the Payroll drop-down menu highlighted

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

Payroll queries displayed with the Monthly Payroll Query Group link highlighted

A list of available Payroll queries is displayed.

Click the Monthly Payroll Query Group link.

4. Step 4

Payroll queries displayed with the Validate Monthly Pay link highlighted

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

Click the Validate Monthly Pay link.

5. Step 5

Payroll queries displayed with the lookup magnifying glass in the *Pay Run ID field highlighted

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

Pay Run IDs displayed with the 01M1link highlighted

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

Pay Run ID query page displayed with the View Results button highlighted

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

Click the View Results button.

8. Step 8

Selected monthly pay run matching your search criteria displayed with the Excel Spreadsheet link highlighted

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

Click the Excel SpreadSheet link.

9. Step 9

Selected monthly pay run matching your search criteria displayed with the Excel file Open button highlighted

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

10. Step 10

Excel document displayed with the Enable Editing button highlighted

The Excel document is displayed in a protected view.

Click the Enable Editing button.

11. Step 11

Excel document displayed with the cell 2 information highlighted

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

Scroll to the right to view additional columns.

12. Step 12

Excel document displayed with the cell 2 information highlighted

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.

 
Print Article