Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeePersonalInfoContractSalaryAddresses

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: PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompany

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

XPath: /nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress

Filters on API Server: CompanyID

Default Namespace Prefix: nes

Table Columns

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

Name

Data Type

Label

Required

Documentation

BIRTHDAY

datetime

Birthday

 

BSN

string

Social Security Number

 

CITY

string

City

 

COMPANY_CODE

int64

Company ID

 

CONTRACTENDDATE

datetime

Contract End Date

 

CONTRACTHOURS

decimal

Contract Hours

 

CONTRACTSTARTDATE

datetime

Contract Start Date

 

EMAILPRIVATE

string

Email Address Private

 

EMAILWORK

string

Email Address Work

 

EMPLOYEEID

int32

Employee ID

 

EMPLOYEENUMBER

int32

Employee Number

 

FIRSTNAME

string

First Name

 

GENDER

string

Gender

One of 'undefined', 'male', 'female'.

HOURLYWAGE

decimal

Hourly Wage

 

HOUSENUMBER

string

House Number

 

HOUSENUMBERADDITION

string

House Number Addition

 

LASTNAME

string

Last Name

 

POSTCODE

string

Postal Code

 

PREFIX

string

Prefix

 

SALARYTYPE

string

Salary 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'.

SALARYVALUE

decimal

Salary Value

 

STREET

string

Street

 

TELEPHONEMOBILEPRIVATE

string

Mobile Phone Private

 

TELEPHONEMOBILEWORK

string

Mobile Phone Work

 

TELEPHONEPRIVATE

string

Phone Private

 

TELEPHONEWORK

string

Phone Work

 

 

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