Using our Excel template, you can define your job families, job levels and job roles. You'll be able to import the file directly into Emply People, preparing you for pay transparency. Please note that you will only be able to import the template once.
Download the job architecture template here.
Caution
If you're already using Job Profiles in Emply People, you're one step ahead, and you should not use the Excel template. You'll simply need to create your job families and job levels, then connect your existing job profiles to the appropriate family and level.
-
From the main menu go to + and select .
-
Click .
-
Click .
The excel template will stored in your local download folder.
The job archtecture template has three tabs:
-
Job Level
-
Job Family
-
Job Role
In each tab, some columns are mandatory and marked with *. Others are optional and not marked.
-
Fill in the tab.
-
Fill in all your Job level titles* and make sure that they are unique.
Important
A job level title can only have one currency and one minimum/maximum salary range, so you may need to create two rows to differentiate the level for two different countries.
If you have Level 2 jobs in both Denmark, Germany and Italy, and the employees are paid in DKK and EUR and with different ranges for minimum/maximum salary, you can differentiate by creating three rows with the following titles:
-
Level 2 - DK -
Level 2 - DE -
Level 2 - IT
This allows you to indicate different currencies, and also different salary ranges for Germany and Italy that both use Euro.
-
-
Optionally, fill a of each Job level title.
-
Fill in the currency relevant to the Job level title. If you have employees paid in different currencies at the same level, you will need to create a level for each currency, see example in step 1.a.
Note
We highly recommend that you use the ISO 4217 standard for currencies
-
Fill in the Minimum salary* and Maximum salary* for the job level and yearly salary. If the minimum and maximum salaries differ for employees in different countries, but is in the same currency, e.g. EUR, you will need to create multiple rows to reflect this, similar to the example in step 1.a.
-
Optionally, fill in the Level Category, e.g. to differentiate between different Job level titles at the same level.
Tip
Once the template is imported into Emply People, you will be able to sort your Job level titles on Level category, so that you see e.g. all Job levels in Germany together.
-
-
Fill in the tab. This tab contains only your list of Job Family Titles*.
A Job family is a predefined structure that ensures consistency across industries and provides a strong foundation for classification.
-
Fill in the tab.
-
Fill in your Job role titles*.
-
Optionally, fill in the Discriptions of your Job roles.
-
Fill in your Job family* for each job role.
Important
Please make sure that all job families mentioned here are included in the tab.
-
Fill in the relevant Job level* for each job role.
Important
Please make sure that all job levels mentioned here are included in the tab.
-
Optionally, fill in the Career track title of your job roles. You can define e.g. your company's Individual contributers, managers, etc. as separate paths.
Once your job architecture is complete in the template, it is ready to be imported into Emply People, see Import Excel template job architecture
Warning
You will only be able to import the template one time, so please make sure to finalize your job architecture, before you import it into Emply People. If you need to make changes after import, these changes must be done directly in Emply People.
-
Before importing your job architecture from a file, please download and build your job architecture, see Build job architecture using the Excel template
Warning
Please note that the job architecture can only be imported from file once. After first important, any changes to the architecture must be done in Emply People.
Click your way through the task
Below you can click your way through the process and get instructions before you use the procedure in Emply People. Click in the top right corner to see the click-demo in full-screen. Hit esc to exit full screen.
-
From the main menu, click + and select .
-
Click .
-
Click .
-
Select the relevant file from your local drive and click .
After a successful import, review the created levels and profiles in the Job Architecture overview. If modifications are needed, see Create or modify job profiles
You next step is to map your employees to job profiles, see Map a job profile to an employee.
Note
If errors are reported, download the error file, correct the relevant rows in the Excel file, and upload the file again.