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

# EmployeeContracts: Nmbrs Company Employee Contracts

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

- Catalog: `Nmbrs`
- Schema: `Employees`
- Label: Company Employee Contracts

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: `Contract_GetAll_AllEmployeesByCompany`
- XML path: `/nes:EmployeeContracts/nes:EmployeeContract`

## Performance Characteristics

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

The result can be cached on the client.

## Table Columns

The columns of the table `EmployeeContracts` 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] |  |  |
| `CONTRACTID` | `int32` | Contract ID | [x] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:ContractID` |  |
| `CREATIONDATE` | `datetime` | Creation Date | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:CreationDate` |  |
| `EMPLOYEEID` | `int32` | Employee ID | [x] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeId` |  |
| `EMPLOYEMENTTYPE` | `int32` | Employment Type | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:EmployementType` |  |
| `EMPLOYMENTSEQUENCETAXID` | `int32` | Employment Sequence Tax ID | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:EmploymentSequenceTaxId` |  |
| `ENDDATE` | `datetime` | End Date | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:EndDate` |  |
| `HOURSPERWEEK` | `decimal` | itgen_nmbrs_hoursperweek | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:HoursPerWeek` |  |
| `INDEFINITE` | `char` | Indefinite | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:Indefinite` |  |
| `PHASECLASSIFICATION` | `int32` | Phase Classification | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:PhaseClassification` |  |
| `STARTDATE` | `datetime` | Start Date | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:StartDate` |  |
| `TRIALPERIOD` | `datetime` | Trial Period | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:TrialPeriod` |  |
| `WRITTENCONTRACT` | `char` | itgen_nmbrs_writtencontract | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:WrittenContract` |  |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `EmployeeContracts_COMPANY_CODE_EMPLOYEEID_cnd` | `COMPANY_CODE` | [PersonalInformations](Nmbrs.Employees.PersonalInformations)`.COMPANY_CODE` | Candidate | Follows from the names of the columns and held in every filled row of the smoke environment on 2026-10-31; not stated by Nmbrs. |
| `EmployeeContracts_COMPANY_CODE_EMPLOYEEID_cnd` | `EMPLOYEEID` | [PersonalInformations](Nmbrs.Employees.PersonalInformations)`.EMPLOYEEID` | Candidate | Follows from the names of the columns and held in every filled row of the smoke environment on 2026-10-31; not stated by Nmbrs. |

## Sample Queries

```sql
--
-- List of contract periods of employees in Nmbrs.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/nmbrs-data-model/webhelp/nmbrs-connector-employees-employeecontracts.html
--
select *
from   Nmbrs.Employees.EmployeeContracts@nms
limit  100
```



## Release Notes

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

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

