Understanding the Control Tables

The Payroll Interface control tables, sometimes referred to as the setup tables, are a set of 10 components that you use to set up the export and import interface definitions. As shown in the following table, the components can be organized into four general usage groups. Although some dependencies exist, all 10 components work together and, for the most part, can be set up in any order.

Usage

Component

Use these components to identify the third-party payroll system and the employees who will be processed each pay period.

  • System Table (SYSTEM_TABLE) component

  • Employee Table (INTRFC_EMPLOYEE) component

Use these components to identify the PeopleSoft HCM tables and fields that store the payroll-related data, and to define the file and data formatting.

  • PS Tables (PS_TABLES) component

  • Field Definition Table (INTRFC_FIELD) component

  • Definition Table (INTRFC_DEFINITION) component

Use these components to set up additional processing for the payroll-related data. The processing can be simple (grouping fields) or more complex (invoking special COBOL routines).

  • Group Table (INTRFC_GROUP) component

  • Instance Table (INTRFC_INSTANCE) component

  • Process Table (INTRFC_PROCESS) component

Use these components to identify the export or import files and to connect the PeopleSoft HCM pay groups to the third-party payroll system for processing.

  • File Handle Table (INTRFC_FILEHANDLE) component

  • Configuration Table (INTRFC_CONFIG) component

Note: Beginning an implementation is often easier if you clone (copy) an existing interface definition. After you have created the clone, you can use the control tables to further configure the export or import interface definition.

Field or Control

Definition
Null Blank Character Flds (null blank character fields), andNull Zero Numeric Flds (null zero numeric fields)

Select to indicate whether blank and zero PeopleSoft character fields should be written to the export file as null data. Null implies no data value for the field. You can override this option at the field level.
Convert Case

Select if the system requires uppercase.

Note: You can override this setting for specific files.