Last Paycheck by Empl Rcd

Description

Use this query to generate a list of employees that have not been paid since the date specified in the report parameters. This report allows users to identify employees that have not worked in your department for a certain period of time and may be eligible for termination. This report also allows users to identify hourly employees or staff on contract pay that are no longer receiving paychecks.

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 Check Date Less Than (MM/DD/YYYY): leave blank to see the employee's most recent paycheck (if the 'Employee Id(s)' field is filled in), or enter a date to see all employees who have not received a check since that date.
  6. Employee Id(s): leave blank to search all employee data, or enter one or more 10-digit ID numbers to limit the report to one or more employees.
  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.