This tutorial deals with Fusion Payroll, and how it functions. In this part, we will discuss about the topics of Payroll Interface and Extract Definitions.

Payroll Interface

The Payroll Interface consists of implementations where Payroll is utilised for setting up Payroll Information, rather than actually doing the Payroll Calculation itself. The Payroll Information is extracted and provided to Third Party Payroll Calculation Firms, where the actual calculation of Payroll takes place.

The Payroll Product Usage is the Payroll Interface. Elements create only Standard Earnings through templates. Other voluntary deduction elements or deduction elements will not be created by the elements.

Implementing Payroll Interface

The Payroll Interface consists of several modules which can be used to provide the required Payroll Information for the calculation of Payroll. They are listed below:

• Defining Enterprise Structures

• Defining Payroll Product Usage

• Defining Elements, Balances, and Formulas

• Managing Data Security

• Creating an Extract Definition

• Managing Payroll Processes

• Configuration Groups

• Managing Personal Payroll Information

All of the implementations listed above have been discussed in earlier tutorials, except Extract Definitions, which will be discussed below.

Extract Definitions

They are a mechanism by which you can set up data groups or data sets to extract relevant information from them to provide to the Third Party Payroll Calculation Firms. They are extensively utilised for extracting specific payroll information, such as hire information, department information, organisation information, etc.

Once an Extract Definition is created, a flow will be automatically created for it. When you run this particular payroll flow, it will go through the archive and extract the information as specified in the Extract Definition. Once the data is extracted, it will be provided (or delivered) as an output, depending upon the Extract Definition Delivery defined.

Upon setting up a data group from which information has to be extracted, the attributes that are required in the information to be brought back has to be specified.

The Extract Definitions basically contain three components: the Data Group, which is the group of data from which the required information has to be extracted; the Extract Records , which are the records that the data information is being collected from; and the Attributes , which are the actual required information that is to be extracted from the collected records.

Extract Definition Delivery specifies how the extracted data is to be shown or delivered. It can either be through a PDF, a RTF, or an XML file. Usually, a template is created, keeping the desired format in mind. The delivery is then registered to the Extract Definition to deliver the extracted information in the desired format.

Each data group is associated with a formula. This formula specifies how the data is to be extracted, how the required attributes are collected from the extracted records. The formulas are created when the Extract Definition is created, and have to be compiled.

There are seeded Extract Definitions which are available. Upon creation, the Extract Definition will go through the data groups and extract the information. Usually, the Extract Definition information is present in an XML format, which can be fed to the Extract Definition Delivery.

Extracting Payroll Information

There is a predefined Extract Definition available, which is the Global Payroll Interface. This can be used as it is to extract required Payroll Information, or it can be edited to suit more specific requirements.

The Calculate Gross Earnings process can be run for each Payroll period to update the earnings balances in the Element Result Register and the Payroll Balances Report. This can be useful in cross-checking the calculated earnings in the process and the third party payroll calculations.

To manage Extract Definitions, follow the steps below:

1. From the Navigator menu, go to Workforce Management -> Data Exchange .

2. In the Data Exchange Workarea, go to the Manage Extract Definitions task from the task list on the left.

3. Select your Legislative Data Group from the dropdown. Select Payroll Interface from the dropdown in the Type field. Click on the Search button.

4. From the search results, click on Global Pay Interface .

5. Click on the Switch Layout button to switch to a tree layout of the data groups.

6. Expand the section on the left to view the several Data Groups present in the Extract Definition. Click on a particular data group to view its details.

7. Once you are done with the data groups and extract records, click on the Validate link (after switching the layout back) and click on the Compile All Formula button (this is a mandatory step) .

8. Once the formulas are done compiling, click on the Submit button.

Fig. 1 - The Data Groups and their Records present, shown with a key

Fig. 2 - The fast formula generated for the Global New Hire Data

Submitting Extracts

Once the Extract Definition is defined, it has to be submitted. To do so, follow the steps below:

1. In the Data Exchange Workarea, go to the Submit Extracts task from the task list on the left.

2. Select your Legislative Data Group from the dropdown.

3. Select the Extract Definition from the list and click on the Next button on the top right-hand corner.

4. Enter the parameters and click on the Next button.

5. On the Schedule page, select a schedule for the process and finally, review the details before clicking on the Submit button.

6. Click on OK and View Checklist .

7. Select the process in the checklist and click on the View Log icon to view the extract’s log, depending on the selected delivery.

Krishnaa Lakshmanan

Add comment