Setting Up Exemption Calculation Tables for Exemption Rules

Access the Calculation Table form.

Table Code

Enter a code that designates the table to be accessed in the Table file (F069026).

Note: This field must be numeric.

Table Type

Enter E to identify this table as a wage attachment exemption calculation table.

Table Method

Enter a value that specifies the method in which the exemption is calculated. For wage attachment exemptions, values are:

E1: Single exemption range - dollar.

The system retrieves a single exemption value based on the range within which the employee's wages fall and returns that value as a flat dollar exemption.

E2: Single exemption range - percentage.

The system retrieves a single exemption value based on the range within which the employee's wages fall and returns that value as a percentage.

E3: Progressive exemption range - percentage.

The system retrieves a progressive exemption amount, where an exemption amount is calculated for each row in which the employee's wages are greater than the upper limit or where the employee's wages fall within the upper and lower limit. If the employee's wages are greater than the upper limit, the exemption amount for that row is calculated as the upper limit minus the lower limit multiplied by the rate from the table. If the wages fall within the upper and lower limit, the exemption for that row is calculated as the wages minus the lower limit multiplied by the rate from the table. The total exemption will be the sum of each row's exemption amount.

Lower Limit

Enter the lower or minimum amount to be compared.

Upper Limit

Enter the upper or maximum amount to be compared.

Amt/Rate (amount/rate)

Enter the amount or rate to be used in the calculation.