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 |
|---|---|---|---|---|
Employee |
`` | 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_ |
double |
itgen_fnx_employee_atfvalue | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_atkvalue | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_absencehoursnonvacationbased | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_absencehoursvacationbased | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_absenceworkdaysnonvacationbased | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_absenceworkdaysvacationbased | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Address 1 | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Address 2 | filters on the platform, writable, Employee. |
||
Employee_ |
char |
Employee Auto Non Recurring Tax | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Average Hourly Wage | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Average Weekly Hours | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Bank Account No | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee City | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Clearing No | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Cost Centre | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Country | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_currentcompbalance | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_currentflexbalance | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Email | filters on the platform, writable, Employee. |
||
Employee_ |
datetime |
Employee Employed To | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Employeeid | filters on the platform, writable, Employee. |
||
Employee_ |
datetime |
Employee Employment Date | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Employment Form | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee First Name | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee for Type | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Full Name | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_fulltimeequivalent | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Hourly Pay | filters on the platform, writable, Employee. |
||
Employee_ |
char |
Employee Inactive | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_initialcomp | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_initialflex | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Job Title | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Last Name | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Monthly Salary | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Non Recurring Tax | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_nonvacationbasedcalendardayspartial | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_nonvacationbasedcalendardayswhole | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
itgen_fnx_employee_paysliptype | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Personal Identity Number | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Personnel Type | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Phone 1 | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Phone 2 | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Postcode | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_preliminarytaxdeducted | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Project | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Salary Form | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Schedule ID | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Tax Allowance | filters on the platform, writable, Employee. |
||
Employee_ |
int32 |
Employee Tax Column | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
Employee Tax Table | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedattendancedays | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedattendancehours | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedcalendardayswhole | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedsalarytotal | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedsalaryvariableaddition | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationbasedsalaryworkedtime | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationcalculationadvancevacationdebt | filters on the platform, writable, Employee. |
||
Employee_ |
char |
itgen_fnx_employee_vacationcalculationincludeincalculation | filters on the platform, writable, Employee. |
||
Employee_ |
char |
itgen_fnx_employee_vacationcalculationsamewagepercent | filters on the platform, writable, Employee. |
||
Employee_ |
char |
itgen_fnx_employee_vacationcalculationsolecustody | filters on the platform, writable, Employee. |
||
Employee_ |
char |
itgen_fnx_employee_vacationcalculationsumonlynodays | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationcalculationtotalvacationsalarysum | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationcalculationvacationentitlement | filters on the platform, writable, Employee. |
||
Employee_ |
double |
itgen_fnx_employee_vacationcalculationvariableadditionsum | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Paid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Paid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Prepaid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 1 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 2 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 3 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 4 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 5 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Saved Year 6 Plus | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Pending Unpaid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Prepaid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Paid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Prepaid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 1 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 2 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 3 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 4 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 5 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Saved Year 6 Plus | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Registered Unpaid | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 1 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 2 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 3 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 4 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 5 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Employment Rate Year 6 Plus | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 1 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 2 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 3 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 4 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 5 | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Saved Year 6 Plus | filters on the platform, writable, Employee. |
||
Employee_ |
double |
Employee Vacation Days Unpaid | filters on the platform, writable, Employee. |
||
Employee_ |
varchar2 |
itgen_fnx_employee_workingtimeenumeration | filters on the platform, writable, Employee. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: