Storage Bank Adjustment Interface

The Storage Bank Adjustment Interface Process supplies the ability to load or adjust storage bank balances through values in a predefined import file. For example, you can generate storage bank adjustments through a spreadsheet and load the adjustments into the Payroll system using this interface process.

The storage bank per employee is required, although the actual storage bank table per employee can be either supplied in the import file or when left empty it will be taken from the employee' s master bank list. When an employee has multiple tables for the storage bank, the first active storage bank table code will be used.

The Storage Bank Table Control Database contains a transaction type, H for hours and/or E for earnings. When the transaction type on the table equals H then this interface will only import the value in the Hours column of the data file. When the transaction type equals E then this interface will only import the Earnings value. When the transaction type equals, HE or EH then this interface will import both values.

This process validates all information per entry. Any rejected entries will be listed on a separate rejection listing along with the reason for the rejection.

NOTE: This process will only run in batch.

Enter Location OF File to be Imported

Enter up to 35 characters of a logical or exact directory location where your import file can be found.
Or, select 'File Upload' to select the file to be imported.

Enter Name of the File to be Imported

Enter the exact name of your import file.
If the 'File Upload' was used, the name will auto populate via the 'File Upload' process.

This process will attempt to access your import file to ensure no problems will occur. Should this process be unable to find or access your file, a message identifying the problem will be displayed and you will be returned to the location prompt.

Enter File's Field Delimiter Tab or Comma

Enter 'T' if the fields in your file are separated by a tab.
Enter 'C' if the fields in your file are separated by a comma.

Enter Default Adjustment Pay Period

Enter a default storage bank adjustment pay period. An adjustment pay period may be included per import records. This default adjustment pay period will be used when no individual adjustment pay period is supplied.
Enter default the pay period where the adjustment records should be generated. You cannot make storage bank adjustments into future pay periods. Adjustments should always be made using a prior pay period. Use look-up for a list of valid calendar periods.

Enter Default Storage Bank Adjustment Type

Enter a default storage bank adjustment type code. An adjustment type code may be included per import records. This default adjustment type will be used when no individual adjustment type is supplied.
Enter 'AJ' to indicate the adjustment should be reported separately as an adjustment to the storage bank.
Enter 'EJ' to indicate this adjustment should be reported as earned or accrued storage bank amount. This adjustment would then be reported together with any storage bank accrual or increments generated from the payroll runs.
Enter 'WJ' to indicate this adjustment should be reported as a storage bank withdrawal. This adjustment would then be reported together with any storage bank withdrawals generated from the payroll runs.
Enter 'PI' to indicate this adjustment should be reported as a Ported In earned or accrued storage bank amount. This adjustment would then be reported together with any storage bank accrual or increments generated from the payroll runs.
Enter 'PO' to indicate this adjustment should be reported as a Ported-Out storage bank withdrawal. This adjustment would then be reported together with any storage bank withdrawals generated from the payroll runs.
Enter 'at' to indicate this adjustment should be reported as an Interest Adjustment storage bank entry. This interest adjustment would then be reported together with interest created by the Storage Bank Interest Calculation process.

Enter Default Storage Bank Adjustment Reason

Enter a default reason for the storage bank adjustment. A reason may also be included per import record. This default reason will be used when no individual reason is supplied.

NOTE: The current date is used on all storage bank adjustment records to assist you in determining when an entry was made.

Process Storage Bank Adjustment or Load

Enter 'A' to indicate the hours and/or earnings from the import file should be added to the existing storage bank balance.
Enter 'L' when the new storage bank balance should equal the hours and/or earnings amount from the import file.

Enforce Storage Bank Table Limits

Enter 'N' when the storage bank table limit should not be considered when adjusting the storage bank balances.
Enter 'Y' when the adjusted storage bank balance should be limited based on the limits defined per storage bank table code. The hours and earnings are limited independently.

Report Only or Process

Enter 'R' to generate just a report. This option only generates the report and rejection listing. It is recommended that a report only be run first, so you are aware of any rejected entries.
Enter 'P' for an update run. The process will generate the storage bank adjustment entries and adjust the employee's master storage bank balances.

The report lists the following:

The employee number and name
The Storage Bank code
The Storage Bank Table code and description
Storage Bank Table Transaction Types H and/or E
Storage Bank Adjustment type per entry
Adjustment Hours and Adjustment Earnings
Import values for Adjustments, and amount of change for Load processing
New or final storage bank hours and earnings balance
Transaction Date
'LT' when the balance was capped by the storage bank table limit(s)
Total number of records processed

The rejection report lists the following:

The employee number and name
The reason the entry was rejected
Total number of records bypassed

Your Storage Bank Import File Must Have the Following Format:

FIELD	Type	MAX	VALUE
1	Employee number	10	Char	Valid employee number for current payroll
2	Storage Bank Code	2	Num	Valid storage bank code
3	Storage Bank Table Code	5	Char	Valid storage bank table code for employee, or empty
4	Storage Bank Hours Value		Num	Hours value, may be empty or zero
5	Storage Bank Earnings Value		Num	Earnings value, may be empty or zero
6	Adjustment reason	20	Char	Optional individual adjustment reason
7	Adjustment pay period	6	Num	Optional individual adjustment pay period
8	Storage Bank Adjustment Type Code	2	Char	Optional individual adjustment type code AJ,EJ, WJ, PI, PO or at
9	Transaction Date	8	Num	Optional override adjustment date (YYYYMMDD). Normally blank and will default to the current date.

The employee number and storage bank code are mandatory fields. All columns are mandatory, except the Transaction Date. If you want to adjust only earnings you must still include an empty hours column.