The Storage Bank Transaction Type Report provides a mechanism to produce a report from the detailed bank transaction file for one or more banks and for selected employees for a range of pay periods. This report allows you to produce the report for selected transaction types. A report of this type could be used to verify the total deposits or total withdrawals against one or more banks for a range of pay periods.
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 export file includes the following fields:
-
Payroll ID code
-
Employee number
-
Employee name
-
Employee's status
-
Storage bank code
-
Storage bank table code
-
Pay period
-
Date
-
Pay code
-
Transaction code
-
Storage bank hours, when applicable
-
Storage bank earnings, when applicable
-
Bank adjustment reason, when applicable
Enter Bank Number to Report
-
Enter a valid storage bank number. This prompt will repeat for multiple bank numbers.
Report All or Selected Employees
Report Employees Terminated/On Leave/Both
Enter Start Period
-
Enter the pay period where the report is to begin.
Enter End Period
-
Enter the last pay period you wish to report on.
Report by Bank or Employee#
-
Enter 'B' to produce report in bank number sequence.
-
Enter 'E' to produce report in employee number sequence.
Transaction Types
The list of valid transaction types:
|
AJ |
Adjustment transaction |
IN |
Increment transaction |
|
EJ |
Earned adjustment |
OI |
One-time increment |
|
WJ |
Withdrawal adjustment |
RI |
Reversal one-time increment |
|
DP |
Deposit to storage bank |
AI |
One-time accrual |
|
AC |
Accrual transaction |
CE |
Earned compressed |
|
WD |
Withdrawal from storage bank |
CW |
Withdrawal compressed |
|
RO |
Rollover transaction |
CJ |
Adjustment compressed |
|
CL |
Clearing transaction |
|
|
|
IT |
Interest transaction |
|
|
|
at |
Interest adjustment |
|
|
Type OF Transaction to Report
-
Enter one or more transaction types to be reported.
-
Enter 'ALL' to include all transaction types on the report.
When report by Bank 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 Employee 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 Location 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 the employees in employee name sequence within location code.
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.
The report lists the following:
-
Employee number and name
-
Storage bank number and bank table code
-
Pay period and date
-
Pay code and transaction code
-
Hours and/or earnings
-
Reason for adjustment, if applicable.