Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeeSalaries2ByEmployeeYearPeriod

Catalog: Nmbrs

Schema: Employees

This is a read-only table function. The NMBRS API may not support changing the data or the Invantive SQL driver for NMBRS does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NMBRS API.

NMBRS API URL: EmployeeService.asmx

Topic: Salary_GetList

Base XPath: /soap:Envelope/soap:Body/nes:Salary_GetListResponse/nes:Salary_GetListResult

XPath: /nes:Salary

Filters on API Server: EmployeeId- Year- Period

Default Namespace Prefix: nes

Table Function Columns

The columns of the table function EmployeeSalaries2ByEmployeeYearPeriod are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

STARTDATE

datetime

Start Date

 

TYPE

string

Type

One of 'None', 'Bruto_Salaris_Fulltime', 'Bruto_Salaris_Partime', 'Bruto_Uurloon', 'Netto_Salaris_Partime_incl_looncomp', 'Netto_Salaris_Partime_excl_looncomp', 'Netto_Uurloon_excl_looncomp', 'Werkgerverslasten', 'Netto_Uurloon_incl_looncomp'.

VALUE

decimal

Value

 

 

27-12-2021 10:56 Version 20.2.169-PROD+3633