Storage Bank Table Control | PowerSchool Atrieve

The Storage Bank Table Control is used to define one or multiple tables for a storage bank. Each storage bank table may be defined with a different percentage, amounts and limits. Defining multiple storage bank tables for a storage bank allows a specific storage bank to be used for a specific purpose (e.g.: holiday leave) with the various percentages needed for the different requirements defined per bank table. An employee will remain on the same storage bank but move up through the storage bank table levels as the increment requirements are met.

Storage bank tables can be set up to automatically increment (move up to the next bank table) through the multiple levels of entitlement. (Refer to the process Employee Bank Table Increment.) For example, storage bank tables can be defined to represent the different levels of holiday leave entitlement starting with 4% for the first year, 6% for the next seven years etc. Each storage bank table defines the date when the table level increment is to take place (Table End Point), the number of years required before the increment will take place (Table End Years) and which employee date to use in the determination of the employee's years of service (Table End Dates).

Storage bank tables can also be set up to automatically increment to the next bank table level based on the balance of another predefined storage bank. With this method you can have an employee increment to the next table level when they have accumulated a specific number of hours or earnings in a specified storage bank. This option requires the definition of the Table Value Banks, Table End Hours and/or Table End Earnings.

Multiple storage bank table entries may be defined with no incrementing implications. Storage bank tables defined without a Table End Point, Table End Years or Table End Dates will have no incrementing implications.

NOTE: Negative Bank Balance Disallowed.

Storage bank tables can be defined to disallow negative storage balances caused by over withdrawing from a storage bank. During timesheet entry a timesheet will be rejected if the timesheet will cause a storage bank to be over withdrawn. During the running of the payroll stream the system will NOT block storage bank withdrawal entries from being processed but the system will generate the following warning message to inform you the employee's storage bank balance has been overdrawn.

Warning: Bank 20 Table 00010 will be Negative on employee # Processing Withdrawal HRS hours AMT dollars

This is a Warning not an error message, the transaction will still be processed. The employee's storage bank transactions should be reviewed.

A situation can arise where the employee's storage bank balance is enough to take a withdrawal during timesheet entry but not at the time the payroll stream attempts to do the withdrawal. A storage bank balance can be reduced due to negative accrual transactions before the timesheet entry withdrawal is processed. Negative timesheet entries where the pay code is applicable for a storage bank will generate a negative accrual, thus reducing the storage bank balance.

For situations like this the employee's transactions in date order should be reviewed.

Bank Code [Ø1-99]

Enter the predefined storage bank code under which this bank table will be defined.

Table Code [#####]

Enter a 5 alphanumeric character storage bank table code. By default, the system will zero fill the front of the bank table codes. When a table code of '1' is entered the system will automatically bring up bank table code '00001'. This method of bank table code assignment makes bank table access easier.

When using either of the automatic bank table increment methods the increment to the next bank table is based on the value of the bank table code.

Description

Enter up to 30 alphanumeric characters to describe the bank table. The storage bank system uses the bank table description in most places.

Table End Type.

Enter 'Y' if the automatic table level increments are to be defined based on years of service.
Enter 'A' if the automatic table level increments are to be defined based on the accumulated bank balance of another unrelated storage bank.

Transactions

Enter 'H' to accumulate hourly totals.
Enter 'E' to accumulate earnings totals.
Enter 'HE' or 'EH' to accumulate both hours and earnings totals.

Days bank tables can only accumulate hours.

Pay bank tables can only pay out earnings.

When Table End Type is 'A'ccumulation:

Table End Hours

Enter the total hours that must be accumulated before the employee will automatically increment to the next bank table.

Table Value Banks

Enter up to 10 storage bank codes separated by a comma.

The storage banks list defines the balance of hours or earnings used during the table increment process. These are the storage banks that hold the accumulation of hours or earnings which define the employee eligibility for table level increment.

The first bank in the list found on an employee will be used for the table level increment verification.

An override bank can also be defined per employee's bank table that will specify exactly which bank will be used for increment verification.

When Table End Type is 'Y' ears:

Table End Point

Enter either a valid date (YYYYMMDD) or just a month and day of when the auto increments are to take place. When a full date is entered, the increment will only apply on that specific date.

When only a month and day are entered the increment is applicable for any year on that month and day.

Enter a year 'YYYY' or '????' followed by %%%% (e.g. ????%%%% or 1996%%%%) to indicate that the month and the day of the increment will be defined at the time the auto increment process is run. The year can be a fixed year or set to the wild card which indicates the current year.

Table End Dates

Enter the date codes in the order of priority separated by a comma. The employees date will be defined by the first date found following the list of date codes.

An override date can also be defined per employee's bank table. The override date will take precedence.

Date Codes:

H - Current Hire Date
- Original Hire Date
S - Seniority Date
I - Increment Date
V - Vacation Date

Accrual Storage Bank Table - (1^st Screen)

When Table End Type is 'A'ccumulation:

Table End Earnings

Enter the total earnings that must be accumulated before the employee will automatically increment to the next bank table.

When Table End Type is 'Y' ears:

Table End Years

Enter the number of years an employee must be at this table level before an increment will take place. The employees' number of years is calculated using the employees date from the table end dates compared against the table end point date.

Hours Percentage

Enter the percentage of hours to be accrued. (Enter 7.00 for 7%.)

Hours Table Limit

Enter the maximum number of hours to be accrued. The limit applies only to accruals and increments, not deposits or manual adjustments. A zero or empty limit implies no limit. This limit can optionally be prorated by the employees FTE(s).

Increment Hours Level

This field is used in conjunction with the Salary Grid Increment By Storage Bank process.

Enter the number of hours an employee's storage bank must accumulate to be eligible for a salary grid increment. This field would only apply if Storage Bank Table Transactions is set to accumulate hours.

Hours Year ACCR Limit

Enter the maximum number of hours to be accrued for the given year. The year is defined by the range of pay periods defined on the Storage Bank Control database for this storage bank. Only 'AC' accrual, 'IN' increment and 'EJ' earned adjustment entry values will be included when determining the total history accrued so far'

This limit will be disabled when no Year Limit Period range is defined on the Storage Bank Control record. This limit can optionally be prorated by the employee's FTE(s).

Prorate Hours Limit

Enter 'N' when the hours limit is not applicable or when the hours limit should not be prorated.

Prorating applies to both the Hours Table Limit and Hours Year Accr Limit when applicable.

Enter 'F' when the hours limit should be prorated on the total FTE from all active function lines.
Enter 'M' when the hours limit should be prorated on the FTE from the employee's master function line.

Accrual I/E Master Table

Enter the Storage Bank Table code that will be the master value for the Accrual Hours and Accrual Earnings I/E lists for this bank. By defining one master table code you can maintain all accrual I/E lists for a set of tables per bank by changing just the master table code's list and the system will automatically update the accrual I/E lists for all other storage bank table codes (for the same bank code) that are defined with that master table code.

Accrual Hours

Enter the pay codes which are to be included or excluded in the hour's calculation.
Enter I/##,##,##, where the ## are the pay codes to be included as eligible hours for this storage bank calculation.
or (if the list is shorter):
Enter E/##,##,##, where the ## are the pay codes to be excluded from the hours calculation, all other pay codes will be included.
Enter 'I/WD', - this special feature allows the Accrual Storage Bank hours source to pull from the Working Days in the applicable pay period Payroll Calendar in place of the regular function line time period. Employees must have an active function line to trigger the 'Working Days' to be processed. The Working Days are reduced by the employees combined active function line Percentage Employed. The intent of this feature is for sick leave accrual calculation based on the employees Teaching days per month. Additional pay codes may be included on the line e.g. I/WD,25,30,etc but the WD must be the first item on the list. With this Working Days feature (only) you can also enter a pay code with the minus sign, for example I/WD,-15,25,30, The -15 means the hours/days of that pay code will be reversed (multiplied by -1) before being applied to the accrual. When a positive + pay code hours/days are to reduce the accrual, including the pay code with the minus sign causes the hours/days to be subtracted from the Working Days affecting the final accrual value.

Accrual Earns

Enter the pay codes which are to be included or excluded in the earnings calculation.
Enter I/##,##,##, where the ## are the pay codes to be included as eligible earnings for this storage bank calculation.
or (if the list is shorter):
Enter E/##,##,##, where the ## are the pay codes to be excluded from the earnings calculation, all other pay codes will be included.

Bank Cycle

Leave the storage bank cycle code blank when the storage bank is to be calculated whenever eligible hours/earnings are available.

Enter a predefined storage bank cycle code which will control when the storage bank will be calculated.

A bank cycle code of '*' indicates the storage bank table is suspended.

The employee's individual bank cycle code takes precedence.

Minimum Hours Required

Enter the number of hours an employee must work, per pay period, in order to be eligible to receive an accrual. The pay codes defined under the Accrual Hours list will determine the hours to be included/excluded for this total.

Earn Percentage

Enter the percentage of earnings to be accrued. Enter 7.00 for 7%.

Earnings Table Limit

Enter the maximum number of earnings to be accrued. The limit applies only to accruals and increments not deposits. A zero or empty limit implies no limit. This limit can optionally be prorated by the employee's FTE(s).

Increment Earns Level

This field is used in conjunction with the Salary Grid Increment By Storage Bank process. <CR> if this feature is not used for this storage bank table.

Enter the total earnings an employee's storage bank must accumulate to be eligible for a salary grid increment. This field would only apply if the storage bank table transactions is set to accumulate earnings.

Earnings Year ACCR Limit

Enter the maximum number of earnings to be accrued for the given year. The year is defined by the range of pay periods defined on the Storage Bank Control database for this storage bank. Only 'AC' accrual, 'IN' increment and 'EJ' earned adjustment entry values will be included when determining the total history accrued so far.

This limit will be disabled when no Year Limit Period range is defined on the Storage Bank Control record. This limit can optionally be prorated by the employee's FTE(s).

Prorate Earns Limit

Enter 'N' when the earnings limit is not applicable or when the earnings limit should not be prorated.

Prorating applies to both the Earnings Table Limit and Earnings Year Accr Limit when applicable.

Enter 'F' when the earnings limit should be prorated on the total FTE from all active function lines.
Enter 'M' when the earnings limit should be prorated on the FTE from the employee's master function line.

Enforce Limit on Deposits

Enter 'N' when the storage bank table limit does not apply to storage bank deposits. This is the default.

Enter 'Y' to enforce the storage bank table limit when storage bank deposits are processed through timesheet entry/interface. The timesheet will be rejected if the value to be deposited will cause the employee's storage bank balance to exceed the storage bank table limit.

Accrual Storage Bank Table - (2^nd screen)

Rollover Bank

Enter a rollover storage bank code. When a storage bank is cleared the hours/earnings can be rolled into another storage bank. When the rollover bank is left blank the clearing of a storage bank will zero the storage bank balances.

The rollover process takes place before the calculation and pay out of storage banks for the period defined by the clearing.

Clearing of a storage bank is defined in the payroll calendar for the appropriate pay period.

When a Rollover Bank is entered:

Enforce bank limit

Enter 'N' to have the full bank balances rolled over.
Enter 'Y' to have the rollover bank's limits applied when the rollover takes place. When the rollover bank's limits are to be enforced, the full hours and/or earnings will be rolled over then an adjustment rollover entry will be created to reduce the rollover bank's balances according to the bank limit values. The reducing rollover entry will be generated with a reason of 'ROLL OVER LIMITED'.

Rollover Negative Balance

Enter 'Y' to have the bank balance rollover when the balance is negative.
Enter 'N' to omit rolling over the bank balance when the balance is negative. The balance will remain in the bank.
Enter 'C' to omit rolling over the bank balance when the balance is negative but still clear the negative balance.

Print Balances

Enter 'Y' if the storage bank table balance is to appear on the cheque and/or earnings statement. Suspended storage bank tables will not be included.
Enter 'N' to block the printing of the storage bank table balance.
Enter 'S' if the storage bank table balance is to be printed even if the storage bank table is suspended.

Print Used

The days/hours used can only be printed when this storage bank table is set to print, see above.

Enter 'N' when the days/hours used or withdrawals from this storage bank are not to be print along with the other storage bank fields.
Enter 'Y' to have the employee's storage bank withdrawals printed on the User Defined Earning Statement. The code used must be defined to print along with the other storage bank fields on the User Defined Earning Statement. The employee's current period withdrawals (WD) as well as withdrawal adjustments (WJ) entered since the last pay statement will be included and reports on the employee's earning statement.

Negative Balance

Enter 'Y' is a storage bank can go negative during storage bank withdrawal.
Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.
Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative. The timesheet entry will still be processed.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

NOTE: Storage bank table set to 'W'arn or 'Y' es:

Timesheet entries and bank withdrawals are sequential, they happen one at a time. The system will allow a single entry to put a storage bank into a negative balance. For example, if the on-line balance shows as negative after the first entry has come through, for any subsequent entries, it will look to other storage banks listed on the pay code to see if it can withdraw from elsewhere. If no other option is available, only then will it allow the storage bank balance to continue to go further into the negative.

Hours Decimal Place

Hours will carry up to four decimals of precision.

Enter a value from 1 to 4 to indicate the precision to use during the hours calculations.

Pool Bank Code

This prompt provides the ability to extract a portion of each employee's storage bank increment or accrual and allocate the amount to the global storage bank. The common application of this option is in situations where each employee contributes a percentage of their sick leave to a central sick leave bank. This is most common in union contract and normally this type of storage bank is managed by the union and requests for access to the pool benefits are made to the union.

Pool Bank Table

Enter the global pool bank table codes to be used on this storage bank table. Each storage bank table may use a different global pool bank table, or all storage bank tables may use the same global table.

Pool Bank Limit

Enter 'N' to indicate the global pool bank will not regard the storage bank table limit on this bank table. The global pool bank will continue to receive an increment/accrual percentage after the employee has reached the bank table limit.
Enter 'Y' to indicate the global pool bank should regard the bank table limit on this bank table. The global pool bank will not receive an increase once an employee's bank limit has been reached.

Pool Bank %

Enter the percentage of the employee's allocation which is to be contributed to the global pool bank. This amount is deducted from the employee's allocation and is transferred to the storage bank number identified in the pool bank code field.
Enter 20.0000 for 20%.

Fixed Payout Rate

This fixed payout rate can be applied for the running of the Storage Bank Hours Pay Out Process and the Storage Bank Hours Cost Report only.

Enter an override rate for this storage bank table. When the Storage Bank Hours Pay Out Process or the Storage Bank Hours Cost Report is run, employees with this accrual bank table will use the defined fixed rate instead of the employee's function line rate.

Pay Out Pay Code

Accrual earnings can be set to be paid out. Enter a pay code to be used when the storage bank earnings are to be paid out.

Accrual Storage Banks/Tables are defined to be paid out in the payroll calendar for the appropriate pay period.

Pay Out Current ACC

When an earnings storage bank has been defined to be paid out, should the payout pay periods accrual earnings also be paid out.

Enter 'Y' to include the payout pay periods accrued earnings.
Enter 'N' to store the payout pay periods accrued earnings and only pay out the earnings up to that pay period.

Pay Out Negatives

Enter 'N' to block negative balances from being paid out/recouped.
Enter 'Y' to pay out negative earnings which will reduce the employee's cheque.

GL Liability Account

Accrual earnings can be set up to be costed at the time of deposit.

Enter a liability GL account if the accrual earnings are to be costed. Also refer to the banking phase of the cost center database when costing is to be done.

GL Expense Account

The GL Liability Account must be defined for accrual earnings to be costed.

The accrual expense will follow the GL account of the earnings that generate the accrual unless an expense GL is entered here. This expense GL account may contain the wildcard character with all wildcarding going back against the earnings GL account that created the accrual.

Increment Storage Bank Table (1^st Screen)

When Table End Type is 'A'ccumulation:

Table End Earnings

Enter the total earnings that must be accumulated before the employee will automatically increment to the next bank table.

When Table End Type is 'Y' EARS:

Table End Years

Enter the number of years an employee must be at this table level before an increment will take place. The employees' number of years is calculated using the employees date from the table end dates compared against the table end point date.

Hours Increment

Enter the hours increment value.

Hours Table Limit

Enter the maximum number of hours to be stored. The limit applies only to accruals and increments, not deposits. A zero or empty limit implies no limit. This limit can optionally be prorated by the employee's FTE(s).

Increment Hours Level

Used in conjunction with the Salary Grid Increment By Storage Bank process.

Enter the number of hours an employee's storage bank must accumulate to be eligible for a salary grid increment. This field would only apply if the storage bank table transactions is set to accumulate hours.

Hours Year ACCR Limit

Enter the maximum number of hours to be accumulated for the given year. The year is defined by the range of pay periods defined on the Storage Bank Control database for this storage bank. Only 'AC' accrual, 'IN' increment and 'EJ' earned adjustment entry values will be included when determining the total history accrued so far.

This limit will be disabled when no Year Limit Period range is defined on the Storage Bank Control record. This limit can optionally be prorated by the employee's FTE(s).

Prorate HRS INC by % / FTE

Increment storage banks normally give every employee in the payroll run the full increment with the full hours limit. This option provides the ability to give a prorated portion of the increment to employees based on either the number of hours worked for a pay period compared against a base hours value or based on the employees total FTE or master function line FTE. The limit can also be prorated.

Enter 'N' when the hours increment should not be prorated.
Enter 'Y' if you want the hours increment prorated based on the total number of hours worked in the pay period compared to the %Hour Base Hours.
Enter 'F' when the hours increment is to be prorated based on the total FTE for all active function lines.
Enter 'M' when the hours increment is to be prorated based on the master function line FTE.

Prorate HRS INC / Limit

Enter 'I' when only the hours increment value should be prorated.
Enter 'L' when only the hours limit value should be prorated. Prorating applies to both the Hours Table Limit and Hours Year Accr Limit when applicable.
Enter 'B' when both the hours increment value and the hours limit value should be prorated.

%Hour Base Hours

When increment by % of hours has been selected, you must provide the total number of hours that represents the base. These hours are used to calculate a percentage. The employee's hours of work are compared to the base hours and the percentage the employee has worked is calculated. This percentage is then used to adjust the full increment.

Accrual I/E Master Table

This field only applies when the storage bank has been set to prorate the increment based on hours worked and the Accrual Hours list will be entered.

Enter the Storage Bank Table code that will be the master value for the Accrual Hours I/E lists for this bank. By defining one master table code you can maintain all accrual I/E lists for a set of tables per bank by changing just the master table code's list and the system will automatically update the accrual I/E lists for all other storage bank table codes (for the same bank code) that are defined with that master table code.

Accrual Hours

When the storage bank has been set to prorate the increment based on hours worked, the pay codes listed here are for defining eligible hours.

Enter I/##,##,##, where the ## are the pay codes to be included as eligible hours for this storage bank calculation.
or (if the list is shorter):
Enter E/##,##,##, where ## are the pay codes to exclude from the hours calculation. All other pay codes will be included.

Bank Cycle

Leave the storage bank cycle code blank when the storage bank is to be calculated when ever eligible hours/earnings are available.

Enter a pre-defined storage bank cycle code that will control when the storage bank will be calculated.

A bank cycle code of '*' indicates the storage bank table is suspended.

The employee's individual bank cycle code takes precedence.

All/Paid Employees

Enter 'A' if the storage bank value is to be given to all active employees.
Enter 'P' if the storage bank value is to be given only to employees who received pay in the payroll run.

Earnings Increment

Enter the earnings increment value.

Earnings Table Limit

Enter the maximum earnings to be stored. The limit applies only to accruals and increments, not to deposits. A zero or empty limit implies no limit. This limit can optionally be prorated by the employee's FTE(s).

Increment Earns Level

This field is used in conjunction with the Salary Grid Increment By Storage Bank process.

Enter the total earnings an employee's storage bank must accumulate to be eligible for a salary grid increment. This field would only apply if the storage bank table transactions is set to accumulate earnings.

Earnings Year ACCR Limit

Enter the maximum number of earnings to be accrued for the given year. The year is defined by the range of pay periods defined on the Storage Bank Control database for this storage bank. Only 'AC' accrual, 'IN' increment and 'EJ' earned adjustment entry values will be included when determining the total history accrued so far.

This limit will be disabled when no Year Limit Period range is defined on the Storage Bank Control record. This limit can optionally be prorated by the employee's FTE(s).

Prorate Earn INC by % / FTE

The earning increment value may be prorated per employee based on the employee's FTE.

Enter 'N' when the earnings increment should not be prorated.
Enter 'F' when the earnings increment is to be prorated based on the total FTE for all active function lines.
Enter 'M' when the earnings increment is to be prorated based on the master function line FTE.

Prorate Earn INC / Limit

This field will not apply if the Prorate Earn INC by FTE is not active.

Enter 'I' when only the earnings increment value should be prorated.
Enter 'L' when only the earnings limit value should be prorated. Prorating applies to both the Earnings Table Limit and Earnings Year Accr Limit when applicable.
Enter 'B' when both the earnings increment value and the earnings limit value should be prorated.

Enforce Limit ON Deposits

Enter 'N' when the storage bank table limit does not apply to storage bank deposits. This is the default.
Enter 'Y' to enforce the storage bank table limit when storage bank deposits are processed through timesheet entry/interface. The timesheet will be rejected if the value to be deposited will cause the employee's storage bank balance to exceed the storage bank table limit.

Increment Storage Bank Table (2^nd Screen)

Rollover Bank

Enter a rollover storage bank code. When a storage bank is cleared the hours/earnings can be rolled into another storage bank.

When the rollover bank is left blank the clearing of a storage bank will zero the storage bank balances.

The rollover process takes place before the calculation and pay out of storage banks for the period defined by the clearing.

Clearing of a storage bank is defined in the payroll calendar for the appropriate pay period.

When A Rollover Bank is Entered:

Enforce Bank Limit

Enter 'N' to have the full bank balances rolled over.
Enter 'Y' to have the rollover bank's limits be applied when the rollover takes place. When the rollover bank's limits are to be enforced, the full hours and/or earnings will be rolled over then an adjustment rollover entry will be created to reduce the rollover bank's balances according to the bank limit values. The reducing rollover entry will be generated with a reason of 'ROLL OVER LIMITED'.

Rollover Negative Balance

Enter 'Y' to have the bank balance rollover when the balance is negative.
Enter 'N' to omit rolling over the bank balance when the balance is negative. The balance will remain in the bank.
Enter 'C' to omit rolling over the bank balance when the balance is negative but still clear the negative balance.

Print Balances

Enter 'Y' if the storage bank table balance is to appear on the cheque and/or earnings statement. Suspended storage bank tables will not be included.
Enter 'N' to block the printing of the storage bank table balance.
Enter 'S' if the storage bank table balance is to be printed even if the storage bank table is suspended.

Print Used

The Used can only be printed when this storage bank table is set to print, see above.

Enter 'N' when the Used or withdrawals from this storage bank are not to be printed along with the other storage bank fields.
Enter 'Y' to have the employee's storage bank withdrawals printed on the User Defined Earning Statement. The code used must be defined to print along with the other storage bank fields on the User Defined Earning Statement. The employee's current period withdrawals (WD) as well as withdrawal adjustments (WJ) entered since the last pay statement will be included and reports on the employee's earning statement.

Negative Balance

Enter 'Y' if a storage bank can go negative during storage bank withdrawal.
Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.
Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative. The timesheet entry will still be processed.

The negative balance control will also be applied to negative storage bank deposits.

NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

NOTE: Storage bank table set to 'W'arn or 'Y' es:

Hours Decimal Place

Hours will carry up to four decimals of precision.

Enter a value from 1 to 4 to indicate the precision to be used during the hours calculations.

Pool Bank Code

Enter a valid global pool bank code.

This prompt provides the ability to extract a portion of each employee's storage bank increment or accrual and allocate the amount to the global storage bank. The common application of this option is in situations where each employee contributes a percentage of their sick leave to a central sick leave. This is most common in union contract and normally this type of storage bank is managed by the union and requests for access to the pool benefits are made to the union.

Pool Bank Table

Enter the global pool bank table codes to be used on this storage bank table. Each storage bank table may use a different global pool bank table, or all storage bank tables may use the same global table.

Pool Bank Limit

Enter 'N' to indicate the global pool bank will not regard the storage bank table limit on this bank table. The global pool bank will continue to receive an increment/accrual percentage after the employee has reached the bank table limit.
Enter 'Y' to indicate the global pool bank should regard the bank table limit on this bank table. The global pool bank will not receive an increase once an employee's bank limit has been reached.

Pool Bank %

Enter the percentage of the employee's allocation that is to be contributed to the global pool bank. This amount is deducted from the employee's allocation and transferred to the storage bank number identified in the pool bank code field.
Enter 20.0000 for 20%.

Fixed Payout Rate

This fixed payout rate can be applied for the running of the Storage Bank Hours Pay Out Process and the Storage Bank Hours Cost Report only.

Enter an override rate for this storage bank table. When the Storage Bank Hours Pay Out Process or the Storage Bank Hours Cost Report is run, employees with this increment bank table will use the defined fixed rate instead of the employee's function line rate.

Pay Bank Storage Bank Table

When Table End Type is 'A'CCUMULATION:

Table End Earnings

Enter the total earnings that must be accumulated before the employee will automatically increment to the next bank table.

When Table End Type is 'Y' EARS:

Table End Years

Enter the number of years an employee must be at this table level before an increment will take place. The employees number of years is calculated using the employees date from the table end dates compared against the table end point date.

Enforce Zero Pay

Enter 'N' when this Pay bank is to payout a percentage of earnings or a flat amount.
Enter 'Y' to define the special Enforce Zero Pay bank. This special type of Pay bank was designed to reverse out pennies of gross earnings caused by rounding differences. When an employee's pay is completely reversed out through multiple timesheets, the results sometimes cause a difference of pennies in rounding. This special Pay bank will trap and reverse out those pennies ensuring a zero gross pay for the employee. The reversal is processed through the pay code defined on the Pay bank. The Enforce Pay Amount field is used by this Pay bank type to determine what value should be reversed.

This special pay bank may be added to the employee's storage bank master or defined under field 68=Global Pay Bank for Zero Gross under 4,1,5 User Specific Parameters Profile. When the Pay bank is defined under the profile in field 68, this is a global setting which makes the pay bank available to all employees on the payroll with the Pay bank being attached to their master banks.

Earns Percentage

Enter the pay bank percentage. Enter 7.00 for 7%.

Pay Code

Enter a pay code to be used for paying the calculated pay bank earnings.

Accrual I/E Master Table

Enter the Storage Bank Table code that will be the master value for the Accrual Earnings I/E lists for this bank. By defining one master table code you can maintain all accrual I/E lists for a set of tables per bank by changing just the master table code's list and the system will automatically update the accrual I/E lists for all other storage bank table codes (for the same bank code) that are defined with that master table code.

Accrual Earns

Enter a list of pay codes to include or exclude for determining the eligible earnings.
Enter I/##,##,##, where the ## are the pay codes to be included as eligible earnings for this pay bank calculation.
or (if the list is shorter):
Enter E/##,##,##, where the ## are the pay codes to be excluded from the earnings calculation, all other pay codes will be included.

Bank Cycle

Leave the storage bank cycle code blank when the storage bank is to be calculated whenever eligible hours/earnings are available.

Enter a pre-defined storage bank cycle code which will control when the storage bank will be calculated.

A bank cycle code of '*' indicates the storage bank table is suspended.

The employee's individual bank cycle code takes precedence.

When Table End Type is 'Y' ears:

Flat Earnings amount

This field is only accessible/applicable when no Earns Percentage is entered.

Enter a flat amount to be paid out per pay period.

Enforce Pay Amount

This field is only accessible/applicable if the Pay Bank is defined as Enforce Zero Pay = Yes.

Enter the amount to be reversed, for example .05. When an employee's gross pay is less than or equal to the amount defined, the Pay bank will generate an entry to reverse out the amount, thus creating a zero gross pay. The employee's amount may be + or – of this amount, so -.05 to .05 will be reversed out when this amount field is defined as .05.

Flat is Hourly Rate

This field is only accessible/applicable when no Earns Percentage is entered.

Enter 'N' when the flat amount to be paid out is a one-time payment per pay period.
Enter 'Y' when the flat amount defined is an hourly amount. The hourly amount multiplied by the number of hours will be paid out. The accumulated hours for this pay bank are as per the Accruals Earns list of pay codes.

Prorate AMT by FTE Prorate AMT by FTE

Enter 'Y' when the Flat Earnings Amount is to be prorated by the employees FTE.
Enter 'N' when the Flat Earnings Amount should not be prorated.

Active/Paid EMPS

Enter 'A' to pay the Flat Earnings Amount to all active employees. Active employees must be in cycle and cannot be Terminated or On Leave.
Enter 'P' to pay the Flat Earnings Amount to only those employees that are already being paid in the current period.

Days Storage Bank Table

When Table End Type is 'Y' EARS:

Table End Years

Enter the number of years an employee must be at this table level before an increment will take place. The employees' number of years is calculated using the employees date from the table end dates compared against the table end point date.

Hours Table Limit

Enter the maximum number of hours/days to be stored (limit does not apply to deposits). A zero or empty limit implies no limit. This limit can optionally be prorated by the employee's FTE(s).

Prorate Hours Limit

Enter 'N' when the hours limit should not be prorated.
Enter 'F' when the hours limit should be prorated by the employee's total FTE from all active function lines.
Enter 'M' when the hours limit should be prorated by the employee's master function line FTE.

Rollover Bank

Enter a rollover storage bank code. When a storage bank is cleared the hours/earnings can be rolled into another storage bank. When the rollover bank is left blank the clearing of a storage bank will zero the storage bank balances.

The rollover process takes place before the calculation and pay out of storage banks for the period defined by the clearing.

Clearing of a storage bank is defined in the payroll calendar for the appropriate pay period.

When A Rollover Bank is Entered:

Enforce Bank Limit

Enter 'N' to have the full bank balances rolled over.
Enter 'Y' to have the rollover bank's limits be applied when the rollover takes place. When the rollover bank's limits are to be enforced, the full hours and/or earnings will be rollover then an adjustment rollover entry will be created to reduce the rollover bank's balances according to the bank limit values. The reducing rollover entry will be generated with a reason of 'ROLL OVER LIMITED'.

Rollover Negative Balance

Enter 'Y' to have the bank balance rollover when the balance is negative.
Enter 'N' to omit rolling over the bank balance when the balance is negative. The balance will remain in the bank.
Enter 'C' to omit rolling over the bank balance when the balance is negative but still clear the negative balance.

All/Paid Employees

Enter 'A' if the storage bank value is to be given to all active employees.
Enter 'P' if the storage bank value is to be given only to employees who received pay in the payroll run.

Print Balances

Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.
Enter 'N' to block the printing of the storage bank balance.
Enter 'S' if the storage bank balance is to be printed even if the storage bank is suspended.

Negative Balance

Enter 'Y' if a storage bank can go negative during storage bank withdrawal.
Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.
Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative. The timesheet entry will still be processed.

The negative balance control will also be applied to negative storage bank deposits. NOTE: Refer to Negative Balance documentation under the Storage Bank Table introduction documentation.

NOTE: Storage bank table set to 'W'arn or 'Y' es:

Hours Decimal Place

Hours will carry up to four decimals of precision. Enter a value from 1 to 4 to indicate the precision to be used during the hours calculations.

Bank Cycle

Leave the storage bank cycle code blank when the storage bank is to be calculated when ever eligible hours/earnings are available.

Enter a predefined storage bank cycle code that controls when the storage bank will be calculated.

A bank cycle code of '*' indicates the storage bank table is suspended.

The employee's individual bank cycle code takes precedence.

Increment Hours Level

This field is used in conjunction with the Salary Grid Increment By Storage Bank process.

Enter the number of hours an employee's storage bank must accumulate to be eligible for a salary grid increment. This field would only apply if Storage Bank Table Transactions is set to accumulate hours.

Global Storage Bank Table

Print Balances

Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.
Enter 'N' to block the printing of the storage bank balance.
Enter 'S' to print the storage bank balance even if the bank is suspended.

Negative Balance

Enter 'Y' is a storage bank can go negative during storage bank withdrawal.
Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.
Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative. The timesheet entry will still be processed.

The negative balance control is also applied to negative storage bank deposits.

NOTE: Storage bank table set to 'W'arn or 'Y' es:

Deduction Storage Bank Table

When Table End Type is 'A'CCUMULATION:

Table End Earnings

Enter the total earnings that must be accumulated before the employee will automatically increment to the next bank table.

When Table End Type is 'Y' EARS:

Table End Years

Enter the number of years an employee must be at this table level before an increment will take place. The employees number of years is calculated using the employees date from the table end dates compared against the table end point date.

Print Balances

Enter 'Y' if the storage bank balance is to appear on the cheque and/or earnings statement. Suspended storage banks will not be included.
Enter 'N' to block the printing of the storage bank balance.

Enter 'S' to print the storage bank balance even if the bank is suspended.

Negative Balance

Enter 'Y' is a storage bank can go negative during storage bank withdrawal.
Enter 'N' if a storage bank is not allowed to go negative due to storage bank withdrawals. During timesheet entry you will be prevented from doing storage bank withdrawals if the results will generate a negative balance.
Enter 'W' if you want a warning message displayed during timesheet entry when a storage bank withdrawal will cause the storage bank to go negative. The timesheet entry will still be processed

The negative balance control is also applied to negative storage bank deposits.

NOTE: Storage bank table set to 'W'arn or 'Y' es:

Deduction Storage Bank Table

Deduction List

Enter the deduction codes which are to be included/excluded in the earnings calculation.
Enter I/##,##,##, where the ## are the deduction codes to include as eligible earnings for this storage bank calculation.
or (if the list is shorter):
Enter E/##,##,##, where the ## are the deduction codes to excluded from the earnings calculation, all other pay codes will be included.

Bank CycleAccrual Hours

Leave the storage bank cycle code blank when the storage bank is to be calculated when ever eligible hours/earnings are available.

Enter a predefined storage bank cycle code which will control when the storage bank will be calculated.

A bank cycle code of '*' indicates the storage bank table is suspended.

The employee's individual bank cycle code takes precedence.

Earn Percentage

Enter the percentage of eligible deductions to be accumulated. Enter 100.00 to accumulate the full deduction amount.

Earnings Table Limit

Enter the maximum amount of deductions to be accumulated. A zero or empty limit implies no limit.