Copy page

Personnel tickets

Import employees in CSV format

Overview

This guide explains how to import employees from an external system into the personnel ticket system using a specific CSV format.

The CSV file may also include pensioners who are eligible for personnel ticket rights.

---

Before you start

To use this guide, you need to:

• Have your employee list available as a CSV file

---

The CSV format

Field Name	Notes	Default Value
employeeNo	Your internal employee number for this employee.
companyId	Internal company ID in the personnel ticket system. This is different from your organisations ID in Enturs organisation registry.
employmentTypeId	The type of employment. See Employment Types below.
dateOfBirth	In format "yyyy-MM-dd": "1974-11-23"
ssn	5-digit ssn
firstName	First name of employee
surname	Surname of employee
addressLine	Street address of employee
postalCode	Postal code of employee
abstainFromTicket	Whether this employee has opted out. Valid values are true and false	false
hireStartDate	Date of hire. Format "yyyy-MM-dd", "1974-11-23"
payType	The pay category. See Pay types below.
hireEndDate	The day the employee no longer works for the company. Format "yyyy-MM-dd", "1974-11-23"	""
hireEndCause	The reason for end of hire. See End Causes below.	""
disabilityGrade	The percent disability. Sensitive personal data. Number from 0 to 100.	0
disabilityFromDate	The day the disability is valid. Required if disabilityGrade > 0	""
employmentPercentage	Degree of employment. Number from 0 to 100.
employmentPercentageDate	Date the employment percentage is valid. Format "yyyy-MM-dd", "1974-11-23".	""
paidPercentage	Percentage of pay.
leaveFromDate	If employee is on leave. Format "yyyy-MM-dd", "1974-11-23".	""
isDeleted	Whether employee is deleted in the pesonnel ticket system.	false

Fields without a default value are required.

A header row is not required, but the fields must be in the order specified in the table.

Employment types

Id	Norwegian Notes
F	Fast ansatt i stilling
M	Midlertidig tilsatt i stilling
T	Tilkallingsvikar/sesong
U	Ukjent tjenesteforhold

Categories

Code	Value
1	bronze ticket
2	silver ticket

Pay types

Id	Norwegian Notes
1	Ukjent
A	Aktiv stilling
D	Delvis omsorgspermisjon
E	Red. arbeidstid etter AML 46A
F	Fødselspermisjon
L	Lånt ut til annen enhet
M	Permisjon for militær/siviltj
N	Permisjon for annen stilling i NSB
O	Omsorgspermisjon uten lønn
P	Militær/siviltjeneste uten lønn
R	Studiepermisjon uten lønn
S	Studiepermisjon m/lønn
T	Tjenestegjøring i høyere stilling
U	Permisjon m/uførepensjon
V	Delvis uførepermisjon
W	Delvis overgang til AFP
X	Permisjon, annet u/lønn

End causes

Code	Norwegian Notes
A	Overgang alderspensjon (kode 341)
B	Slutt v/overg til AS (kode 350)
D	Dødsfall (aksjonskode 320)
E	Egen oppsigelse (kode 310+330)
F	Overgang AFP/FTP (kode 349)
I	Oppsagt v/innskr. (kode 352)
M	Mangler årsaksangivelse
O	Slutt l/opplæring (kode 353)
S	Særaldersgrense (kode 345)
T	Dødsfall, tjenesteulykke (kode 321)
U	Uførepensjon/Oppsigelse ved sykdom (kode 361)
V	Slutt 6 mnd lønn (kode 354)
X	Slutt annen årsak (kode 350)
Y	Ventelønn 30 års tjeneste
Z	Avskjed (kode 351)

---

Importing employees

For importing employees, use

Request body

Code
{
  "importFile": "importFileName"
}

---

Response and behavior

A list of actually changed employees is returned. The list may be empty if all uploaded employees already exist with the identical values

The personnel ticket system calculates whether an employee is entitled to a personnel ticket and create the necessary ticket rights in the internal Entur systems for the users.

Validation

• If any birth date or SSN is invalid:

  • ❌ Nothing will be imported

  • ❌ An error message will be returned

  • The error will include:

    • Invalid birth dates
    • Invalid SSNs

---

Next steps

Guide: How to connect profiles with personnel ticket rights