Interface Definitions

Payroll Interface is a table-driven export and import engine that enables you to exchange data between PeopleSoft HCM and a third-party payroll system. Data exchanges are set up through the export and import interface definitions, which enable you to download data from or upload data to database tables:

  • The export interface definition retrieves, formats, and downloads payroll-related data from various PeopleSoft HCM tables. The Export process writes the data to either a flat file or a database table.

  • The import interface definition uploads the processed payroll results into seven Payroll Interface import tables located in PeopleSoft HCM. The Import process reads data only from ASCII files.

Export Interface Definition

The export interface definition includes the payroll setup and the interface definition. The payroll setup identifies the payroll-related data (earnings, deductions, taxes, and so forth) and determines the pay schedules (the pay groups and pay calendars that determine which employees are processed during the export run). The interface definition determines the data mapping between the PeopleSoft HCM system and the third-party payroll system, defines the SQL retrievals and any additional COBOL processing, and specifies the export file format.

This diagram illustrates the export framework:

Image: Payroll Interface export framework

This diagram illustrates the export framework:

Payroll Interface export framework

Import Interface Definition

The import interface definition is simpler—and more limited—than the export interface definition. The interface definition is set up such that the Import process can locate the import file and then load the processed payroll data into the seven Payroll Interface import tables. You do not need to set up any type of scheduling; the Import process can be run as soon as the import file is made available.

Note: The Import process does not perform data auditing or reverse translations. Depending on your implementation, you may want to write a custom Structured Query Report (SQR) program that performs these functions as well as loads the data into the seven import tables.

This diagram illustrates the import framework:

Image: Payroll Interface import framework

This diagram illustrates the import framework.

Payroll Interface import framework