Skip to main content

Payroll Hours Balance BW1 Summary

Query Fields

  1. Pay Period End Date: Enter the Pay Period End Date of last BW payroll. If you leave blank, the report 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. RC Code: Leave blank for ALL, enter your RC code, or click the Valid Values button to select from a list.
  4. Department Code: Enter your chart and 4-character department code or click on the Valid Values button to select from a list.
  5. Salary Plans: Leave blank for ALL or click the Valid Values button to select from a list.
  6. Negative Balances Only: Leave blank for ALL or click the box to find only the employees that have exceeded their balances.
  7. Break on Voucher Code (Word Only): Unclick the box if you want an alpha listing with no page break on voucher code.
  8. Include Email Address? (Excel Only): Click the box if you would like the employee email address included in the excel output file.
  9. Select Output Format: This will default to Word (with page breaks) but you can change to MS Excel (XLS)
  10. Select Output Destination: You should select Send Output to Completed Reports as this is a long-running report.
  11. Click the RUN button.

Screenshot of Payroll Hours Balance BW1 Summary Query