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

# EmployeeContracts: Nmbrs Company Employee Contracts

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

- Catalogo: `Nmbrs`
- Schema: `Employees`
- Etichetta: Contratti dipendenti aziendali

I dati in questa tabella sono partizionati per valore della colonna `COMPANY_CODE`.

È possibile solo recuperare i dati.

## Codice sorgente dell'API

- Servizio XML: `EmployeeService.asmx`
- Argomento XML: `Contract_GetAll_AllEmployeesByCompany`
- Percorso XML: `/nes:EmployeeContracts/nes:EmployeeContract`

## Caratteristiche prestazionali

| Characteristic | Value |
|---|---:|
| Latenza media di accesso (ms) | 48 |

Il risultato può essere memorizzato nella memoria cache sul client.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `EmployeeContracts`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `int64` | ID dell'azienda | [x] |  |  |
| `CONTRACTID` | `int32` | ID del contratto | [x] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:ContractID` |  |
| `CREATIONDATE` | `datetime` | Data di creazione | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:CreationDate` |  |
| `EMPLOYEEID` | `int32` | ID dell'impiegato | [x] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeId` |  |
| `EMPLOYEMENTTYPE` | `int32` | Tipo di impiego | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:EmployementType` |  |
| `EMPLOYMENTSEQUENCETAXID` | `int32` | Codice fiscale della sequenza occupazionale | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:EmploymentSequenceTaxId` |  |
| `ENDDATE` | `datetime` | Data di fine | [ ] | `/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` | Classificazione delle fasi | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:PhaseClassification` |  |
| `STARTDATE` | `datetime` | Data di inizio | [ ] | `/soap:Envelope/soap:Body/nes:Contract_GetAll_AllEmployeesByCompanyResponse/nes:Contract_GetAll_AllEmployeesByCompanyResult/nes:EmployeeContractItemGlobal/nes:EmployeeContracts/nes:EmployeeContract/nes:StartDate` |  |
| `TRIALPERIOD` | `datetime` | Periodo di prova | [ ] | `/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` |  |

## Chiavi

| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
| `EmployeeContracts_COMPANY_CODE_EMPLOYEEID_cnd` | `COMPANY_CODE` | [PersonalInformations](Nmbrs.Employees.PersonalInformations)`.COMPANY_CODE` | Candidate | Deriva dai nomi delle colonne ed è presente in ogni riga compilata dell'ambiente di smoke test su 2026-10-31; non è indicato da Nmbrs. |
| `EmployeeContracts_COMPANY_CODE_EMPLOYEEID_cnd` | `EMPLOYEEID` | [PersonalInformations](Nmbrs.Employees.PersonalInformations)`.EMPLOYEEID` | Candidate | Deriva dai nomi delle colonne ed è presente in ogni riga compilata dell'ambiente di smoke test su 2026-10-31; non è indicato da Nmbrs. |

## Esempi di Query

```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
```


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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