It’s possible to upload a document using the People API into the employee document folder. We’ve used this mechanism to allow payslips to be uploaded into People. This program takes a CSV file, re-constitutes a PDF from the CSV file into a payslip format and then loads it into the employee record. 

We’ve also released the source code so you can modify the program for your own specific needs. 

Download the STAR Payslip Generator HERE

Mapping the CSV Data

Take a look at the file: PayslipDataAnnotated.xlsx. This file is a copy of the input file that you must create for the loader program to re-constitute the payslip. Below (and attached as Payslip.jpg) you will find the annotated payslip that is produced, the Red lettering maps across to the columns in the spreadsheet, showing you the mapping

We’ve included a sample data file as well, called SampleData.csv.

Download the Sample Data HERE

Specific Rules for Dynamic Pay and Deduction Elements 

STAR payroll export may not always output all the entitlement an deductions so the program will map the entitlements and deductions onto the payslip as follows:

- Columns W onwards in the SampleData.csv:

a. if Row 2 contains word Total and the value is non-zero then print in the Payments section of thepayslip

b. If Row 2 contains the word Column and the value is non-zero then print in the Deductions section of the payslip 

c. If Row 1 contains either of (case insensitive check)

Ssp paid

Smp paid

Sap paid

SPP Paid

And the value is non-zero then print int he Payments section of the payslip

d. if Row 1 contains 

Er NI

Er NI

And the value is non-zero then print int the Position BW and BV section as shown on the Pay slip image in this article.

Matching the Employee Record

The program matches the data in the CSV to the People record using the NI Number within People.

Install and Run the Program

Install the program and double click on the ICON to run it. You will be prompted to enter the API Key. You need to generate an API key within People. To do this login and go to the settings option and then the API submenu. Make sure the API key is generated with a full set of permissions. 

When the program is run you will need to enter the API key into the settings. Also choose the Document Category you want the document to be loaded into. 

The system allows you to work with a UAT or Production site, because you will be testing with a small set of data you can work with your production system.

Next you will be prompted for the data file:

Select the file and load:

If your People system does not have NI numbers against specific employees you will be shown an information message

Once uploaded you will have the option to generate the PDFs:

You can click and each line and see the PDF that has been generated, and the Uploads the PDF to the employee records.

The program will confirm the data has been uploaded

You can now view the payslip in the employee record


Thanks,

Customer Services Team

Did this answer your question?