IUIE Path: Master Catalog: Departmental Reporting > Payroll Reports-Departmental

General Guidelines/Information:

• Enter your selection criteria in the same format as the examples (dates, department codes).
  
• Anytime a Valid Values button appears, you can click it to choose your criteria.
  
• Be sure to use CAPS when you enter the selection criteria.
  
• The HRMS IUIE information begins with 2003.
  
• Your security access is the same as your payroll voucher profile – you should only be able to see employees in your department.
  
• Information in the IUIE is one business day old. 
  
• You have signed compliance forms agreeing that you will not share this information.  If you are unsure about a particular request, please contact the payroll office.

Payroll Hours Balance BWP Summary: This query produces a list of BWP (PAO/PAU) staff employees and their attendance balances for specific pay period end dates. You can also produce a list of employees with negative balances to find conditions where they have exceeded their balance.

1. Pay Period End Date: Enter the ‘Pay Period End Date’ of last BW payroll.  If you leave blank, the system will select the last pay period end date.
2. Campus Code: Leave blank for ALL, enter your campus code or click on the Valid Values button to select from a list.
3. Department: Enter your chart and 4-character department code or click on the Valid Values button to select from a list.
4. Negative Balances Only: Leave blank for ALL or click the box to find only the employees that have exceeded their balances.
5. Break on Voucher Code (Word Only): Unclick the box if you want an alpha listing with no page break on voucher code.
6. Include Email Address? (Excel Only):  Click on the box if you would like the employee email address included in the excel spreadsheet.
7. Select Output Format: This will default to MS Excel (XLS), but you can change it to Word-RTF, which will produce a Word document that will have page breaks by department code (unless you unclick the previous box).
8. Select Output Destination:  You should select “Send Output to Completed Reports” as this is a long-running report. The report will be in your Completed Reports folder in My Catalog when it’s done running.
9. Click the RUN button.