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 |
|---|---|---|---|---|
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 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 |
|---|---|---|---|---|---|
ATF |
double |
itgen_fnx_atfvalue | writable, ::ancestor. |
||
ATK |
double |
itgen_fnx_atkvalue | writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absencehoursnonvacationbased | writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absencehoursvacationbased | writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absenceworkdaysnonvacationbased | writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absenceworkdaysvacationbased | writable, ::ancestor. |
||
Address1 |
varchar2 |
Address Line 1 | writable, ::ancestor. |
||
Address2 |
varchar2 |
Address Line 2 | writable, ::ancestor. |
||
Approved |
int32 |
Approved Days | writable, Approved |
||
Auto |
char |
Auto Non Recurring Tax | writable, ::ancestor. |
||
Average |
varchar2 |
Average Hourly Wage | writable, ::ancestor. |
||
Average |
varchar2 |
Average Weekly Hours | writable, ::ancestor. |
||
Bank |
varchar2 |
Bank Account No | writable, ::ancestor. |
||
Child |
varchar2 |
Child | writable, Child |
||
City |
varchar2 |
City | writable, ::ancestor. |
||
Clearing |
varchar2 |
Clearing No | writable, ::ancestor. |
||
Cost |
varchar2 |
Cost Centre | writable, ::ancestor. |
||
Country |
varchar2 |
Country | writable, ::ancestor. |
||
Current |
double |
itgen_fnx_currentcompbalance | writable, ::ancestor. |
||
Current |
double |
itgen_fnx_currentflexbalance | writable, ::ancestor. |
||
Email |
varchar2 |
writable, ::ancestor. |
|||
Employed |
datetime |
Employed To | writable, ::ancestor. |
||
Employee |
varchar2 |
Employee ID | writable, Employee |
||
Employee |
varchar2 |
Employeeid 2 | writable, ::ancestor. |
||
Employment |
datetime |
Employment Date | writable, ::ancestor. |
||
Employment |
varchar2 |
Employment Form | writable, ::ancestor. |
||
First |
varchar2 |
First Name | writable, ::ancestor. |
||
Fora |
varchar2 |
For Type | writable, ::ancestor. |
||
Full |
varchar2 |
Full Name | writable, ::ancestor. |
||
Full |
double |
itgen_fnx_fulltimeequivalent | writable, ::ancestor. |
||
Hourly |
varchar2 |
Hourly Pay | writable, ::ancestor. |
||
Id |
varchar2 |
ID | writable, Id |
||
Inactive |
char |
Inactive | writable, ::ancestor. |
||
Ingoing |
int32 |
In Going Withdrawn Days | writable, Ingoing |
||
Initial |
double |
itgen_fnx_initialcomp | writable, ::ancestor. |
||
Initial |
double |
itgen_fnx_initialflex | writable, ::ancestor. |
||
Job |
varchar2 |
Job Title | writable, ::ancestor. |
||
Last |
varchar2 |
Last Name | writable, ::ancestor. |
||
Monthly |
varchar2 |
Monthly Salary | writable, ::ancestor. |
||
Non |
varchar2 |
Non Recurring Tax | writable, ::ancestor. |
||
Non |
double |
itgen_fnx_nonvacationbasedcalendardayspartial | writable, ::ancestor. |
||
Non |
double |
itgen_fnx_nonvacationbasedcalendardayswhole | writable, ::ancestor. |
||
Payslip |
varchar2 |
itgen_fnx_paysliptype | writable, ::ancestor. |
||
Personal |
varchar2 |
Personal Identity Number | writable, ::ancestor. |
||
Personel |
varchar2 |
Personnel Type | writable, ::ancestor. |
||
Phone1 |
varchar2 |
Phone 1 | writable, ::ancestor. |
||
Phone2 |
varchar2 |
Phone 2 | writable, ::ancestor. |
||
Post |
varchar2 |
Postal Code | writable, ::ancestor. |
||
Preliminary |
double |
itgen_fnx_preliminarytaxdeducted | writable, ::ancestor. |
||
Project |
varchar2 |
Project | writable, ::ancestor. |
||
Salary |
varchar2 |
Salary Form | writable, ::ancestor. |
||
Schedule |
varchar2 |
Schedule ID | writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Allowance | writable, ::ancestor. |
||
Tax |
int32 |
Tax Column | writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Table | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedattendancedays | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedattendancehours | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedcalendardayswhole | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalarytotal | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalaryvariableaddition | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalaryworkedtime | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationadvancevacationdebt | writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationincludeincalculation | writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsamewagepercent | writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsolecustody | writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsumonlynodays | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationtotalvacationsalarysum | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationvacationentitlement | writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationvariableadditionsum | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Paid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Paid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Prepaid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 1 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 2 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 3 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 4 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 5 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 6 Plus | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Unpaid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Prepaid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Paid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Prepaid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 1 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 2 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 3 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 4 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 5 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 6 Plus | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Unpaid | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 1 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 2 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 3 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 4 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 5 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 6 Plus | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 1 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 2 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 3 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 4 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 5 | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 6 Plus | writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Unpaid | writable, ::ancestor. |
||
Withdrawn |
double |
Withdrawn Days | writable, Withdrawn |
||
Working |
varchar2 |
itgen_fnx_workingtimeenumeration | writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: