invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeChildrenByEmployeeId: Fortnox Employee Children by Employee ID

read only REST

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

Release Notes

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