Storage Bank Report

The Storage Bank Report lists employee's storage bank balances for specific or all storage bank codes. This report can be used to identify all employees currently on a specific bank or list all employees that do not have a specific storage bank. This report also offers a feature to list only those employees with suspended storage banks.

This report includes the option to export the employee's storage bank code and opening balances.

Enter Bank Number to Report

• Enter the storage bank number to report. This prompt will repeat for additional storage banks.

Enter the Bank Table Code

Enter the storage bank table code to report. This prompt will repeat for additional storage bank tables for the same storage bank.

When specific storage banks were selected for reporting:

Include / Exclude Employees with Selected Banks

• Enter 'I' to report employees that have the selected storage banks.

• Enter 'E' to report those employees that do not have the selected storage banks.

Report Suspended Banks Only

• Enter 'N' to report employees regardless of bank cycle codes.

• Enter 'Y' to produce a report listing those employees who have the override bank cycle code set to suspended, '*'. This option applies only to the individual employee bank cycle code.

Report negative on-line balances Only

• Enter 'N' to report employees regardless of the on-line balance of the banks.

• Enter 'Y' to produce a report listing only those employees who have a negative on-line hours and/or earnings balance. The hours and/or earnings are verified based on the setting of the Transaction field per bank table code. When both Hours and Earnings are active then both the Hours and Earnings on-line balances must be negative for the employee to be reported. 

Report Employees Terminated / On Leave / On Leave with Benefits

Report by Bank or Employee#

• Enter 'E' to produce the report in employee order. This option will produce a report listing the employee and the storage banks.

• Enter 'B' to produce the report in storage bank order. This option will list the storage bank and the selected employees that have the storage bank.

When report by 'B'ank was chosen:

Sort Report by Employee Number or Name

• Enter 'E' to report employees in employee number sequence.

• Enter 'N' to report employees in employee name sequence.

When report by 'E'mployee was chosen:

Sort by Employee Number, Name or Location

• Enter 'E' to report employees in employee number sequence.

• Enter 'N' to report employees in employee name sequence.

• Enter 'L' to generate the report sequenced based on employee's location code.

When sort by 'L'ocation code was chosen:

Sort Employees by Employee Number or Name

• Enter 'E' to report the employees in employee number sequence within location code.

• Enter 'N' to report employees in employee name sequence within location code.

Select Employees by Code

• Enter a 2-character code to define the field to use for employee selection. Selection is based on the master function line.

When Employee Selection IS by Employee Number:

Report All or Selected Employees

Include generation of CSV Export File

• Enter 'N' to omit the export file.

• Enter 'Y' to include the generation of the export file. The fields included on the export file are detailed below.

The report lists the following:

• Employee number and name

• Employee status description, if applicable

• Storage bank code and description

• Storage bank table code and description

• Employees individual bank cycle code per bank table

• Override date or override storage bank code

• Online hours and/or earnings, whichever is applicable

• Opening hours and/or earnings, whichever is applicable

• Employee Location

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have extra spaces removed from front and back of the fields and all fields are separated by a comma. The order of the export files matches the order of the selected report. The columns of the export file are defined in the same order required for the Storage Bank Adjustment Interface to allow for ease of exporting, adjusting and re importing the storage bank values. The export file containing the following fields: