The Storage Bank Summary Report lists summary totals of all activity for all or selected storage banks. The report allows reporting based on a range a pay periods to summary period details, or a range of years to view the year-based record totals.
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 any extra spaces removed from the front and back of the fields and all fields are separated by a comma.
The Period Summary export file includes the following fields:
-
Employee Number
-
Employee Name
-
Employee Status
-
Bank Number
-
Earnings Indicator
-
Opening Balance Earnings
-
Withdrawal Earnings
-
Earned Earnings
-
Adjustments Earnings
-
Closing Balance Earnings
-
Hours Indicator
-
Opening Balance Hours
-
Withdrawal Hours
-
Earned Hours
-
Adjustments Hours
-
Closing Balance Hours
The Year Summary export file includes the following fields:
-
Employee Number
-
Employee Name
-
Employee Status
-
Bank Year
-
Bank Number
-
Earnings Indicator
-
Opening Balance Earnings
-
Withdrawal Earnings
-
Earned Earnings
-
Adjustments Earnings
-
Closing Balance Earnings
-
Hours Indicator
-
Opening Balance Hours
-
Withdrawal Hours
-
Earned Hours
-
Adjustments Hours
-
Closing Balance Hours
The Period Summary in Bank Table Sequence export file includes the following fields:
-
Employee Number
-
Employee Name
-
Employee Status
-
Bank Number
-
Bank Description
-
Bank Table
-
Earnings Indicator
-
Opening Balance Earnings
-
Withdrawal Earnings
-
Earned Earnings
-
Adjustments Earnings
-
Closing Balance Earnings
-
Hours Indicator
-
Opening Balance Hours
-
Withdrawal Hours
-
Earned Hours
-
Adjustments Hours
-
Closing Balance Hours
Enter Bank Number to Report
-
Enter the storage bank number to report. (This prompt will repeat for additional storage banks.
Report All or Selected Employees
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.
Report Year or Period Summary
-
Enter 'P' to produce the report for pay period information.
-
Enter 'Y' to produce the report based on the bank's year-based records.
When report by 'B'ank and 'P'eriod summary was chosen:
Summarize Bank IN Bank Table Sequence
-
Enter 'N' to report employees without the storage bank table breakdown.
-
Enter 'Y' to have the bank report summarized and sub-totaled by bank table per storage bank. Employees will be reported under the storage bank table currently on the employee. Should an employee have more than one bank table for the same bank, the employee will be reported under the first non-suspended bank table.
When report by 'B'ank was chosen:
Sort Report by Employee Number or Name
-
Enter 'E' to report the employees in employee number sequence.
-
Enter 'N' to report the employees in employee name sequence.
When report by 'E'mployee and 'P'eriod summary were chosen:
Sort by Employee Number, Name or Location
-
Enter 'E' to report the employees in employee number sequence.
-
Enter 'N' to report the 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.
When 'P'eriod summary was chosen:
Enter Starting Pay Period
-
Enter the starting pay period to be reported.
Enter Ending Pay Period
-
Enter the ending pay period to be reported.
When 'Y'ear summary was chosen:
Enter Starting Year to Report
-
Enter the starting year to be reported.
Enter Ending Year to Report
-
Enter the ending year to be reported.
Report using a Minimum, Maximum or None
-
Enter 'N' to omit minimum or maximum selection.
-
Enter 'M' to define a minimum closing balance to be reported.
-
Enter 'X' to define a maximum closing balance to be reported.
When a Minimum or Maximum was chosen:
When a minimum value is entered, employees with a closing balance greater than the minimum will be omitted.
When a maximum value is entered, employees with a closing balance greater than the maximum will be omitted.
NOTE: The maximum can be used to produce an overdrawn report by entering a maximum of 0.00. The minimum value can be used to determine who has reached a certain balance.
Maximum / Minimum Earnings Closing Value
Enter the amount of the maximum or minimum closing value to be reported related to earnings.
Maximum / Minimum Hours Closing Value
Enter the amount of the maximum or minimum closing value to be reported related to hours.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file.
A Pay Period Range Report lists the following:
-
-
The employee number and name
-
Storage bank number
-
Transaction type
-
Opening balance based on starting pay period
-
Withdrawal total for pay period range
-
Earned total for pay period range
-
Adjustment total for pay period range
-
Closing balance based on pay period range
-
A Year Summary Report the report lists the following:
-
-
The employee number and name.
-
Storage bank number
-
Bank year
-
Transaction type
-
Opening balance based on starting pay period
-
Withdrawal total for pay period range
-
Earned total for pay period range
-
Adjustment total for pay period range
-
Closing balance based on pay period range
-