How to Import a Payroll Deduction File for OITP

The Import Payroll Deduction File process allows users to validate and import benefit records based on data sent to them via a .txt file from OTIP.  OTIP will provide the deduction file MONTHLY prior to the month that the file needs to be imported for.  These are picked up by the board through OTIP’s SFTP site. Boards can assign the same OTIP Mapping for Client ID/Class/Plan combination to more than one Employee Group Code

          1. Click on Benefits

          2. Click on Imports and Exports

          3. Click on Import Payroll Deduction File

          4. Select a Start Date value

          5. Select an End Date value

          6. Select a Payroll Deduction File to Import path

          7. Select a Submit Mode value (i.e Trial)

                              Selecting 'Trial' mode will generate a test document of all updated records when submitted, but will not actually update the records within the database until submitted in 'Update' Mode.

          8. Click on the Submit button to Import the file. (The file will be imported from the default logfile location)