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

# EmployeeById: Fortnox Employee by ID

`read only` `REST`

- Catalog: `Fortnox`
- Schema: `Employees`
- Label: Employee by ID

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

Can only retrieve data.

## 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/{EmployeeId}`
- Operation: `get /3/employees/{EmployeeId}`

## Performance Characteristics

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

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `EmployeeId` | `` | [x] |  | identifies the employee |
| `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 `EmployeeById` 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 |
|---|---|---|:---:|---|---|
| `Employee_ATFValue` | `double` | itgen_fnx_employee_atfvalue | [ ] | filters on the platform, writable, `Employee.ATFValue` |  |
| `Employee_ATKValue` | `double` | itgen_fnx_employee_atkvalue | [ ] | filters on the platform, writable, `Employee.ATKValue` |  |
| `Employee_AbsenceHoursNonVacationBased` | `double` | itgen_fnx_employee_absencehoursnonvacationbased | [ ] | filters on the platform, writable, `Employee.AbsenceHoursNonVacationBased` |  |
| `Employee_AbsenceHoursVacationBased` | `double` | itgen_fnx_employee_absencehoursvacationbased | [ ] | filters on the platform, writable, `Employee.AbsenceHoursVacationBased` |  |
| `Employee_AbsenceWorkdaysNonVacationBased` | `double` | itgen_fnx_employee_absenceworkdaysnonvacationbased | [ ] | filters on the platform, writable, `Employee.AbsenceWorkdaysNonVacationBased` |  |
| `Employee_AbsenceWorkdaysVacationBased` | `double` | itgen_fnx_employee_absenceworkdaysvacationbased | [ ] | filters on the platform, writable, `Employee.AbsenceWorkdaysVacationBased` |  |
| `Employee_Address1` | `varchar2` | Employee Address 1 | [ ] | filters on the platform, writable, `Employee.Address1` |  |
| `Employee_Address2` | `varchar2` | Employee Address 2 | [ ] | filters on the platform, writable, `Employee.Address2` |  |
| `Employee_AutoNonRecurringTax` | `char` | Employee Auto Non Recurring Tax | [ ] | filters on the platform, writable, `Employee.AutoNonRecurringTax` |  |
| `Employee_AverageHourlyWage` | `varchar2` | Employee Average Hourly Wage | [ ] | filters on the platform, writable, `Employee.AverageHourlyWage` |  |
| `Employee_AverageWeeklyHours` | `varchar2` | Employee Average Weekly Hours | [ ] | filters on the platform, writable, `Employee.AverageWeeklyHours` |  |
| `Employee_BankAccountNo` | `varchar2` | Employee Bank Account No | [ ] | filters on the platform, writable, `Employee.BankAccountNo` |  |
| `Employee_City` | `varchar2` | Employee City | [ ] | filters on the platform, writable, `Employee.City` |  |
| `Employee_ClearingNo` | `varchar2` | Employee Clearing No | [ ] | filters on the platform, writable, `Employee.ClearingNo` |  |
| `Employee_CostCenter` | `varchar2` | Employee Cost Centre | [ ] | filters on the platform, writable, `Employee.CostCenter` |  |
| `Employee_Country` | `varchar2` | Employee Country | [ ] | filters on the platform, writable, `Employee.Country` |  |
| `Employee_CurrentCompBalance` | `double` | itgen_fnx_employee_currentcompbalance | [ ] | filters on the platform, writable, `Employee.CurrentCompBalance` |  |
| `Employee_CurrentFlexBalance` | `double` | itgen_fnx_employee_currentflexbalance | [ ] | filters on the platform, writable, `Employee.CurrentFlexBalance` |  |
| `Employee_Email` | `varchar2` | Employee Email | [ ] | filters on the platform, writable, `Employee.Email` |  |
| `Employee_EmployedTo` | `datetime` | Employee Employed To | [ ] | filters on the platform, writable, `Employee.EmployedTo` |  |
| `Employee_EmployeeId` | `varchar2(15)` | Employee Employeeid | [ ] | filters on the platform, writable, `Employee.EmployeeId` |  |
| `Employee_EmploymentDate` | `datetime` | Employee Employment Date | [ ] | filters on the platform, writable, `Employee.EmploymentDate` |  |
| `Employee_EmploymentForm` | `varchar2` | Employee Employment Form | [ ] | filters on the platform, writable, `Employee.EmploymentForm` |  |
| `Employee_FirstName` | `varchar2` | Employee First Name | [ ] | filters on the platform, writable, `Employee.FirstName` |  |
| `Employee_ForaType` | `varchar2` | Employee for Type | [ ] | filters on the platform, writable, `Employee.ForaType` |  |
| `Employee_FullName` | `varchar2` | Employee Full Name | [ ] | filters on the platform, writable, `Employee.FullName` |  |
| `Employee_FullTimeEquivalent` | `double` | itgen_fnx_employee_fulltimeequivalent | [ ] | filters on the platform, writable, `Employee.FullTimeEquivalent` |  |
| `Employee_HourlyPay` | `varchar2` | Employee Hourly Pay | [ ] | filters on the platform, writable, `Employee.HourlyPay` |  |
| `Employee_Inactive` | `char` | Employee Inactive | [ ] | filters on the platform, writable, `Employee.Inactive` |  |
| `Employee_InitialComp` | `double` | itgen_fnx_employee_initialcomp | [ ] | filters on the platform, writable, `Employee.InitialComp` |  |
| `Employee_InitialFlex` | `double` | itgen_fnx_employee_initialflex | [ ] | filters on the platform, writable, `Employee.InitialFlex` |  |
| `Employee_JobTitle` | `varchar2(30)` | Employee Job Title | [ ] | filters on the platform, writable, `Employee.JobTitle` |  |
| `Employee_LastName` | `varchar2` | Employee Last Name | [ ] | filters on the platform, writable, `Employee.LastName` |  |
| `Employee_MonthlySalary` | `varchar2` | Employee Monthly Salary | [ ] | filters on the platform, writable, `Employee.MonthlySalary` |  |
| `Employee_NonRecurringTax` | `varchar2` | Employee Non Recurring Tax | [ ] | filters on the platform, writable, `Employee.NonRecurringTax` |  |
| `Employee_NonVacationBasedCalendarDaysPartial` | `double` | itgen_fnx_employee_nonvacationbasedcalendardayspartial | [ ] | filters on the platform, writable, `Employee.NonVacationBasedCalendarDaysPartial` |  |
| `Employee_NonVacationBasedCalendarDaysWhole` | `double` | itgen_fnx_employee_nonvacationbasedcalendardayswhole | [ ] | filters on the platform, writable, `Employee.NonVacationBasedCalendarDaysWhole` |  |
| `Employee_PayslipType` | `varchar2` | itgen_fnx_employee_paysliptype | [ ] | filters on the platform, writable, `Employee.PayslipType` |  |
| `Employee_PersonalIdentityNumber` | `varchar2` | Employee Personal Identity Number | [ ] | filters on the platform, writable, `Employee.PersonalIdentityNumber` |  |
| `Employee_PersonelType` | `varchar2` | Employee Personnel Type | [ ] | filters on the platform, writable, `Employee.PersonelType` |  |
| `Employee_Phone1` | `varchar2` | Employee Phone 1 | [ ] | filters on the platform, writable, `Employee.Phone1` |  |
| `Employee_Phone2` | `varchar2` | Employee Phone 2 | [ ] | filters on the platform, writable, `Employee.Phone2` |  |
| `Employee_PostCode` | `varchar2` | Employee Postcode | [ ] | filters on the platform, writable, `Employee.PostCode` |  |
| `Employee_PreliminaryTaxDeducted` | `double` | itgen_fnx_employee_preliminarytaxdeducted | [ ] | filters on the platform, writable, `Employee.PreliminaryTaxDeducted` |  |
| `Employee_Project` | `varchar2` | Employee Project | [ ] | filters on the platform, writable, `Employee.Project` |  |
| `Employee_SalaryForm` | `varchar2` | Employee Salary Form | [ ] | filters on the platform, writable, `Employee.SalaryForm` |  |
| `Employee_ScheduleId` | `varchar2` | Employee Schedule ID | [ ] | filters on the platform, writable, `Employee.ScheduleId` |  |
| `Employee_TaxAllowance` | `varchar2` | Employee Tax Allowance | [ ] | filters on the platform, writable, `Employee.TaxAllowance` |  |
| `Employee_TaxColumn` | `int32` | Employee Tax Column | [ ] | filters on the platform, writable, `Employee.TaxColumn` |  |
| `Employee_TaxTable` | `varchar2` | Employee Tax Table | [ ] | filters on the platform, writable, `Employee.TaxTable` |  |
| `Employee_VacationBasedAttendanceDays` | `double` | itgen_fnx_employee_vacationbasedattendancedays | [ ] | filters on the platform, writable, `Employee.VacationBasedAttendanceDays` |  |
| `Employee_VacationBasedAttendanceHours` | `double` | itgen_fnx_employee_vacationbasedattendancehours | [ ] | filters on the platform, writable, `Employee.VacationBasedAttendanceHours` |  |
| `Employee_VacationBasedCalendarDaysWhole` | `double` | itgen_fnx_employee_vacationbasedcalendardayswhole | [ ] | filters on the platform, writable, `Employee.VacationBasedCalendarDaysWhole` |  |
| `Employee_VacationBasedSalaryTotal` | `double` | itgen_fnx_employee_vacationbasedsalarytotal | [ ] | filters on the platform, writable, `Employee.VacationBasedSalaryTotal` |  |
| `Employee_VacationBasedSalaryVariableAddition` | `double` | itgen_fnx_employee_vacationbasedsalaryvariableaddition | [ ] | filters on the platform, writable, `Employee.VacationBasedSalaryVariableAddition` |  |
| `Employee_VacationBasedSalaryWorkedTime` | `double` | itgen_fnx_employee_vacationbasedsalaryworkedtime | [ ] | filters on the platform, writable, `Employee.VacationBasedSalaryWorkedTime` |  |
| `Employee_VacationCalculationAdvanceVacationDebt` | `double` | itgen_fnx_employee_vacationcalculationadvancevacationdebt | [ ] | filters on the platform, writable, `Employee.VacationCalculationAdvanceVacationDebt` |  |
| `Employee_VacationCalculationIncludeInCalculation` | `char` | itgen_fnx_employee_vacationcalculationincludeincalculation | [ ] | filters on the platform, writable, `Employee.VacationCalculationIncludeInCalculation` |  |
| `Employee_VacationCalculationSameWagePercent` | `char` | itgen_fnx_employee_vacationcalculationsamewagepercent | [ ] | filters on the platform, writable, `Employee.VacationCalculationSameWagePercent` |  |
| `Employee_VacationCalculationSoleCustody` | `char` | itgen_fnx_employee_vacationcalculationsolecustody | [ ] | filters on the platform, writable, `Employee.VacationCalculationSoleCustody` |  |
| `Employee_VacationCalculationSumOnlyNoDays` | `char` | itgen_fnx_employee_vacationcalculationsumonlynodays | [ ] | filters on the platform, writable, `Employee.VacationCalculationSumOnlyNoDays` |  |
| `Employee_VacationCalculationTotalVacationSalarySum` | `double` | itgen_fnx_employee_vacationcalculationtotalvacationsalarysum | [ ] | filters on the platform, writable, `Employee.VacationCalculationTotalVacationSalarySum` |  |
| `Employee_VacationCalculationVacationEntitlement` | `double` | itgen_fnx_employee_vacationcalculationvacationentitlement | [ ] | filters on the platform, writable, `Employee.VacationCalculationVacationEntitlement` |  |
| `Employee_VacationCalculationVariableAdditionSum` | `double` | itgen_fnx_employee_vacationcalculationvariableadditionsum | [ ] | filters on the platform, writable, `Employee.VacationCalculationVariableAdditionSum` |  |
| `Employee_VacationDaysPaid` | `double` | Employee Vacation Days Paid | [ ] | filters on the platform, writable, `Employee.VacationDaysPaid` |  |
| `Employee_VacationDaysPendingPaid` | `double` | Employee Vacation Days Pending Paid | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingPaid` |  |
| `Employee_VacationDaysPendingPrepaid` | `double` | Employee Vacation Days Pending Prepaid | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingPrepaid` |  |
| `Employee_VacationDaysPendingSaved` | `double` | Employee Vacation Days Pending Saved | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSaved` |  |
| `Employee_VacationDaysPendingSavedYear1` | `double` | Employee Vacation Days Pending Saved Year 1 | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear1` |  |
| `Employee_VacationDaysPendingSavedYear2` | `double` | Employee Vacation Days Pending Saved Year 2 | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear2` |  |
| `Employee_VacationDaysPendingSavedYear3` | `double` | Employee Vacation Days Pending Saved Year 3 | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear3` |  |
| `Employee_VacationDaysPendingSavedYear4` | `double` | Employee Vacation Days Pending Saved Year 4 | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear4` |  |
| `Employee_VacationDaysPendingSavedYear5` | `double` | Employee Vacation Days Pending Saved Year 5 | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear5` |  |
| `Employee_VacationDaysPendingSavedYear6Plus` | `double` | Employee Vacation Days Pending Saved Year 6 Plus | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingSavedYear6Plus` |  |
| `Employee_VacationDaysPendingUnpaid` | `double` | Employee Vacation Days Pending Unpaid | [ ] | filters on the platform, writable, `Employee.VacationDaysPendingUnpaid` |  |
| `Employee_VacationDaysPrepaid` | `double` | Employee Vacation Days Prepaid | [ ] | filters on the platform, writable, `Employee.VacationDaysPrepaid` |  |
| `Employee_VacationDaysRegisteredPaid` | `double` | Employee Vacation Days Registered Paid | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredPaid` |  |
| `Employee_VacationDaysRegisteredPrepaid` | `double` | Employee Vacation Days Registered Prepaid | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredPrepaid` |  |
| `Employee_VacationDaysRegisteredSaved` | `double` | Employee Vacation Days Registered Saved | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSaved` |  |
| `Employee_VacationDaysRegisteredSavedYear1` | `double` | Employee Vacation Days Registered Saved Year 1 | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear1` |  |
| `Employee_VacationDaysRegisteredSavedYear2` | `double` | Employee Vacation Days Registered Saved Year 2 | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear2` |  |
| `Employee_VacationDaysRegisteredSavedYear3` | `double` | Employee Vacation Days Registered Saved Year 3 | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear3` |  |
| `Employee_VacationDaysRegisteredSavedYear4` | `double` | Employee Vacation Days Registered Saved Year 4 | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear4` |  |
| `Employee_VacationDaysRegisteredSavedYear5` | `double` | Employee Vacation Days Registered Saved Year 5 | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear5` |  |
| `Employee_VacationDaysRegisteredSavedYear6Plus` | `double` | Employee Vacation Days Registered Saved Year 6 Plus | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredSavedYear6Plus` |  |
| `Employee_VacationDaysRegisteredUnpaid` | `double` | Employee Vacation Days Registered Unpaid | [ ] | filters on the platform, writable, `Employee.VacationDaysRegisteredUnpaid` |  |
| `Employee_VacationDaysSaved` | `double` | Employee Vacation Days Saved | [ ] | filters on the platform, writable, `Employee.VacationDaysSaved` |  |
| `Employee_VacationDaysSavedEmploymentRateYear1` | `double` | Employee Vacation Days Saved Employment Rate Year 1 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear1` |  |
| `Employee_VacationDaysSavedEmploymentRateYear2` | `double` | Employee Vacation Days Saved Employment Rate Year 2 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear2` |  |
| `Employee_VacationDaysSavedEmploymentRateYear3` | `double` | Employee Vacation Days Saved Employment Rate Year 3 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear3` |  |
| `Employee_VacationDaysSavedEmploymentRateYear4` | `double` | Employee Vacation Days Saved Employment Rate Year 4 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear4` |  |
| `Employee_VacationDaysSavedEmploymentRateYear5` | `double` | Employee Vacation Days Saved Employment Rate Year 5 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear5` |  |
| `Employee_VacationDaysSavedEmploymentRateYear6Plus` | `double` | Employee Vacation Days Saved Employment Rate Year 6 Plus | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedEmploymentRateYear6Plus` |  |
| `Employee_VacationDaysSavedYear1` | `double` | Employee Vacation Days Saved Year 1 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear1` |  |
| `Employee_VacationDaysSavedYear2` | `double` | Employee Vacation Days Saved Year 2 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear2` |  |
| `Employee_VacationDaysSavedYear3` | `double` | Employee Vacation Days Saved Year 3 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear3` |  |
| `Employee_VacationDaysSavedYear4` | `double` | Employee Vacation Days Saved Year 4 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear4` |  |
| `Employee_VacationDaysSavedYear5` | `double` | Employee Vacation Days Saved Year 5 | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear5` |  |
| `Employee_VacationDaysSavedYear6Plus` | `double` | Employee Vacation Days Saved Year 6 Plus | [ ] | filters on the platform, writable, `Employee.VacationDaysSavedYear6Plus` |  |
| `Employee_VacationDaysUnpaid` | `double` | Employee Vacation Days Unpaid | [ ] | filters on the platform, writable, `Employee.VacationDaysUnpaid` |  |
| `Employee_WorkingTimeEnumeration` | `varchar2` | itgen_fnx_employee_workingtimeenumeration | [ ] | filters on the platform, writable, `Employee.WorkingTimeEnumeration` |  |



## Release Notes

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

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

