Please enable JavaScript to view this site.

Navigation: Schema: Employees > Tables

EmployeePersonalInformations

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

Base XPath: /soap:Envelope/soap:Body/nes:PersonalInfo_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfo_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoItem

XPath: /nes:EmployeePersonalInfos/nes:PersonalInfo_V2

Filters on API Server: CompanyID

Default Namespace Prefix: nes

Table Columns

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

Name

Data Type

Label

Required

Documentation

BIRTHDAY

datetime

Birthday

 

BSN

string

Social Security Number

 

BURGERLIJKESTAAT

string

Civil Status

 

COMPANY_CODE

int64

Company ID

 

COUNTRYOFBIRTHISOCODE

string

Country of Birth (ISO Code)

 

CREATIONDATE

datetime

Creation Date

 

DECEASEDDATE

datetime

Deceased

 

DISPLAYNAME

string

Display Name

 

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

ID

int32

ID

 

IDENTIFICATIONNUMBER

string

Identification Number

 

IDENTIFICATIONTYPE

int32

Identification Type

 

INCASEOFEMERGENCY

string

In Case of Emergency

 

INCASEOFEMERGENCYPHONE

string

In Case of Emergency Phone

 

INCASEOFEMERGENCYRELATION

string

In Case of Emergency Relation

 

INITIALS

string

Initials

 

LASTNAME

string

Last Name

 

NAAMSTELLING

string

Formal Name

 

NATIONALITYCODE

int32

Nationality Code

 

NICKNAME

string

Nickname

 

PARTNERLASTNAME

string

Partner Last Name

 

PARTNERPREFIX

string

Partner Prefix

 

PLACEOFBIRTH

string

Place of Birth

 

PREFIX

string

Prefix

 

STARTPERIOD

int32

Start Period

 

STARTYEAR

int32

Start Year

 

TELEPHONEMOBILEPRIVATE

string

Mobile Phone Private

 

TELEPHONEMOBILEWORK

string

Mobile Phone Work

 

TELEPHONEOTHER

string

Other Phone

 

TELEPHONEPRIVATE

string

Phone Private

 

TELEPHONEWORK

string

Phone Work

 

TITLE

string

Title Name

 

TITLEAFTER

string

Title After

 

 

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