| Query Name | Description | Report Limit(s) & Security |
| Excessive Absenteeism | This will report excessive absenteeism for Bargaining Unit and Non-Bargaining Unit employees. The query compares an employee’s calculated standard hours for seven days (ie: 8 hours x 7 days = 56 hours) and the total of an employee’s actual hours for Sick Pay, Reduced Sick Pay, Sick No Pay, and Absent No Pay for the Pay End Date(s) requested. A report is created if an employee’s total actual hours exceeds the employee’s calculated standard hours. | Limits: Pay End Date – Set to between two dates, enter in start and end pay end dates.
Department Number – Enter in one or more departments, or the higher level area (ie. 312) to get all departments beginning with that value. Security: This query has row-level security. Limited viewing of records is based on the administrator’s PeopleSoft department security. |
| FWS Awards | This query returns a list of all Federal Work Study awarded to students based upon a ser of user-specified limits. All awards are granted to each student for the fiscal year (July to June) and will be used based upon the Payroll processing schedule for each fiscal year. | Limits: Department Number – Enter in one or more departments, or the higher level area (ie. 312) to get all departments beginning with that value.
Emplid – Enter the emplid (SUID) of the individual(s), or click on Ignore, to retrieve all students for the specified department(s). Security: None. All student can be selected. |
| Payroll Report – Budget Manager EIS |
This query retrieves all earnings for a department and/or employee requested in the limits for a specific range of payperiods within a fiscal year. |
Limits:Fiscal Year – Enter the 4 digit year (2009)
Home Department – Enter in the 5 digit or 9 digit department number. Account – If desired, enter an account number. Emplid – Enter the emplid (SUID) of the employee, or leave this blank, to retrieve all employees for the specified department(s). Pay End Dates – Enter the start and end pay end dates. Security: This query has row-level security based upon the employees home department matching the budget managers PeopleSoft departmental security. Budget Managers should request access to this query by contacting the Director of Payroll. |
| Semi Time Input |
This query returns the information about time input for semimonthly employees. In can be run for employees in a single department or an area |
Limits: Pay End Date – Set to between two dates, enter in start and end pay end dates.Hours per Day – Default is Not equal to zero.
Department Number – Enter in one or more departments, or the higher level area (ie. 312) to get all departments beginning with that value. Emplid – Enter the emplid (SUID) of the employee, or leave this blank, to retrieve all employees for the specified department(s). Time Reporting Codes – Ignore to select all codes or select a specific code for the employee. Security: This query has row-level security. Limited viewing of records is based on the administrator’s PeopleSoft department security. |
| Weekly Time Input | This query returns the information about time input for weekly employees. In can be run for employees in a single department or an area | Limits: Department Number – Enter in one or more departments, or the higher level area (ie. 312) to get all departments beginning with that value.
Pay End Date – Set to between two dates, enter in start and end pay end dates. Emplid – Enter the emplid (SUID) of the employee, or leave this blank, to retrieve all employees for the specified department(s). Time Reporting Codes – Ignore to select all codes or select a specific code for the employee. Security: This query has row-level security. Limited viewing of records is based on the administrator’s PeopleSoft department security. |
| Where Paycheck-Advice was Sent |
This query will allow you to find where a check or advice was mailed for an employee or group of employees that were paid. Once the results have been retrieved, the report will show you for each employee: the paycheck issue date, type of form (check or advice), if the employee has elected to suppress the printing of their advice, and the department name and campus address where the check or advice was mailed. |
Limits: Paycheck Issue Date – Enter the specific pay date the employee or employyes were paid (mm/dd/yyyy).Employee SUID – Enter the emplid (SUID) of the employee, or leave this blank, to retrieve all employees for the specified department(s).
Department Number – Enter in a department number, or the higher level area (ie. 312) to get all departments beginning with that value. Leave this blank if selecting a specific employee. Security: None. All employees can be selected. |