EmployeePersonalInformationByEmployeeYearPeriod: Nmbrs Employee Period Year Personal Information
read only XML
- Catalog:
Nmbrs - Schema:
Employees - Label: Employee Period Year Personal Information
Can only retrieve data.
API Source
- XML service:
EmployeeService.asmx - XML topic:
PersonalInfo_Get - XML path:
/nes:PersonalInfo_GetResult
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 48 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Employee |
number |
Numeric ID of employee. | ||
Period |
number |
Payroll period within year. | ||
Year |
number |
Payroll year. |
Table Columns
The columns of the table EmployeePersonalInformationByEmployeeYearPeriod are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BIRTHDAY |
datetime |
Birthday | / |
||
BSN |
varchar2 |
Social Security Number | / |
||
BURGERLIJKESTAAT |
varchar2 |
Civil Status | / |
||
COUNTRYOFBIRTHISOCODE |
varchar2 |
Country of Birth (ISO Code) | / |
||
DECEASEDDATE |
datetime |
Deceased | / |
||
DISPLAYNAME |
varchar2 |
Display Name | / |
||
EMAILPRIVATE |
varchar2 |
Email Address Private | / |
||
EMAILWORK |
varchar2 |
Email Address Work | / |
||
EMPLOYEEID |
int32 |
Employee ID | |||
EMPLOYEENUMBER |
int32 |
Employee Number | / |
||
FIRSTNAME |
varchar2 |
First Name | / |
||
GENDER |
varchar2 |
Gender | / |
One of 'undefined', 'male', 'female'. | |
ID |
int32 |
ID | / |
||
IDENTIFICATIONNUMBER |
varchar2 |
Identification Number | / |
||
IDENTIFICATIONTYPE |
int32 |
Identification Type | / |
||
INCASEOFEMERGENCY |
varchar2 |
In Case of Emergency | / |
||
INCASEOFEMERGENCYPHONE |
varchar2 |
In Case of Emergency Phone | / |
||
INCASEOFEMERGENCYRELATION |
varchar2 |
In Case of Emergency Relation | / |
||
INITIALS |
varchar2 |
Initials | / |
||
LASTNAME |
varchar2 |
Last Name | / |
||
NAAMSTELLING |
varchar2 |
Formal Name | / |
||
NATIONALITYCODE |
int32 |
Nationality Code | / |
||
NICKNAME |
varchar2 |
Nickname | / |
||
NUMBER |
int32 |
Number | / |
||
PARTNERLASTNAME |
varchar2 |
Partner Last Name | / |
||
PARTNERPREFIX |
varchar2 |
Partner Prefix | / |
||
PLACEOFBIRTH |
varchar2 |
Place of Birth | / |
||
PREFIX |
varchar2 |
Prefix | / |
||
TELEPHONEMOBILEPRIVATE |
varchar2 |
Mobile Phone Private | / |
||
TELEPHONEMOBILEWORK |
varchar2 |
Mobile Phone Work | / |
||
TELEPHONEOTHER |
varchar2 |
Other Phone | / |
||
TELEPHONEPRIVATE |
varchar2 |
Phone Private | / |
||
TELEPHONEWORK |
varchar2 |
Phone Work | / |
||
TITLE |
varchar2 |
Title Name | / |
||
TITLEAFTER |
varchar2 |
Title After | / |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: