---
title: "Employees (Fortnox)"
description: "Employees"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Employees.Employees
original: https://documentation.invantive.eu/en/datamodels/fortnox/Fortnox.Employees.Employees
updated: 2026-11-01T16:13:15Z
license: https://documentation.invantive.eu/en/
---

# Employees: Fortnox Employees

`insert` `update` `REST`

- Catalog: `Fortnox`
- Schema: `Employees`
- Primary Keys: `EmployeeId`
- Label: Employees

Retrieve a list of employees
ScheduleId, MonthlySalary and HourlyPay reflect current values, all
 ScheduleIds are returned in DatedSchedules and all MonthlySalary and
 HourlyPay pairs are returned in DatedWages.

Can retrieve data and change data using `insert` and `update`.

## Summary

ScheduleId, MonthlySalary and HourlyPay reflect current values, all
 ScheduleIds are returned in DatedSchedules and all MonthlySalary and
 HourlyPay pairs are returned in DatedWages.

## API Source

- Endpoint: `/3/employees`
- Operation: `get /3/employees`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 356 |
| Full scan rows per minute | 587 |
| Point query rows per minute | 168 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `financialyear` | `` | [ ] |  | Selects what financial year that should be used (does not work on every table). |
| `financialyeardate` | `` | [ ] |  | Selects by date, what financial year that should be used (does not work on every table). |
| `fromdate` | `` | [ ] |  | Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). |
| `lastmodified` | `` | [ ] |  | Retrieves all records since the provided timestamp (does not work on every table). |
| `todate` | `` | [ ] |  | Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table). |

## Table Columns

The columns of the table `Employees` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ATFValue` | `double` | itgen_fnx_atfvalue | [ ] | filters on the platform, writable, `ATFValue` |  |
| `ATKValue` | `double` | itgen_fnx_atkvalue | [ ] | filters on the platform, writable, `ATKValue` |  |
| `AbsenceHoursNonVacationBased` | `double` | itgen_fnx_absencehoursnonvacationbased | [ ] | filters on the platform, writable, `AbsenceHoursNonVacationBased` |  |
| `AbsenceHoursVacationBased` | `double` | itgen_fnx_absencehoursvacationbased | [ ] | filters on the platform, writable, `AbsenceHoursVacationBased` |  |
| `AbsenceWorkdaysNonVacationBased` | `double` | itgen_fnx_absenceworkdaysnonvacationbased | [ ] | filters on the platform, writable, `AbsenceWorkdaysNonVacationBased` |  |
| `AbsenceWorkdaysVacationBased` | `double` | itgen_fnx_absenceworkdaysvacationbased | [ ] | filters on the platform, writable, `AbsenceWorkdaysVacationBased` |  |
| `Address1` | `varchar2` | Address Line 1 | [ ] | filters on the platform, writable, `Address1` |  |
| `Address2` | `varchar2` | Address Line 2 | [ ] | filters on the platform, writable, `Address2` |  |
| `AutoNonRecurringTax` | `char` | Auto Non Recurring Tax | [ ] | filters on the platform, writable, `AutoNonRecurringTax` |  |
| `AverageHourlyWage` | `varchar2` | Average Hourly Wage | [ ] | filters on the platform, writable, `AverageHourlyWage` |  |
| `AverageWeeklyHours` | `varchar2` | Average Weekly Hours | [ ] | filters on the platform, writable, `AverageWeeklyHours` |  |
| `BankAccountNo` | `varchar2` | Bank Account No | [ ] | filters on the platform, writable, `BankAccountNo` |  |
| `City` | `varchar2` | City | [ ] | filters on the platform, writable, `City` |  |
| `ClearingNo` | `varchar2` | Clearing No | [ ] | filters on the platform, writable, `ClearingNo` |  |
| `CostCenter` | `varchar2` | Cost Centre | [ ] | filters on the platform, writable, `CostCenter` |  |
| `Country` | `varchar2` | Country | [ ] | filters on the platform, writable, `Country` |  |
| `CurrentCompBalance` | `double` | itgen_fnx_currentcompbalance | [ ] | filters on the platform, writable, `CurrentCompBalance` |  |
| `CurrentFlexBalance` | `double` | itgen_fnx_currentflexbalance | [ ] | filters on the platform, writable, `CurrentFlexBalance` |  |
| `Email` | `varchar2` | Email | [ ] | filters on the platform, writable, `Email` |  |
| `EmployedTo` | `datetime` | Employed To | [ ] | filters on the platform, writable, `EmployedTo` |  |
| `EmployeeId` | `varchar2(15)` | Employee ID | [ ] | filters on the platform, writable, `EmployeeId` |  |
| `EmploymentDate` | `datetime` | Employment Date | [ ] | filters on the platform, writable, `EmploymentDate` |  |
| `EmploymentForm` | `varchar2` | Employment Form | [ ] | filters on the platform, writable, `EmploymentForm` |  |
| `FirstName` | `varchar2` | First Name | [ ] | filters on the platform, writable, `FirstName` |  |
| `ForaType` | `varchar2` | For Type | [ ] | filters on the platform, writable, `ForaType` |  |
| `FullName` | `varchar2` | Full Name | [ ] | filters on the platform, writable, `FullName` |  |
| `FullTimeEquivalent` | `double` | itgen_fnx_fulltimeequivalent | [ ] | filters on the platform, writable, `FullTimeEquivalent` |  |
| `HourlyPay` | `varchar2` | Hourly Pay | [ ] | filters on the platform, writable, `HourlyPay` |  |
| `Inactive` | `char` | Inactive | [ ] | filters on the platform, writable, `Inactive` |  |
| `InitialComp` | `double` | itgen_fnx_initialcomp | [ ] | filters on the platform, writable, `InitialComp` |  |
| `InitialFlex` | `double` | itgen_fnx_initialflex | [ ] | filters on the platform, writable, `InitialFlex` |  |
| `JobTitle` | `varchar2(30)` | Job Title | [ ] | filters on the platform, writable, `JobTitle` |  |
| `LastName` | `varchar2` | Last Name | [ ] | filters on the platform, writable, `LastName` |  |
| `MonthlySalary` | `varchar2` | Monthly Salary | [ ] | filters on the platform, writable, `MonthlySalary` |  |
| `NonRecurringTax` | `varchar2` | Non Recurring Tax | [ ] | filters on the platform, writable, `NonRecurringTax` |  |
| `NonVacationBasedCalendarDaysPartial` | `double` | itgen_fnx_nonvacationbasedcalendardayspartial | [ ] | filters on the platform, writable, `NonVacationBasedCalendarDaysPartial` |  |
| `NonVacationBasedCalendarDaysWhole` | `double` | itgen_fnx_nonvacationbasedcalendardayswhole | [ ] | filters on the platform, writable, `NonVacationBasedCalendarDaysWhole` |  |
| `PayslipType` | `varchar2` | itgen_fnx_paysliptype | [ ] | filters on the platform, writable, `PayslipType` |  |
| `PersonalIdentityNumber` | `varchar2` | Personal Identity Number | [ ] | filters on the platform, writable, `PersonalIdentityNumber` |  |
| `PersonelType` | `varchar2` | Personnel Type | [ ] | filters on the platform, writable, `PersonelType` |  |
| `Phone1` | `varchar2` | Phone 1 | [ ] | filters on the platform, writable, `Phone1` |  |
| `Phone2` | `varchar2` | Phone 2 | [ ] | filters on the platform, writable, `Phone2` |  |
| `PostCode` | `varchar2` | Postal Code | [ ] | filters on the platform, writable, `PostCode` |  |
| `PreliminaryTaxDeducted` | `double` | itgen_fnx_preliminarytaxdeducted | [ ] | filters on the platform, writable, `PreliminaryTaxDeducted` |  |
| `Project` | `varchar2` | Project | [ ] | filters on the platform, writable, `Project` |  |
| `SalaryForm` | `varchar2` | Salary Form | [ ] | filters on the platform, writable, `SalaryForm` |  |
| `ScheduleId` | `varchar2` | Schedule ID | [ ] | filters on the platform, writable, `ScheduleId` |  |
| `TaxAllowance` | `varchar2` | Tax Allowance | [ ] | filters on the platform, writable, `TaxAllowance` |  |
| `TaxColumn` | `int32` | Tax Column | [ ] | filters on the platform, writable, `TaxColumn` |  |
| `TaxTable` | `varchar2` | Tax Table | [ ] | filters on the platform, writable, `TaxTable` |  |
| `VacationBasedAttendanceDays` | `double` | itgen_fnx_vacationbasedattendancedays | [ ] | filters on the platform, writable, `VacationBasedAttendanceDays` |  |
| `VacationBasedAttendanceHours` | `double` | itgen_fnx_vacationbasedattendancehours | [ ] | filters on the platform, writable, `VacationBasedAttendanceHours` |  |
| `VacationBasedCalendarDaysWhole` | `double` | itgen_fnx_vacationbasedcalendardayswhole | [ ] | filters on the platform, writable, `VacationBasedCalendarDaysWhole` |  |
| `VacationBasedSalaryTotal` | `double` | itgen_fnx_vacationbasedsalarytotal | [ ] | filters on the platform, writable, `VacationBasedSalaryTotal` |  |
| `VacationBasedSalaryVariableAddition` | `double` | itgen_fnx_vacationbasedsalaryvariableaddition | [ ] | filters on the platform, writable, `VacationBasedSalaryVariableAddition` |  |
| `VacationBasedSalaryWorkedTime` | `double` | itgen_fnx_vacationbasedsalaryworkedtime | [ ] | filters on the platform, writable, `VacationBasedSalaryWorkedTime` |  |
| `VacationCalculationAdvanceVacationDebt` | `double` | itgen_fnx_vacationcalculationadvancevacationdebt | [ ] | filters on the platform, writable, `VacationCalculationAdvanceVacationDebt` |  |
| `VacationCalculationIncludeInCalculation` | `char` | itgen_fnx_vacationcalculationincludeincalculation | [ ] | filters on the platform, writable, `VacationCalculationIncludeInCalculation` |  |
| `VacationCalculationSameWagePercent` | `char` | itgen_fnx_vacationcalculationsamewagepercent | [ ] | filters on the platform, writable, `VacationCalculationSameWagePercent` |  |
| `VacationCalculationSoleCustody` | `char` | itgen_fnx_vacationcalculationsolecustody | [ ] | filters on the platform, writable, `VacationCalculationSoleCustody` |  |
| `VacationCalculationSumOnlyNoDays` | `char` | itgen_fnx_vacationcalculationsumonlynodays | [ ] | filters on the platform, writable, `VacationCalculationSumOnlyNoDays` |  |
| `VacationCalculationTotalVacationSalarySum` | `double` | itgen_fnx_vacationcalculationtotalvacationsalarysum | [ ] | filters on the platform, writable, `VacationCalculationTotalVacationSalarySum` |  |
| `VacationCalculationVacationEntitlement` | `double` | itgen_fnx_vacationcalculationvacationentitlement | [ ] | filters on the platform, writable, `VacationCalculationVacationEntitlement` |  |
| `VacationCalculationVariableAdditionSum` | `double` | itgen_fnx_vacationcalculationvariableadditionsum | [ ] | filters on the platform, writable, `VacationCalculationVariableAdditionSum` |  |
| `VacationDaysPaid` | `double` | Vacation Days Paid | [ ] | filters on the platform, writable, `VacationDaysPaid` |  |
| `VacationDaysPendingPaid` | `double` | Vacation Days Pending Paid | [ ] | filters on the platform, writable, `VacationDaysPendingPaid` |  |
| `VacationDaysPendingPrepaid` | `double` | Vacation Days Pending Prepaid | [ ] | filters on the platform, writable, `VacationDaysPendingPrepaid` |  |
| `VacationDaysPendingSaved` | `double` | Vacation Days Pending Saved | [ ] | filters on the platform, writable, `VacationDaysPendingSaved` |  |
| `VacationDaysPendingSavedYear1` | `double` | Vacation Days Pending Saved Year 1 | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear1` |  |
| `VacationDaysPendingSavedYear2` | `double` | Vacation Days Pending Saved Year 2 | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear2` |  |
| `VacationDaysPendingSavedYear3` | `double` | Vacation Days Pending Saved Year 3 | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear3` |  |
| `VacationDaysPendingSavedYear4` | `double` | Vacation Days Pending Saved Year 4 | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear4` |  |
| `VacationDaysPendingSavedYear5` | `double` | Vacation Days Pending Saved Year 5 | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear5` |  |
| `VacationDaysPendingSavedYear6Plus` | `double` | Vacation Days Pending Saved Year 6 Plus | [ ] | filters on the platform, writable, `VacationDaysPendingSavedYear6Plus` |  |
| `VacationDaysPendingUnpaid` | `double` | Vacation Days Pending Unpaid | [ ] | filters on the platform, writable, `VacationDaysPendingUnpaid` |  |
| `VacationDaysPrepaid` | `double` | Vacation Days Prepaid | [ ] | filters on the platform, writable, `VacationDaysPrepaid` |  |
| `VacationDaysRegisteredPaid` | `double` | Vacation Days Registered Paid | [ ] | filters on the platform, writable, `VacationDaysRegisteredPaid` |  |
| `VacationDaysRegisteredPrepaid` | `double` | Vacation Days Registered Prepaid | [ ] | filters on the platform, writable, `VacationDaysRegisteredPrepaid` |  |
| `VacationDaysRegisteredSaved` | `double` | Vacation Days Registered Saved | [ ] | filters on the platform, writable, `VacationDaysRegisteredSaved` |  |
| `VacationDaysRegisteredSavedYear1` | `double` | Vacation Days Registered Saved Year 1 | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear1` |  |
| `VacationDaysRegisteredSavedYear2` | `double` | Vacation Days Registered Saved Year 2 | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear2` |  |
| `VacationDaysRegisteredSavedYear3` | `double` | Vacation Days Registered Saved Year 3 | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear3` |  |
| `VacationDaysRegisteredSavedYear4` | `double` | Vacation Days Registered Saved Year 4 | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear4` |  |
| `VacationDaysRegisteredSavedYear5` | `double` | Vacation Days Registered Saved Year 5 | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear5` |  |
| `VacationDaysRegisteredSavedYear6Plus` | `double` | Vacation Days Registered Saved Year 6 Plus | [ ] | filters on the platform, writable, `VacationDaysRegisteredSavedYear6Plus` |  |
| `VacationDaysRegisteredUnpaid` | `double` | Vacation Days Registered Unpaid | [ ] | filters on the platform, writable, `VacationDaysRegisteredUnpaid` |  |
| `VacationDaysSaved` | `double` | Vacation Days Saved | [ ] | filters on the platform, writable, `VacationDaysSaved` |  |
| `VacationDaysSavedEmploymentRateYear1` | `double` | Vacation Days Saved Employment Rate Year 1 | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear1` |  |
| `VacationDaysSavedEmploymentRateYear2` | `double` | Vacation Days Saved Employment Rate Year 2 | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear2` |  |
| `VacationDaysSavedEmploymentRateYear3` | `double` | Vacation Days Saved Employment Rate Year 3 | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear3` |  |
| `VacationDaysSavedEmploymentRateYear4` | `double` | Vacation Days Saved Employment Rate Year 4 | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear4` |  |
| `VacationDaysSavedEmploymentRateYear5` | `double` | Vacation Days Saved Employment Rate Year 5 | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear5` |  |
| `VacationDaysSavedEmploymentRateYear6Plus` | `double` | Vacation Days Saved Employment Rate Year 6 Plus | [ ] | filters on the platform, writable, `VacationDaysSavedEmploymentRateYear6Plus` |  |
| `VacationDaysSavedYear1` | `double` | Vacation Days Saved Year 1 | [ ] | filters on the platform, writable, `VacationDaysSavedYear1` |  |
| `VacationDaysSavedYear2` | `double` | Vacation Days Saved Year 2 | [ ] | filters on the platform, writable, `VacationDaysSavedYear2` |  |
| `VacationDaysSavedYear3` | `double` | Vacation Days Saved Year 3 | [ ] | filters on the platform, writable, `VacationDaysSavedYear3` |  |
| `VacationDaysSavedYear4` | `double` | Vacation Days Saved Year 4 | [ ] | filters on the platform, writable, `VacationDaysSavedYear4` |  |
| `VacationDaysSavedYear5` | `double` | Vacation Days Saved Year 5 | [ ] | filters on the platform, writable, `VacationDaysSavedYear5` |  |
| `VacationDaysSavedYear6Plus` | `double` | Vacation Days Saved Year 6 Plus | [ ] | filters on the platform, writable, `VacationDaysSavedYear6Plus` |  |
| `VacationDaysUnpaid` | `double` | Vacation Days Unpaid | [ ] | filters on the platform, writable, `VacationDaysUnpaid` |  |
| `WorkingTimeEnumeration` | `varchar2` | itgen_fnx_workingtimeenumeration | [ ] | filters on the platform, writable, `WorkingTimeEnumeration` |  |
| `c_url` | `varchar2` | Call URL | [ ] | filters on the platform, writable, `@url` |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Fortnox](/en/release-notes/drivers?driver=fortnox)

