EDI for R.R.S.P.

Limited Calculations

R.R.S.P. deductions are taken only when the contribution is above a minimum value - $25.00 at this time. This is a particular case of limits for deductions calculations. This is implemented as a secondary definition for deductions. F7, Limits, on the Deduction Code screen brings up a second screen to define the limits on each of the amount fields. For generality there is an upper limit and a lower limit for each of the amount fields. These values are maintained on a separate screen because (a) they are not commonly used, and (b) adding them to the basic Deduction screen would complicate programming and use of that screen. F7 does the same update as the F10, Apply, because the Limits Update uses values from the basic Deduction definition.

The Deduction Generate calls for the Deduction Limits like it calls for the Deduction Definition. The Lower Limit Type defines how the lower limit is applied. Credit amounts are not tested for limits. Zero amounts are interpreted as "not taken" and are not affected by the limits checks. If the Lower Limit Type is "M", minimum to be taken, and the amount is below the lower limit the amount is set to the lower limit. Otherwise, if the amount is below the lower limit the amount is set to zero. If the amount exceeds the upper limit the amount is set to the upper limit. The Deduction Limits program looks for an employee entry for the Deduction Code first. If there is none, it looks for a general entry for the Deduction Code. If neither are found, the lower limit is set to zero and the upper limit to all 9s.

RRSP Methodology

RRSP has its own form of EDI 820 Payment Advice. This requires that the Company Bank be different from that for other 820 Payment Advices. The Company Bank is defined through Bank Account 'RS' which also defines the RRSP Trust Account. The Bank Branch of the RRSP trust account provides the Supplier Key to be used to assemble the Company Bank for the RRSP EDI transactions. This does have one restriction when using EDI: the RRSP trust account can not be at the same branch as the corporate bank.

Normally an employee will have only one RRSP account as supported by the Employee Deposits Update. However, this can be expanded to support spousal accounts and/or RRSPs in several banks by using the general form of Deposit Codes and using several Deduction Codes for RRSPs. The system assumes that all Deposit Codes beginning with 'RS' are RRSP codes.

The generated Payment Advices are sorted into Name sequence before being sent to EDI.

Bank Information

R.R.S.P. is paid through a trust account. Each EDI entry represents two funds transfers. The first is from the company bank account to the trust account. The second is from the trust account to the Employee's R.R.S.P. account. Only one trust account is used. It must be in a different branch from the corporate bank account because the Bank Branch defines the BANKNO for EDI 820 Payment Advices and this must be different for each payment advice definition. The trust account is defined by Bank Account "RS" and gets copied to the Employee Bank data fields of every RSP EDI entry. The employee RSP Deposit entry defines the R.R.S.P. account to which the funds will be deposited. This data is copied to the R.R.S.P. Bank data fields.

EDI Functions

A second Correcting function is used to process R.R.S.P. entries. This gives full flexibility in maintaining and using all the fields on these entries. A second transfer program is needed for the R.R.S.P. entries. It is integrated into the existing Transfer function, so there is only one Transfer on the menu.