---
title: "EmployeeEmployments (Nmbrs)"
description: "Employments"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/nmbrs/Nmbrs.Employees.EmployeeEmployments
original: https://documentation.invantive.eu/en/datamodels/nmbrs/Nmbrs.Employees.EmployeeEmployments
updated: 2026-11-01T17:57:29Z
license: https://documentation.invantive.eu/en/
---

# EmployeeEmployments: Nmbrs Employments

`popular` `read only` `per partition` `XML`

- Catalog: `Nmbrs`
- Schema: `Employees`
- Label: Employments

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

Can only retrieve data.

## API Source

- XML service: `EmployeeService.asmx`
- XML topic: `Employment_GetAll_AllEmployeesByCompany`
- XML path: `/nes:EmployeeEmployments/nes:Employment`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 48 |

The result can be cached on the client.

## Table Columns

The columns of the table `EmployeeEmployments` 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 |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `int64` | Company ID | [x] |  |  |
| `CREATIONDATE` | `datetime` | Creation Date | [ ] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeEmployments/nes:Employment/nes:CreationDate` |  |
| `EMPLOYEEID` | `int32` | Employee ID | [x] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeId` |  |
| `EMPLOYMENTID` | `int32` | Employment ID | [ ] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeEmployments/nes:Employment/nes:EmploymentId` |  |
| `ENDDATE` | `datetime` | End Date | [ ] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeEmployments/nes:Employment/nes:EndDate` |  |
| `INITIALSTARTDATE` | `datetime` | Initial Start Date | [ ] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeEmployments/nes:Employment/nes:InitialStartDate` |  |
| `STARTDATE` | `datetime` | Start Date | [ ] | `/soap:Envelope/soap:Body/nes:Employment_GetAll_AllEmployeesByCompanyResponse/nes:Employment_GetAll_AllEmployeesByCompanyResult/nes:EmployeeEmploymentItem/nes:EmployeeEmployments/nes:Employment/nes:StartDate` |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Nmbrs](/en/release-notes/drivers?driver=nmbrs)

