Timekeeping Hours Summary

Description

Use this query to summarize total hours logged in Kuali Time by campus, department, work area, work task, earn code, employee, and employee's job record number.

IUIE Path

Master Catalog > Human Resource Management System > Payroll > Timekeeping > KPME Reports

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. Work Area Id(s): leave blank to search across all work areas, or enter a value(s) to limit the report to one or more work areas. Refer to Kuali Time to identify the work area(s) to search for.
  5. Paygroup Code(s): leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups. Note that selecting a paygroup that does not use Kuali Time (e.g., S12, A10) will result in a failed search.
  6. Earn Code(s): leave blank to search across all earn codes, or enter a value(s) to limit the report to one or more earn codes. Note that selecting an earn code that is not used in Kuali Time (e.g., ABE, REG) will result in a failed search.
  7. Employee Id(s): leave blank to search all employee timesheets, or enter one or more 10-digit ID numbers to limit the report to one or more employees.
  8. Pay Period End Date - Begin Range (MM/DD/YYYY): leave blank to capture the most recent pay period, or enter a specific pay period end date at which to begin the search. To select a specific pay period, enter the same pay end date in this field and the field below.
  9. Pay Period End Date - End Range (MM/DD/YYYY): leave blank to capture the most recent pay period, or enter a specific pay period end date at which to end the search. To select a specific pay period, enter the same pay end date in this field and the field below.
  10. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  11. 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.