Last Paycheck by Empl Rcd

Description

This query will produce a list of employees that have not been paid based on the date you enter.  You can use this information to terminate employees that haven’t worked for a period of time in your department.  It’s most useful for finding hourly employees or those on contract pay that are no longer receiving pay.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Campus Code(s): leave blank to search across all campuses, or enter a value(s) to limit the report to one or more campuses.
  2. RC Code(s): leave blank to search across all RCs, or enter a value(s) to limit the report to one or more responsibility centers.
  3. Department Id(s): leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  4. Paygroup Code(s): leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups. HRP, HRR, and HRW will be entered by default.
  5. Pay End Date Less Than:  Enter date to limit your selection.

  6. Employee Id(s): Either leave blank and let other selection criteria drive the results, or enter ID number leaving all other selection criteria blank to retrieve info for specific employee.
  7. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  8. Select Output Destination: this report can run slowly; select "Send to Completed Reports." When the report has finished, you will receive an email with a direct link to the results. Alternatively, go to the Completed Reports folder in My Catalog to open the report from within IUIE. 
  9. Click the RUN button.