invantive documentation
Invantive Support ForumsLog In / Sign Up

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 `` 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: