Gross Pay Register

Overview

After each payroll, Gross Pay Register (GPR) reports are created as a record of employees' paycheck earnings. As part of the Payroll Controls process, departments need to verify the accuracy of their payroll transactions by reviewing the GPR.

This document describes three options for obtaining GPR data in the M-Pathways Human Resource Management System.

Navigation

NavBar > Navigator > Payroll for North America > UM Payroll Report > Dept Gross Pay Register

• Step-by-step procedures are available in My LINC for running reports:
  • Windows users: Run a Report to a Window – Step-by-Step Procedure
  • Macintosh users: Run a Report to the Report Manager – Step-by-Step Procedure
• To run the report for a specific payroll and department, complete the following prompts:
  • Department ID(s), EmplID(s), or Project/Grant(s)
  • Pay Period End Date (the last day of the pay period)
  • On-cycle or Off-Cycle
    Note: On-cycle payrolls are the normal biweekly and monthly payrolls; off-cycle payrolls are weekly runs for on-demand payments.
• A Run Control ID is used to run this report.
  • This enables departments to enter and retain multiple departments, projects, or EmplIDs on the Run Control page for regular reporting.
  • The Pay Period End Date, and possibly the On/Off Cycle indicator, still need to be updated when running the report.
  • For more information about Run Control IDs, refer to the M-Pathways Run Control ID Information – Reference Document in My LINC.

Access to this option is granted with any of the following roles:

• HR APPT VIEWER
• HR TOTAL APPOINTMENT VIEW USER
• TL TIME ENTRY USERS
• PY GROSS PAY REGISTER USERS

Three public queries provide GPR data by Fund, Department, and Program. They can be run by Dept ID, EmplID, or Static Group ID, as indicated at the end of the query names:

• MTL_GROSS_PAY_BY_DEPT
• MTL_GROSS_PAY_BY_EMPL
• MTL_GROSS_PAY_BY_GROUP

Navigation

NavBar > Navigator > Reporting Tools > Query > Query Viewer

For more information on using public queries, refer to the:

• Run a Public (Existing) Query - Step-by-Step Procedure – details the steps to run a public query
• Public Queries for Timekeepers - Support Material – lists the queries with descriptions.

Access to this option is granted with any of the following roles:

• TL TIME ENTRY USERS
• PY GROSS PAY REGISTER USERS

The complete GPR reports are made available for viewing, searching, and printing select pages in Report Manager.

Navigation

NavBar > Navigator > Reporting Tools > Report Manager

Select the Explorer tab, expand the PY Gross Pay Registers folder, and click the appropriate GROSS PAY REGISTER link based on the date in the link.

Additional Information

• The view and Print a Report from a Report Manager Folder - Step-by-Step procedure document in My LINC details the steps for opening, viewing, and printing select pages of a batch-generated report.

Access to this option is granted with any of the following roles:

• HR APPT VIEWER
• HR TOTAL APPOINTMENT VIEW USER
• TL TIME ENTRY USERS
• PY GROSS PAY REGISTER USERS

 

Letter	Report Field	Description
A	Journal Date	Displays the payday of the payroll.
B	Payroll Cycle	Displays the type of payroll (i.e., On-Cycle, Off-Cycle).
C	Pay End Date	Displays the last day of the pay period included in the payroll.
D	Report Recipient	Identifies the person who is mailed a printed copy of this GPR. The person's Recipient Address displays below the name.
E	Fund/Dept/Program	Identifies the Fund, Department, and Program values associated with the subsequent rows of GPR data.
F	EmplID	Displays the person's Employee ID number (EmplID).
G	RCD#	Displays the Employee Record Number of the appointment for which earnings display.
H	Distribution Location	Indicates the means by which the employee's paycheck is distributed. This field displays Direct Deposit, U.S. Mail, or a physical check distribution location.
I	Erncd	Displays the Earnings Code (Erncd) that describes the row of earnings. These are three-character codes that sometimes, but not always, match the Time Reporting Codes (TRCs) used to report the earnings.
J	Rate/Salary	Displays the employee's base compensation rate/salary.
K	Hours	For each row of hourly earnings, displays the hours that are paid.
L	Amount	Displays the dollar amount paid for the row of earnings.
M	Short Code	Displays the Short Code (Combo Code) charged for the earnings.
N	GL Acct	Displays the General Ledger Account number (GL Acct) recorded for the earnings.
O	Type of Off-Cycle	For Off-Cycle payrolls, indicates the type of payment (e.g., Pay Adj, Sal Trans).
P	Sal Tran Org Chk Dt	For earnings resulting from the salary transfer process, displays the check date on which the earnings were paid originally.