Testing Exports and Imports

To test export and import interface definitions, run the Payroll Interface Export and Import processes until no errors occur and the data results are correct. Import interface definitions are usually set up and tested after the export interface definition is verified.

Testing Exports

To test an export interface definition the first time:

  1. Delete the contents of the Payroll Interface tables shown below.

  2. (optional) Run the Calculate Deductions and Confirmation processes.

  3. Run a full-records Export process.

    Use the Pay Run ID prior to the pay run that is to be used for production.

  4. When the Export process completes, check for errors.

Delete the content of these tables before running the Export process the first time:

  • PI_RUNCTL

  • PI_RUN_TBL

  • PI_RUN_PYGRP

  • PI_PARTIC

  • PI_PARTIC_EXPT

  • PI_EXTIO

  • PI_PARTIC_EXTBL

  • PI_MESSAGE

  • DED_LINE

  • DED_CALC

  • DED_MESSAGE

Testing Imports

To test the import interface definition the first time:

  1. Delete the contents of the Payroll Interface tables shown in the succeeding table.

  2. Obtain a copy of the import file that is produced by the third-party payroll system.

  3. Run the Import process.

    Use the pay run ID for the associated Export process.

  4. When the Import process finishes, check for errors.

Delete the content of these tables before running the Import process the first time:

  • PI_RUNCTL

  • PI_RUN_TBL

  • PI_RUN_PYGRP

  • PI_MESSAGE

  • PI_EXTIO

  • PI_CHECK

  • PI_EARN_DETAIL

  • PI_DED_DETAIL

  • PI_TAX_DETAIL

  • PI_EARN_BAL

  • PI_DED_BAL

  • PI_TAX_BAL

Related Topics