PY - Review Edit Report Delivered via Cypress
The Payroll Edit Report is used to verify payroll data before the final payroll calculation and confirmation each pay period. Users of this report will be at the department, division, campus and UW Service Center levels. The report will be delivered via Cypress and will also be available to run ad hoc by campuses, divisions and departments as needed. This document describes how to review the Payroll Edit Report delivered via Cypress.
The Payroll Edit Report is used to review and verify a variey of employee information before the payroll is confirmed:
- payroll funding adds or changes entered on the Funding Data Entry page in HRS
- appointment adds or changes made on the employee's HR Job Data record in HRS
- status of the employee's WRS (Wisconsin Retirement System) indicator
- status of the employee's FICA (Federal Insurance Contributions Act) indicator
The Payroll Edit Report will be processed for a specific Pay Run ID (payroll period). It may also be run for a specific Business Unit (campus) or a specific Department within a Business Unit. The report will be sorted by Business Unit, Department (appointment/job department) and Name. The report contains information in the following columns:
- EmplID - the numeric employee identifier used in PeopleSoft
- Name - the name of the employee to be paid
- Empl Class - an attribute assigned to a job record for job groups with similar attributes (appointment type)
- Job Code - a numeric (university staff (classified) and student hourly) or alpha-numeric (unclassified) value that corresponds to a job title
- Job Title - the job title (Title Code in Legacy) corresponding to the Job Code
- Empl Rcd - the Employee Record # identifies an individual job that an employee holds with the university. Employees may have multiple Employee Records #'s when they actively hold more than one job at the university.
- Position Number - A position is a defined place in the organization that is continually filled by an employee. PeopleSoft uses positions to default specific information about a position into the job record. Each position has a unique position number.
- Fund Dist Eff Date - the funding effective date of the funding distribution
- Account Code - the funding combination that will be interfaced to the Shared Financial System (SFS) including fund, department ID, program, project and account
- WRS - the Wisconsin Retirement System indicator, Y = yes, N = no
- FICA (Federal Insurance Contributions Act) - the FICA indicator; E = Exempt, N = Non-Exempt (Subject to FICA), M = Medicare Only
- Pay Frq - Pay Frequency defines how often an employee is paid; 9M = 9 month, A = Annual, M = Monthly, H = Hourly
- Ern Code - the Earnings Code established in payroll to record the payment
- Hours/Amount - this field represents either the number of hours to be paid (for hourly employees the number of hours from Time & Labor and Absence Management, for unclassified employees the standard hours coming derived from the FTE; or the dollar amount. Keep in mind that both hours and amounts can be either a positive or a negative number.
- Pay Rate - for hourly employees this represents the official hourly pay rate, for unclassified employees this represents the PeopleSoft calculated hourly rate
- Monthly Rate - for unclassified employees this is their monthly rate calculated based upon their FTE, for hourly employees this field will be blank
- Fund ($/%) - If any portion of the funding is set up as a flat dollar amount, the amount will be displayed in this field. The funding percent (%) must total to 100% for each Empl Rcd.
- Funding Amount - the amount of payment for each Account Code by Empl Rcd.
- Fund Level - The funding level follows a hierarchy of Appointment (Appt) (EmplID + Empl Rcd), Position (Pos), and Department (Dept). If no funding is assigned at any of these levels or the account code is invalid, a Suspense (Susp) chartfield combination will be assigned to the payment. For more information on salary funding levels assigned at the time of payroll processing, refer to HRS KnowledgeBase document 21872, FN - Salary Funding Levels Assigned During Payroll Processing .
Some of the notable items to verify/correct when reviewing the Payroll Edit Report include:
- Empl Rcd - verify that the employee will be paid for all Empl Rcds (jobs) that they are expected to be paid from during the current pay period.
- WRS - verify that the correct WRS indicator is listed
- All Suspense funding should be cleaned up prior to the Final Calculation process. An Account Code of 128-PRSUSP-1-xxxx indicates that the funding is defaulting to the Suspense account. When the payment defaults to the Suspense funding, the Fund Level will indicate "Susp" and the Fund ($/%) will display as 0.000. Suspense funding will default if the employee is missing funding for all or part of their pay period.
- If a section titled Error Section (Employees with no/partial Funding Information) is listed, all Empl Rcd must have their funding corrected.