Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeeSalaries

Catalog: Nmbrs

Schema: Employees

The data in this table is partitioned per value of the COMPANY_CODE column.

This is a read-only table. 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_GetAll_AllEmployeesByCompany

Base XPath: /soap:Envelope/soap:Body/nes:Salary_GetAll_AllEmployeesByCompanyResponse/nes:Salary_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSalaryItem

XPath: /nes:EmployeeSalaries/nes:Salary_V2

Filters on API Server: CompanyID

Default Namespace Prefix: nes

Table Columns

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

Name

Data Type

Label

Required

Documentation

COMPANY_CODE

int64

Company ID

 

CREATIONDATE

datetime

Creation Date

 

EMPLOYEEID

int32

Employee ID

 

ID

int32

ID

 

SALARYTABLECODE

int32

Salary Table Code

 

SALARYTABLEDESCRIPTION

string

Salary Table Description

 

SCALE

string

Scale

 

SCALEDESCRIPTION

string

Scale Description

 

SCALEPERCENTAGEMAX

decimal

Scale Maximum (%)

 

SCALEPERCENTAGEMIN

decimal

Scale Percentage Minimum

 

SCALEVALUE

int32

Scale Value

 

STARTDATE

datetime

Start Date

 

STEP

string

Level

 

STEPDESCRIPTION

string

Level Description

 

STEPVALUE

decimal

Level Value

 

TYPE

int32

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