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.
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 Payroll drop-down menu to view the available queries.
A list of available Payroll queries is displayed.
Click the Monthly Payroll Query Group link.
The query is displayed on the right side of the screen.
Click the Validate Monthly Pay link.
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.
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.
You can continue to refine your search using the prompts for Department and/or Empl ID.
Click the View Results button.
The selected monthly pay run matching your search criteria is displayed.
Click the Excel SpreadSheet link.
Click the Open File button to open the spreadsheet with Excel.
The Excel document is displayed in a protected view.
Click the Enable Editing button.
The first columns show Empl ID, Position number, Job Title.
Scroll to the right to view additional columns.
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:
The monthly Pay Run ID naming conventions are as follows:
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.