Storage Bank Hours Cost Report

The Storage Bank Hours Cost Report allows you to generate a report listing the employee's hours balance as of a specified pay period along with the cost of the hours using the pay rate from the employee's master function line. This report will give you the total outstanding cost of an hours storage bank. Only positive hour balances will be reported. Employees with a zero-balance storage bank, as of the pay period selected, will be omitted.

Note: There is an option to define a FIXED Payout Rate on Accrual and Increment Storage Bank Tables. That FIXED Payout Rate would be used for this process in place of the employee's function line rate.

The selection criteria value allows the use of the wild card '?' character. The '?' character means that the element value is to be taken from the employee's applicable code to form a new selection code. For example, enter a selection salary grid with the value of SU????, means include employees where on the master function line the salary grid begins with 'SU'.

This process includes the option to maintain multiple sets of stored prompts.

Name the prompt sets by defining a title up to 10 characters, with a 30-character description.

On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.

Select Employee's by Code

• Enter a 2-character code to define the field to use for employee/function line selection.

• Enter 'EM' to select employees based on employee number.

When employee selection is by Employee Number:

Report All or Selected Employees

When employee selection is based on any field other than employee number, you are prompted to Enter one or more of that code or value. You may Enter valid codes or any combination using the wild card '?'. The wild card is not a valid entry for numeric fields such as hours. The list of values entered will determine if an employee's function line will be selected.

Report Hours Balance as of Pay Period

• Enter the pay period to be used for determining the storage bank hours balance to be reported. Enter the current pay period to report the employee's current balance.

Enter hours Storage Bank to report

• Enter a valid storage bank code to be reported. The storage bank must be defined to have Hours.

Enter Banks Table to report

• Enter the storage bank table code to be used along with the storage bank code entered above.

You can Enter a specific storage bank table code or leave the storage bank table code blank and the system will load the bank table code with the wild card code '?????'.

When the bank table code has been defined as '?????' then all tables for the given storage bank will be reported.

Omit negative hours balances

• Enter 'Y' to omit entries when the hours have a negative balance.

• Enter 'N' to include those entries with a negative hours balance.

Select Active/Terminated/On Leave/On Leave with Benefits/Full Employees

The employee selection by employee status allows you to select one or more employee status's to be included.

• Enter 'A' to select only active employees.

• Enter 'T' to select Terminated employees.

• Enter 'O' to select On Leave employees.

• Enter 'B' to select On Leave with Benefits employees.

• Enter 'F' to select all employees.

The report lists the following:

• The employee number and name.

• The storage bank code, table code and table description.

• Storage bank hours.

• The employee's hours rate, as of the master function line.

• The cost of hours, bank hours times pay rate.