Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeeSalariesByEmployeeYearPeriod

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_Get

Base XPath: /soap:Envelope/soap:Body/nes:Salary_GetResponse

XPath: /nes:Salary_GetResult

Filters on API Server: EmployeeId- Year- Period

Default Namespace Prefix: nes

Table Function Columns

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

Name

Data Type

Label

Required

Documentation

EMPLOYEEID

int32

Employee ID

 

SALARYSTEP

string

Salary Step

 

SALARYSTEPDESCRIPTION

string

Salary Step Description

 

SALARYSTEPVALUE

decimal

Salary Step Value

 

SCALECODE

string

Scale Code

 

SCALEDESCRIPTION

string

Scale Description

 

SCALEPERCENTAGEMAX

decimal

Scale Maximum (%)

 

SCALEPERCENTAGEMIN

decimal

Scale Percentage Minimum

 

SCALEVALUE

decimal

Scale Value

 

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