Atrieve Payroll

Deduction Rate Table

The Deduction Rate Table program provides a facility to maintain rate tables for deductions that specify the use of a table as the method of calculation. Before entering this program, the deduction must have been flagged as a table deduction.

Deduction

  • Enter the deduction number that corresponds to the deduction you want to create the table for. The program will verify the deduction number and that the deduction is a table deduction. It will then display the description of the deduction beside the deduction code. Use look-up for valid deduction codes.

Table Code

  • Enter the 4 digit code to use for this table entry. Each table entry is stored in the database with the 2 digit deduction code and the 4 digit table entry number. This is the method used to access them and to compare them against the employee master file. Use look-up for a list of valid table entries.

Use Employer's Share From Deduction or Table  

  • Enter 'D' if this set of deduction table entries is to use the employer's share specified on the deduction data base. If you select this option, Employer's Share, will not show on the screen.  Use this option when the employer share would be the same value regardless of the deduction table used.

  • Enter 'T' if you want to enter the employer's share on each deduction table entry. If you select this option, Employers Share, will display and will show as a default the employer's share from the deduction code data base employer's share factor.  This option allows you to have deduction tables with different Employer Share values.

  • Enter 'N' when you do not want to remove the Employer Share field from all deduction tables attached to the current deduction. You will be returned to the previous prompt.

  • Enter 'Y' when you want to convert this set of deduction table to use the Employer Share from the Deduction code data base instead of having individual Employer Shares per deduction table.  This option removes the Employer Share field from all deduction table entries attached to the current deduction code.

Table Description

  • Enter the description that corresponds to this deduction table entry. For example, medical premium, single.

Following the full description is an 8 character optional short description field. This short description field may be left blank.

Amount

  • Enter the amount that is to be deducted from the employee for this table entry.

Vendor #

  • Enter a valid vendor number. A vendor number entered on a deduction table code is used instead of the vendor number of the deduction code database.

The deduction amount from this deduction will be invoiced to the vendor. The payroll stream, Cheque Cancellations, Manual Cheques, Year To Date Adjustments and Statement History Adjustments will all refer to the vendor numbers entered on the deduction tables.

An option "VDESC" is available on the user defined earnings statements to have the deduction table description printed instead of the deduction code description for those deduction tables containing vendor numbers. The fixed earnings statement will automatically print the deduction table description when a vendor number has been entered.

Employer Share

  • Enter the employer's share if you want the amount of the employer's share to be different than the default for this deduction table entry.

Liability GL

  • Enter a valid GL account number to be used to receive the employer and employee's share of liability as related to this deduction table.