Lessor Payroll Integration - Description

This article dives into the details of what the integration contains, how to set it up and what to look out for. It is a supplement to our setup guide.

Note

Lessor Payroll is a Danish payroll system and operates only in Danish.

Integration content

In the table below is an overview of the content of the Lessor Payroll integration.

Title	Function in Lessor Payroll
Connection to Lessor Payroll	Authentication of the integration
New employee newemployee.xml	Insert data in medarbejdere til godkendelse in Lessor Payroll Note Emply People supports by default: payroll type 0012 for monthly employees wage type 0050 for hourly wage earners If you do not use the above, please check with a web service specialist.
Update employee updateemployee.xml has same content as new employeer	Inserts data in "medarbejderændringer til godkendelse" in Lessor Payroll
Termination of employee termination.xml	Terminates employee
Registration of absence Absence.xml	Inserts information of absence for employee
Departments department.xml	Creates and changes the name of departments
Lessor Payroll codes inquiry.xml	Query codes from Lessor Payroll and make them available for mapping with Emply People

*New departments are only created when a staff member is recruited and transferred within the department

Connect Emply People with Lessor Payroll

For the integration to be set up, the following criteria must be met:

The customer has ordered the integration from Emply People and it is stated in the contract.
Emply People has ordered access to the customer's Lessor Payroll solution.
Lessor Payroll web service and Inquiry have the same credentials.

This order is sent to and delivered by Emply People integration team through help center or support.

Then Emply People integration team tests and connects customer's Emply People and Lessor Payroll solutions.

* Cloud

For customers with cloud solution, Emply People integration team knows the information to be filled in under Title, Client, Username, as well as Password.

Screenshot_2022-08-24_at_13.23.48.png Title - Use client name or same as client name in Lessor Payroll

* Onprem

If the customer has OnPrem, the customer hosts and operates Lessor Payroll.

The customer must then provide

URL to Lessor Payroll installation.
Emply People servers are whitelisted our public IP addresses.
Provide and test username and password for web service and inquiry.
Book and coordinate consulting help from the Emply People integration team.

Title - Use client name or same as client name in Lessor Payroll

URL - This is known by the client

Username and password

Mapping

After the integration has connected to the customer's Lessor Payroll, you can see the bindings that are fixed and those that need to be selected with e.g. a form field or absence type.

Sk_rmbillede_2021-08-09_kl._15.15.03.png

File extraction from Lessor Payroll

The customer must provide the files to Emply People in a secure way, they can find it in their Lessor Payroll after Lessor support has formed them.

When loading the three files (Payroll.csv, hourly_salary_rates.csv and Masterdata.csv) into Excel it is important to pay attention to the following;

If data is simply imported into excel, then leading 0's will be removed from the employee code and CPR no. fields.

You must therefore do the following with the Master Data file:

Open excel - Select files and New
Select Data and then From Text/CSV
Select file and Import
Click on Transform data
Select all data with ctrl-a - right click and select Edit type, select Text, select replace current, click close, and load.
Select the files and then save them.

You must then do the following with the Payroll file

Open Excel - Select files and New
Choose Data and then From text/CSV
Choose files and Import.
Click on Transform data.
All columns should have changed type to Type, except Monthly Salary and Working Hours (Weekly) - right click and select Edit Type - select Text - select replace current - click close and load.
Select Files and then Save.

You should therefore do the following the Hourly_salary_rates file:

Open Excel– Select files and New,
Select Data and then From text/CSV.
Select files and Import.
Click on Transformer data.
All columns should have changed type to Text, except Number of hours and Hourly salary rate, select Edit type, select Text, Replace Current, click Close, and then Load.
Select the files and then press Save.

Fields of integration

The table below gives an overview of the fields that are part of the integration. It contains the name from Lessor Payroll and Emply People, the binding and where in Emply People the data comes from.

(F) = Sk_rmbillede_2021-06-30_kl._15.20.50.png The binding cannot be changed

(V) = Sk_rmbillede_2021-06-30_kl._15.21.53.png The binding has multiple choices (dynamic fields / fixed fields)

Lessor term	Type	Emply People data	Emply People binding
Employee code	Mandatory	Employee number	Standard/form
From date	Mandatory	Date of employment	Salary widget
Cpr.nr.	Mandatory	CPR number	Standard
Initials	Optional	Initials	Form
Address	Mandatory	Address	Standard
Address 2	Optional	Can be set up	Form
Postal code	Optional	Post number	Standard
Country code	Optional	Country code	Standard
Private telephone number	Optional	Private telephone number	Standard
Private mobile number	Optional	Private mobile number	Standard
Work telephone number	Optional	Work phone	Standard
Private email	Optional	Private email	Standard
Work email	Optional	Work email	Standard
Bank account number	Optional	Can be selected if NemKonto is not set up.	Form
Bank registration number	Optional	Can be selected if NemKonto is not setup.	Form
Employment	Type	Emply People data	Emply People binding
Company code - Code description Retrieved automatically via Inquiry	Mandatory	Company code	Form to set up salary widget
Production unit no.* will match Lessor Payroll	Mandatory	P-number under the company	Department-location
Organization code code description	Mandatory	Organization code	Form to set up salary widget
Date of employment	Mandatory	Date of employment	Salary widget
Date of resignation	Optional	Date of resignation	Salary widget
Reason for resignation code	Optional	Reason for resignation	Export by salary group
Settlement group code - code description	Mandatory	Select from options	Form payroll widget
Quota counter	Mandatory	Weekly working hours	Salary widget
Quota denominator	Mandatory	Weekly working hours / FTE	Working hours at the salary group
Salary level (Rate)	Optional	Monthly / hourly salary	Salary widget
Agreement	Type	Emply People data	Emply People binding
Salary seniority date	Mandatory	Seniority date	Salary widget
Job description		Position designation	Salary widget
Position profile code	Optional	Select from options	Form
Posting group code (code description)	Optional	Select from options	Form
Dimension codes (code description)	Optional	Select from options	Form
Department	Type	Emply People data	Emply Peoplebinding
Department code	Mandatory	User defined / Cost center ID	Department
Department designation	Mandatory	Internal / External title	Department
Absence	Type	Emply People data	Emply People binding
Absence start date	Mandatory	Absence start date	Absence registration
Absence end date	Mandatory	Absence end date	Absence registration
Employee code	Mandatory	Employee code
Absence codes	Optional	Absence types	Absence registration

*Mapping options are retrieved from Lessor Payroll

Form Fields

All form fields that are to be used in the integration must be shared elements. This is set up on the individual field in the form. Here, select Advanced - see below.

A payroll number is most often associated with the employee's employment and will follow the employee throughout the entire employment period, with the exception of the employee changing their form of remuneration from hourly to monthly or monthly to hourly.

(Link to remuneration form section or copy it here)

A salary number series:

The customer's Emply People solution can be set up to map with Emply People employee numbers and can make use of automatic employee number assignment when new employees are created.

Existing employees in Lessor Payroll keep their employee number and are imported into Emply People.

More number series

If the customer needs multiple number series, it will not be possible to assign automatic payroll numbers from Emply People. The employees' payroll numbers must then come from a form field.

Initials

Emply People can create initials in Lessor Payroll

Bank account number (rarely used)

Most often, the customer uses Nemkonto for salary payments and these fields are created very rarely.

Address 2

If the customer needs multiple address lines, this can be set up and mapped with the integration.

The following fields must be created as optional fields.

Company code

Separates employees at companies in Lessor Payroll.

If the customer has multiple company codes, they are entered as options - see example above.

If the customer only has 1 company code - only one option is entered and this can also be set up to be pre-filled.

Organization code

Decisive for rights in Lessor Payroll.

If the customer has multiple organization codes, they are entered as options.

If the customer only has 1 organization code - only one option is entered and this can also be set up to be pre-filled.

Settling group code

Manages payroll

Here, the settlement types the customer uses are specified, e.g. 'Month in arrears'.

Pay group code

The job profile code is crucial for the type of employment in question, for example, salaried employees or hourly employees, etc. The job profile codes are automatically retrieved into the integration.

The extract will contain a code, the customer must know the name, as these are the ones that will be used for the form field.

Posting group code

Most often used to distribute employee costs in Lessor Payroll.

Dimension code 1-8

Setting up fields in the integration

This part is described further in the setup guide.

Lessor Payroll setup guide.

Activity log

The activity log is found in the main menu by clicking Settings+Integrations and can show whether one or more transactions have gone through or failed.

Below is an example of a list of activity logs.

The red ones indicate that there was an error.
The green ones indicate that it was a success and will be visible in Lessor Payroll on the employee or under employees for approval.

You can click on Read more to get a further description of what it is about. You can see an overview and response from Lessor Payroll if registrations have failed.