Payroll Interface

The PeopleSoft Payroll Interface is a module of the PeopleSoft HRMS. It is an ultra-configurable interface program. Multiple interfaces can be defined (and I suppose nothing says they have to be Payroll systems).

There is a predefined configuration for ADP (Payroll Interface ADP Connector).

The Payroll Interface creates text files in a variety of formats.

PeopleSoft Payroll Interface is part of Oracle's PeopleSoft Enterprise Human Capital Management family of applications.

Clearing Payroll Interface tables for testing

In order to test and retest a payroll interface configuration, you need to clear down the loaded tables. Otherwise, it will not report any changes. Here are the tables to delete from - note that this woiuld delete all runs of all payroll interfaces:

DELETE FROM PS_PI_RUNCTL ;
DELETE FROM PS_PI_RUN_TBL ;
DELETE FROM PS_PI_PARTIC ;
DELETE FROM PS_PI_PARTIC_EXPT ;
DELETE FROM PS_PI_RUN_PYGRP ;
DELETE FROM PS_PI_MESSAGE ;
DELETE FROM PS_PI_EXTIO ;
DELETE FROM PS_PI_PARTIC_EXTBL ;
DELETE FROM PS_RC_PI_RUNCTL ;